Catalog Source Configuration > Microsoft Azure Synapse Analytics > Before you begin
  

Before you begin

Before you create a catalog source, ensure that you have the information required to connect to the source system.
Perform the following tasks:

Verify permissions

To extract metadata and to configure other capabilities that a catalog source might include, you need account access and permissions on the source system. The permissions required might vary depending on the capability.

Permissions for metadata extraction

Ensure that you have the required permissions to enable metadata extraction.
Verify that the adninistrator performs the following tasks:

Create a connection

Before you configure the Microsoft Azure Synapse Analytics catalog source, create a connection object in Administrator.
    1In Administrator, select Connections.
    2Click New Connection.
    3Enter the following connection details:
    Property
    Description
    Connection Name
    Name of the connection.
    Each connection name must be unique within the organization. Connection names can contain alphanumeric characters, spaces, and the following special characters: _ . + -,
    Maximum length is 255 characters.
    Description
    Description of the connection. Maximum length is 4000 characters.
    Type
    Microsoft Azure Synapse Analytics
    Use Secret Vault
    Stores sensitive credentials for this connection in the secrets manager that is configured for your organization.
    This property appears only if secrets manager is set up for your organization.
    When you enable the secret vault in the connection, you can select which credentials that the Secure Agent retrieves from the secrets manager. If you don't enable this option, the credentials are stored in the repository or on a local Secure Agent, depending on how your organization is configured.
    For information about how to configure and use a secrets manager, see Secrets manager configuration.
    Runtime Environment
    The name of the runtime environment where you want to run tasks. Select a Secure Agent or serverless runtime environment.
    4Select the authentication type to connect to Microsoft Azure Synapse Analytics and enter the required properties.
    You can use the following connection modes:
    5Click Test Connection.
    6Click Save.

Admin User connection mode

This connection mode uses the client ID, user name, and password to connect to Microsoft Azure Synapse Analytics.
The following table describes the connection properties for the Admin User connection mode:
Azure Synapse Analytics Subscription ID
Subscription ID of Microsoft Azure Synapse Analytics.
Azure Synapse Analytics Client ID
The application ID or client ID of your application registered in Azure Active Directory.
Azure Synapse Analytics Username
Fully qualified user name to connect to Microsoft Azure Synapse Analytics instances. Contact your administrator for the user name.
Azure Synapse Analytics Password
Password associated with the user name. Contact your administrator for the password.

Service Principal connection mode

This connection mode uses the client ID, secret ID, and tenant ID to connect to Microsoft Azure Synapse Analytics.
The following table describes the connection properties for the Service Principal connection mode:
Azure Synapse Analytics Subscription ID
Subscription ID of Microsoft Azure Synapse Analytics.
Azure Synapse Analytics Client ID
The application ID or client ID of your application registered in Azure Active Directory.
Azure Synapse Analytics Tenant ID
The tenant ID of your application registered in Azure Active Directory.
Azure Synapse Analytics Client Secret
The client secret key to connect to Microsoft Azure Synapse Analytics instances through Azure Active Directory. Contact your administrator for the client secret key.

Proxy properties

If your organization uses an outgoing proxy server to connect to the Internet, the Secure Agent connects to Informatica Intelligent Cloud Services through the proxy server.
The following table describes Microsoft Azure Synapse Analytics connection proxy properties:
Connection property
Description
Use Proxy
Determines whether the connection uses a proxy server to connect to Microsoft Azure Synapse Analytics.
Select to use a proxy server.
Default is disabled.
Proxy Host
Host name of the outgoing proxy server.
Proxy Port
Port number of the outgoing proxy server.
Proxy Username
Name of the authenticated user of the proxy server. Required if the proxy server requires authentication.
Proxy Password
Password for the authenticated user. This is required if the proxy server requires authentication.

Create endpoint catalog sources for connection assignment

An endpoint catalog source represents a source system that the catalog source references. Before you perform connection assignment, create endpoint catalog sources and run the catalog source jobs.
You can then perform connection assignment to reference source systems and run connection-aware scans to view complete lineage with source system objects.