Prepare Database Connection

Learn about configuring database connection, system, and parameter settings for Oracle GoldenGate for Sybase.

Oracle GoldenGate for Sybase connects to Sybase ASE databases using the client libraries available in the DB-Library package of the Sybase SDK FOR SAP ASE 16.0.3. Connections are made using DSQUERY by providing the server name, database, and user information.

Configure a DSQUERY Connection in Linux

Using DSQUERY connections requires connection details to be listed in an interfaces file which needs to be created and saved in the SDK FOR SAP ASE 16.0.3 installation folder, such as /opt/sap.

Connect as the user that installed the Sybase SDK, navigate to the Sybase SDK installation directory and create a new file, called interfaces, as shown. No file extension is required.
```
cd /opt/sap 
vi interfaces
```
Add the following information to the interfaces file, editing the fields as per your environment.
```
servername        
 master tcp ether Host_IP_Address Database_Port_Number

 query tcp ether Host_IP_Address Database_Port_Number 

 #Connections using SSL 

 #master tcp ether Host_IP_Address Database_Port_Number ssl="CN=host name"

 #query tcp ether Host_IP_Address ssl="CN=<host name" 
```
Note:

It is important to follow the required layout of the connection information in the interfaces file.

For more information about the interfaces file, review the Sybase documentation available at:

https://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc35823.1572/doc/html/san1334282782407.html
The following rules are applicable to the interfaces file:
- Each SAP ASE has only one entry, although there may be multiple lines in the entry.
- Each line that follows the servername line must begin with a space or a tab
- Each element on the line must be separated by a single space.
- Each entry is separated by a blank line.
Example:
```
sybase_source
 master tcp ether 10.0.0.100 5000
 
 query tcp ether 10.0.0.100 5000
```
Save and close the file.