Oracle

From Starfish ETL
Revision as of 15:59, 20 February 2018 by Ahoekstra (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

In the "Server" box you must use the following format to connect to Oracle:

By Service Name: 

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sales-server)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=sales.us.acme.com)))

By SID: 

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sales-server)(PORT=1521))(CONNECT_DATA=(SID=mySID123)))
Retrieved from "https://wiki.starfishetl.com/index.php?title=Oracle&oldid=5426"