You can use Microsoft SQL Server authentication or Azure Active Directory authentication to connect to Microsoft Azure Synapse SQL. Based on the authentication type, you must provide the JDBC URL in the connection properties.
For information about configuring a Microsoft Azure Synapse SQL connection, see the Informatica Cloud® Data Integration Microsoft Azure Synapse SQL Connector documentation.
After you create the connection, verify the following permissions to perform the read and write operations:
Verify that either the
db_owner
privilege or the following more granular privileges are granted to the user to connect to Microsoft Azure Synapse SQL and perform read and write operations successfully:
EXEC sp_addrolemember 'db_datareader', '<user>';
// Alternately assign permission to individual table
EXEC sp_addrolemember 'db_datawriter', '<user>';
// Alternately assign permission to individual table
GRANT ALTER ANY EXTERNAL DATA SOURCE TO <user>;
GRANT ALTER ANY EXTERNAL FILE FORMAT TO <user>;
GRANT CONTROL TO <user>;
GRANT CREATE TABLE TO <user>;
Assign required privileges for tasks performed through Pre-SQL and Post-SQL commands.
Ensure that a default schema is present at the account level or user or group level in Microsoft Azure Synapse SQL.