Connect Informatica PowerCenter to Azure Synapse Analytics on Linux

You can set up and verify a connection between Informatica PowerCenter and Azure Synapse Analytics through an ODBC driver on Linux.

Prerequisites

• Configure the Informatica services.
• Install Devart ODBC Driver for Azure Synapse Analytics. For instructions, see Installation.
• Configure a data source name (DSN). For instructions, see Linux DSN Configuration.

Connect to Azure Synapse Analytics

1. Navigate to the directory where the ssgodbc.linux64 utility is located.

cd /opt/informatica/tools/debugtools/ssgodbc/linux64

2. Run the ssgodbc.linux64 utility to verify the connection to Azure Synapse Analytics.

./ssgodbc.linux64 -d <your_dsn> -v

3. Run a SQL query to retrieve data.

SELECT Id,Name FROM <table>;