Dec 28, 2016  humjm.bilus.in.net.

Perform an ssgodbc test on the ODBC connection to the database. Before this step, confirm that the odbc.ini file contains the related entry with the ODBC driver a nd all parameters required for the Data Source Name (DSN) to be functional. Navigate to INFA_HOME/tools/debugtools/ssgobdc/ Run ssgodbc as follows: Mandatory Parameters: -d - Data Source Name -u - ODBC Username -p - ODBC Password Optional Parameters: -c - column description only -g - get array size only -v - verbose output The INFA_HOME/tools/debugtools/ssgobdc/ directory contains various subdirectories with the ssgodbc executables for each of the supported operating systems.

The following example uses ssgodbc.linux64, which is the 64-bit Linux version. This is a binary file, which runs to test ODBC connectivity. The file is provided by Informatica and accepts the above mentioned parameters and tries to establish the connectivity to the database/data source as defined for the DSN.

The definition for the DSN is provided in the odbc.ini file. For extracting the definition, all the ODBC environment variables must be set to the correct path. To set the environment variables, refer to the More Information section. Note If you have PowerCenter 9.1.x, or an earlier version, download the ssgobdc utility from. Following is the example for Redhat Enterprise Linux: ssgodbc.linux64 -d -u -p -v Connected ODBC version = -- DBMS name = -Microsoft SQL Server- DBMS version = -- Driver name = -DWsqls26.so- Driver version = - (B0100, U0068)- Driver ODBC version = -03.52- More Information.