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 can be made either by using a listed connection and supplying the database server, port, database name and user information, or connections can be configured to use DSQUERY and provide the server name, database, and user information.

Both types of connections can be added from the Administration Service under the DB Connections menu in the Web UI, but using DSQUERY requires extra setup on the Oracle GoldenGate server.

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.
Once the entry has been created in the interfaces file, you can create a database connection from the Administration Service's web interface and select the Server Name option under Connection Type, listing the servername value of the interfaces file, and completing the remaining connection details.

Note:

If, during deployment creation you did not set the LD_LIBRARY_PATH and SYBASE variables in the Environment Variables section of Step 3 of the Oracle GoldenGate Configuration Assistant, then you will need to manually add any missing variables, using the values for your Sybase SDK installation, else the database connections may fail.

Environment Variables can be added from the Service Manager’s Deployments tab by expanding the deployment name and selecting Configuration. Any changes to the deployment’s configuration require that the Administration Service be restarted for the changes to take effect.