Re: [sqlalchemy] Using sqlalchemy dburi with Oracle using External Password Store (Oracle Wallet)?

2016-05-27 Thread Mike Bayer
you can always make any connect style work immediately like this: import cx_Oracle def creator(): return cx_Oracle.connect("/@PROD") engine = create_engine("oracle+cx_oracle://", creator=creator) however the "/@PROD" connect string is just an empty username/password and PROD for the DSN

Re: [sqlalchemy] Using sqlalchemy dburi with Oracle using External Password Store (Oracle Wallet)?

2016-05-27 Thread Matt Vasquez
I am able to get cx_Oracle to connect just fine using the wallet alias: import cx_Oracle db = cx_Oracle.connect("/@PROD") print db.version db.close() I just need to know how to put "/@PROD" in a URI format for sqlalchemy.. On Friday, May 27, 2016 at 9:31:35 AM UTC-5, Mike Bayer wrote: >

Re: [sqlalchemy] Using sqlalchemy dburi with Oracle using External Password Store (Oracle Wallet)?

2016-05-27 Thread Mike Bayer
get it working with regular cx_oracle first. I'm not familiar with external password store so you should ask on the cx_oracle mailing list (https://sourceforge.net/p/cx-oracle/mailman/cx-oracle-users/) On 05/27/2016 10:18 AM, Matt Vasquez wrote: down votefavorite

[sqlalchemy] Using sqlalchemy dburi with Oracle using External Password Store (Oracle Wallet)?

2016-05-27 Thread Matt Vasquez
down votefavorite I am trying to get a oracle sqlalchemy dburi working with an external password store (Oracle Wallet) I have tried using the standard sqlplus syntax for a external