Re: SQLALCHEMY_DATABASE_URI with Oracle Cloud

Yep. So already had the Oracle client installed. Just needed to add network/admin, drop the files in from the .zip wallet file, add instant client to PATH, also set ORACLE_HOME to instant client, and I can just change SQLALCHEMY_DATABASE_URI from 'oracle+cx_oracle:// username:password_at_172.20.10.5:1521/?service_name=servicename' to 'oracle+cx_oracle://username:password_at_tnsfilename'. Working great. Thanks!

On Mon, Nov 18, 2019 at 11:59 AM Jeff Smith <jeff.d.smith_at_oracle.com> wrote:

>
> https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/connecting-nodejs.html#GUID-AB1E323A-65B9-47C4-840B-EC3453F3AD53
>
>
>
> and
>
>
>
> https://cx-oracle.readthedocs.io/en/latest/user_guide/installation.html
>
>
>
> Do either of these help?
>
>
>
> *From:* Ethan Post <post.ethan_at_gmail.com>
> *Sent:* Monday, November 18, 2019 12:53 PM
> *To:* oracle-l <oracle-l_at_freelists.org>
> *Subject:* SQLALCHEMY_DATABASE_URI with Oracle Cloud
>
>
>
> Just set up an DB on Oracle cloud. Can connect from home using
> SQL*Developer and Oracle Wallet type connection. References my downloaded
> wallet in .zip file format.
>
>
>
> Anyone have a reference to how to connect from Python. I am using
> SQL*Alchemy. I have the application working with local DB using cx_oracle.
> Looking for connection string examples.
>
>
>
> Thanks for the help!
>
> - Ethan
>
> - https://e-t-h-a-n.com
> <https://urldefense.proofpoint.com/v2/url?u=https-3A__e-2Dt-2Dh-2Da-2Dn.com&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=o5fE2jVj7D7f7tJxo4eRanC2PzoNIgxaMm6ynWqFSvQ&s=_MV8RpmGXuiOK6BIsMtxEFANzjQqckL69K9dRmTP7Vo&e=>
>
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l