Oracle

From Starfish ETL
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)))