ODBC Driver for SQL Server

Connect Informatica PowerCenter to SQL Server on Linux

You can set up and verify a connection between Informatica PowerCenter and SQL Server through an ODBC driver on Linux.

Prerequisites

Connect to SQL Server

  1. Navigate to the directory where the ssgodbc.linux64 utility is located.
  2. cd /opt/informatica/tools/debugtools/ssgodbc/linux64
    
  3. Run the ssgodbc.linux64 utility to verify the connection to SQL Server.
  4. ./ssgodbc.linux64 -d <your_dsn> -v
    
  5. Run a SQL query to retrieve data.
  6. SELECT Id,Name FROM <table>;
    
A connection test and an executed SQL query.
© 2015-2025 Devart. All Rights Reserved. Request Support ODBC Forum Provide Feedback