Prerequisites to create a Microsoft Azure Synapse SQL connection

Prerequisites to create a Microsoft Azure Synapse SQL connection

Creating a Microsoft Azure Synapse SQL connection

Creating a Microsoft Azure Synapse SQL connection

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.

0 COMMENTS

We’d like to hear from you!