Introduction

ssgodbc is an interactive query tool for testing ODBC connection. You can enter a SQL statement, such as a SELECT query, and view the results. You can execute data definition language (DDL) statements to create tables and other objects.

Usecase / Scenario

• The tool can be used to troubleshoot any issues with DB sessions connected through ODBC. Many times users face issues with ODBC sessions like a connection issue, session hang, and unexpected results. You can use this tool with the same dsn in the same Informatica server to isolate the issue to be either a product issue or a Driver or a Database issue.

Features

• This tool is available for all platforms for both 32 bit and 64 bit dsn. This tool is located under: "$INFA_HOME/tools/debugtools/ssgodbc<os name><byteness>"
  Example: Here is the name of the binary for Linux 64 bit under $INFA_HOME/tools/debugtools/ssgodbc/linux64:
  ssgodbc.linux64.

Usage    

Usage: ssgodbc -d dsn -u username -p password [-t user] [-v] [-g]
-d Data Source Name
-u odbc username
-p odbc password
-v verbose output
-c column description only
-g get array size only
-t time SQLTablesW for user

Sample Run Output

Here is the sample Run output of this tool:

If all the entries inside the dsn is correctly configured, ssgodbc will successfully connect to the DB and prompt for a SQL query to be executed.

Current Limitations / Bugs

• For Windows, the ssgodbc tool is not currently packaged with the installer. However, you can copy the Windows binary from any non-Windows installation to a Windows box and run it there.

Future Enhancements

• Can be improved to include SQL binding testing.