RE: SQLALCHEMY_DATABASE_URI with Oracle Cloud

Excellent

Avoiding the steps you described is exactly why we built the ‘cloud’ type of connection in SQL Developer so you could just point to the Zip.

From: Ethan Post <post.ethan_at_gmail.com> Sent: Monday, November 18, 2019 5:51 PM
To: Jeff Smith <jeff.d.smith_at_oracle.com> Cc: oracle-l <oracle-l_at_freelists.org> Subject: 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://HYPERLINK "https://urldefense.proofpoint.com/v2/url?u=http-3A__username-3Apassword-40172.20.10.5-3A1521_-3Fservice-5Fname-3Dservicename&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=ZVh_Jw7bUb0vTNBY-JkMm-aOASIMzBATc0HW618-rUY&s=7uJmeBqXbusjGgkkiUuH5cLuZWtntkXHGjiqzbUBx8Q&e="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 <HYPERLINK "mailto:jeff.d.smith_at_oracle.com"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

HYPERLINK "https://urldefense.proofpoint.com/v2/url?u=https-3A__cx-2Doracle.readthedocs.io_en_latest_user-5Fguide_installation.html&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=ZVh_Jw7bUb0vTNBY-JkMm-aOASIMzBATc0HW618-rUY&s=fOEbT3Hq7TEA6hHuGPPKlbRi5pUvZas0lw8crzGA7eU&e="https://cx-oracle.readthedocs.io/en/latest/user_guide/installation.html

Do either of these help?

From: Ethan Post <HYPERLINK "mailto:post.ethan_at_gmail.com"post.ethan_at_gmail.com> Sent: Monday, November 18, 2019 12:53 PM To: oracle-l <HYPERLINK "mailto:oracle-l_at_freelists.org"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
• HYPERLINK "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="https://e-t-h-a-n.com

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