Connection String for Oracle


This page describes how to specify a connection string for Oracle.

Entries into the Sensitive Part field will be stored encrypted in Salesforce. If you want to secure the username also, include it in the field separated by a semi-colon.

Overcast uses the Oracle Data Provider for .NET and thus uses the following connection string syntax.
The <hostname> can be either an IP address or a system name.


Format

Enter the following text into the Connection String field

Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=<hostname>)(PORT=<port>)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=<database>))); User Id=<username>; 

Enter the following text into the Sensitive Part field

Password=<password>;

 

Sample

Enter the following text into the Connection String field

Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.10.100.10)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=dev-database))) User Id=tony 

Enter the following text into the Sensitive Part field

Password=mypassword

 

When entering any password or username that uses whitespace, it should be enclosed in double quotes, i.e., User Id="user 77";
Each time you create or modify a connection string in Overcast, validate your connection by clicking the Check button to ensure the connection can be established successfully. 

Parameter Keys

Key Description
Host ID Address or system name
Port Port
Service_Name Database name
User Id Username
Password Password

 

1. Go to the Connection Strings tab and select the New button.

 

2. Enter a Connection String Name and select "Oracle" for Connection Type. Enter your Connection String and its Sensitive Part as described above, and select Save. Description and Named Credential are optional.

 

3. Select Check to validate your connection. A green checked circle will appear once a successful connection is established.