Oracle Connector

Oracle Connector



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

Parameter
Description
Server

Oracle Connection Edit Screen