SAP IQ (Sybase IQ) can work with different JDBC connection modes : the standard "Tds" jdbc driver, or the "SQL Anywhere" driver.
Which one to choose ? Please consult your SAP/Sybase support or their documentation.
Standard Jdbc "Tds" driver
This is the most commonly used driver, it works with most use cases.
The Module only requires the "jconn4.jar" file (or the equivalent version for your IQ version).
Here is an example of how to configure the Module and the Metadata:
- driver: com.sybase.jdbc4.jdbc.SybDriver
- url: jdbc:sybase:Tds:qauasiq16-01.stambia.fr69:2638
SQL Anywhere / iAnywhere driver
This driver is necessary for some specific IQ tasks.
For example when using the LOAD TABLE utility with a data file which is not stored on the IQ server. In this case LOAD TABLE needs the "using client file" clause, which cannot be used with the standard "Tds" driver.
For more information see IQ documentation:
To use this kind of connection, you need to define a module which contains these files (or the equivalent version for your IQ version):
- sajdbc4.jar
- dbjdbc16.dll for windows
- libdbjdbc16.so for linux
All these files are available in your SAP IQ product installation.
Make sure that your metadata uses the following driver class and URL format:
- driver: sap.jdbc4.sqlanywhere.IDriver
- url: jdbc:sqlanywhere:uid=...;pwd=...;host=qauasiq16-01.stambia.fr69:2638
