Prerequisites
Before you create an SAP IQ connection to write to SAP IQ, be sure to complete the prerequisites.
Install the SAP IQ JDBC driver and Sybase client
To write data to SAP IQ databases, you need to install the SAP IQ JDBC driver and Sybase client on the Secure Agent machine.
- •Install the SAP IQ JDBC driver on the Secure Agent machine.
To install the driver, perform the following steps:
- 1From the SAP Support Portal, download the jconn4.jar SAP IQ JDBC driver.
- 2Create the informatica.sapiq folder manually in the following directory based on whether the Secure Agent machine is a Windows or a Linux machine:
Secure Agent machine | Directory |
|---|
Linux | <Secure Agent installation directory>/ext/connectors/thirdparty |
Windows | <Secure Agent installation directory>\ext\connectors\thirdparty |
- 3Copy the SAP IQ JDBC driver to the informatica.sapiq folder.
- •Install the Sybase client on the Secure Agent machine.
To install the Sybase client, perform the following steps:
- 1Download the Sybase client from the SAP website and install it on the Secure Agent machine.
- 2On Linux, additionally set the following environmental variables:
- ▪ setenv SYBASE <Sybase client directory>/sybase
- ▪ setenv SYBROOT <Sybase client directory>/sybase
- ▪ setenv IQDIR16 <Sybase client directory>/sybase/IQ-16_1
- ▪ setenv LD_LIBRARY_PATH <Sybase client directory>/sybase/IQ-16_1/lib64
- ▪ setenv PATH <Sybase client directory>/sybase/IQ-16_1/bin64
After you install the SAP IQ JDBC driver and set the environmental variables, you need to restart the Secure Agent.