Oracle

From Starfish ETL

Revision as of 15:58, 20 February 2018 by Ahoekstra (talk | contribs) (Created page with "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=...")

(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=5425"