Oracle: Difference between revisions

From Starfish ETL
Jump to navigation Jump to search
(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=...")
(No difference)

Revision as of 15:58, 20 February 2018

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)))