Connecting QuerySurge to SAP IQ with the jConnect JDBC Driver

Versions: 8.0+

JDBC connectivity to SAP IQ (formerly Sybase IQ) is achieved in much the same way as is connectivity to other databases - via a JDBC driver. SAP offers the jConnect JDBC driver (which also is used to connect to SAP ASE and SAP SQL Anywhere). This article describes how to connect to SAP IQ using the jConnect driver.

Setting up a QuerySurge Connection with the SAP jConnect JDBC Driver

A QuerySurge Connection to SAP IQ using the jConnect driver is set up using the Connection Extensibility feature of QuerySurge.

1. Obtain the jConnect JDBC driver (jconn4.jar) from a DBA or other administrative resource.
2. Deploy the jConnect JDBC driver jar to your Agent(s). The procedure for deploying a new driver to a QuerySurge Agent is here (for Agents on Windows) and here (for Agents on Linux).
3. Log into QuerySurge as a QuerySurge Admin user, and navigate to the Admin view. Steps for using the Connection Extensibility feature can be found here. To use the Connection Extensibility option in the Connection Wizard with the jConnect driver, you'll need the following information:
   
   Driver Class:
   com.sybase.jdbc4.jdbc.SybDriver
   Connection URL template: 
   jdbc:sybase:Tds:<server-or-IP>:<port>[?ServiceName=<database>]
   
   Note: The default JDBC port for this driver is 2638 (your port number may differ).
   Note: There are no forward slashes separating the protocol from the host, as there are in other driver URLs .
   
   Sample Connection URL:
   jdbc:sybase:Tds:192.168.0.88:2638?ServiceName=demo
   
   
4. After you've launched the Connection Wizard, given your Connection a name, and selected the Extensibility option, click the Next button and enter the Driver Class:
   
5. Click the Next button to enter your IQ Connection URL and authentication information:
   
   
   
   
6. You may enter an optional Test Query in order to verify that your Connection parameters are correct. A SELECT 1 query is valid in SAP IQ. However, any standard query that returns a small amount of information is appropriate - one row/one column is enough. You can use the Test Connection button if you've entered a Test Query:
   
   
7. The Connection test shows a popup indicating whether the Connection was successful:
   
   
8. 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.