Table of Contents

Search

  1. Preface
  2. Introduction to ODBC Connector
  3. ODBC connections
  4. Synchronization tasks with ODBC Connector
  5. Mappings and mapping tasks with ODBC Connector
  6. SQL ELT optimization
  7. Data type reference

ODBC Connector

ODBC Connector

Configuring the SAP IQ ODBC driver on Linux

Configuring the SAP IQ ODBC driver on Linux

Before you establish an ODBC connection to connect to SAP IQ on Linux, configure the ODBC driver.
  1. To get the SAP IQ ODBC 64-bit driver, contact Informatica Global Customer Support.
  2. Install the SAP IQ ODBC driver on the Secure Agent machine.
  3. Configure the
    odbc.ini
    file properties in the following format:
    [SAPIQ_ODBC] Driver=<SAP IQ location>/lib64/DWsyiq28.so DriverUnicodeType=1 UserID=<Username for the SAP IQ database> Password=<Password for the SAP IQ database> CommLinks=tcpip(host=hostname;port=2638) ServerName=<Server name of the SAP IQ database> DatabaseName=<Database name> AutoStop=no Charset=UTF-8 Language=EN
  4. Run the following command to export the
    odbc.ini
    file:
    Export ODBCINI=/<odbc.ini file path>/odbc.ini
  5. Restart the Secure Agent.

0 COMMENTS

We’d like to hear from you!