Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

(22 Ratings)
facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

HOW TO: Test an ODBC connection using SSGODBC
Solution
To test the ODBC connections, use the Informatica GCS tool SSGODBC.

 

From the Informatica Home (INFA_HOME) directory, do the following:

cd $INFA_HOME/tools/debugtools/ssgodbc
  1. Go to the directory corresponding to the Operating System.

    Example

    For Linux 64-bit, go to linux64.
  2. Run the ssgodbc file.

    Usage: ./ssgodbc -d dsn -u username -p password [-v]

    -d Data Source Name (specified in the odbc.ini file)
    -u ODBC username
    -p ODBC password
    -v verbose output

    Sample:

linux64.ssgodbc -d connectioninfo -u uname -p pword -v << ! > myfile.out 2>&1

./ssgodbc.linux64 -d CLAVEY -u admin -p 'password'​​​​​ -v  Connected
ODBC version        = -03.52.0000-
DBMS name           = -NetezzaSQL-
DBMS version        = -04.05.0000 Release 4.5 (P-3) [Build 7835]-
Driver name         = -libnzodbc.so-
Driver version      = -Release 5.0.8 [Build 11925]-
Driver ODBC version = -03.51-

Enter SQL string:

Note

 Put the password in single qoutes

./ssgodbc.linux64 -d IDQ_ODBC -u Administrator -p 'example@453' -v​


For versions prior to PowerCenter 9.5.x, do the following:

  1. Download the attached file.

  2. Unzip the file.

  3. Extract the file corresponding to the platform (refer to the following More Information section for the naming convention).

  4. Change the file name to ssgodbc.

  5. On UNIX only:

    1. Transfer the file to the UNIX machine using FTP (in binary mode).
    2. Change permissions for the file:
      chmod 777 ssgodbc
  6. Log in to the server machine as the PowerCenter Server user.

  7. Run the file.

    Usage: ssgodbc -d dsn -u username -p password [-v]

              -d Data Source Name (specified in odbc.ini file)
              -u ODBC username
              -p ODBC password
              -v verbose output

    Sample: ssgodbc -d connectioninfo -u uname -p pword -v << ! > myfile.out 2>&1

​​​​
More Information
Use the file corresponding to the Operating System and file type of PowerCenter/ODBC being used according to the following table:
File Name Operating System  Type of ODBC Installation
ssgodbc.aix32 AIX (32-bit or 64-bit) 32-bit
ssgodbc.aix64 AIX 64-bit 64-bit
ssgodbc.solaris32 Sun Solaris (32-bit or 64-bit SPARC) 32-bit
ssgodbc.solaris64 Sun Solaris 64-bit (SPARC) 64-bit
ssgodbc.solx86​ Sun Solaris (x86​) 64-bit​
ssgodbc.hpux32 HP-UX (32-bit or 64-bit) 32-bit
ssgodbc.hpux64 HP-UX 64-bit 64-bit
ssgodbc.linux32 Linux (32-bit or 64-bit) 32-bit
ssgodbc.linux64 Linux 64-bit 64-bit
ssgodbc.exe Windows 32-bit
Reference
Applies To
Product: PowerCenter; Data Engineering Quality(Big Data Quality)
Problem Type: Connectivity; Configuration; Stability
User Type: Administrator
Project Phase: Configure
Product Version: PowerCenter
Database: ODBC
Operating System: AIX; HP-UX; Linux; Solaris; Windows
Other Software:
Attachments
Last Modified Date:5/6/2020 12:57 AMID:15339
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)