Connecting QuerySurge to SAP ASE with the jTDS JDBC Driver

Versions: 8.0+

JDBC connectivity to SAP ASE (Adaptive Server Enterprise, formerly Sybase ASE) is achieved in much the same way as is connectivity to other databases - via a JDBC driver. There are two drivers that may be used to connect to SAP ASE: the SAP jConnect driver and the open-source jTDS driver. This article describes how to connect to SAP ASE using the jTDS open source driver.

Setting up a QuerySurge Connection with the Open Source jTDS JDBC Driver

A QuerySurge Connection to SAP ASE using the jTDS driver is set up using the QuerySurge Connection Wizard.

1. When you install your QuerySurge Agent(s), you can install the jTDS driver with the Agent by selecting the "SAP ASE (jTDS 1.3.1)" option. Otherwise, you can deploy the driver manually by downloading it here and following the procedure for deploying a driver to a QuerySurge Agent. The procedure is available here (for Agents on Windows) and here (for Agents on Linux).
   
   
2. Log into QuerySurge as a QuerySurge Admin user, and navigate to the Admin view. Launch the Connection Wizard using the Add button in the lower left of the main panel. Give your Connection a name (this is how it will appear in QuerySurge) and in the Data Source dropdown, select the ASE option. Click the Next button.
   
   
3. Enter your server name (or IP address), port and authentication information:
   
   
   Note: The default JDBC port for this driver is 5000 (your port number may differ).
   
   
4. Click the Next button to review your Connection information:
   
   
   
5. Use the Test Connection button to verify your Connection information. The Connection test shows a popup indicating whether the Connection was successful:
   
   
6. Once you have the information entered and (optionally) verified, close the popup and click the Save button to save the Connection. You're ready to use the Connection in a QueryPair.