search

seanharr11 / etlalchemy

Extract, Transform, Load: Any SQL Database in 4 lines of Code.
MIT License
556 stars 83 forks source link

ETLAlchemySource for Oracle database #58

Open lalu121212 opened 1 year ago

lalu121212 commented 1 year ago

HI,

I am using Oracle 12.1.0.2 as source database. Installed "pip install cx_Oracle==7.3", can you share me a sample source connection string similar to below mysql for Oracle. source = ETLAlchemySource("mysql://etlalchemy:etlalchemy@localhost/employees")

Thanks.

lalu121212 commented 1 year ago

I tried as below and getting error: oracle_db_source = ETLAlchemySource("oracle+cx_oracle://user:passwd@hostname/SID")

Sending source '<etlalchemy.ETLAlchemySource.ETLAlchemySource instance at 0x10d3217d0>' to destination