Before you create a catalog source, ensure that you have the information required to connect to the source system.
Perform the following tasks:
•Ensure that you have the required permissions to extract metadata.
•Configure a connection to the Microsoft Fabric OneLake source system in Administrator.
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
You can use Microsoft Fabric OneLake Connector to connect to Microsoft Fabric OneLake using Azure Active Directory (AAD) service principal-based authentication.
Before you create a Microsoft Fabric OneLake connection, complete the following prerequisite tasks:
1Configure the following prerequisites on the Azure portal:
- Create an application in Azure Active Directory and generate a client ID, tenant ID, and client secret.
- Create a security group in Azure Active Directory and add owners or members to the security group.
2Enable the Power BI service admin settings to allow the Azure Active Directory application to use the Power BI APIs.
3Add the Azure Active Directory application to the workspace in Microsoft Fabric.
For more information about the Microsoft Fabric OneLake Connector, see the Informatica Cloud Data Integration Microsoft Fabric OneLake Connector User Guide.
Permissions to run data profiles
You can run profiles with the permissions required to perform metadata extraction.
Permissions to run data classification
You don't need any additional permissions to run data classification.
Permissions to run glossary association
You don't need any additional permissions to run glossary association.
Create a connection
Before you configure the Microsoft Fabric OneLake catalog source, create a connection object in Administrator.
Use the Microsoft Entra ID service principal, formerly known as Azure Active Directory, to create a Microsoft Fabric OneLake connection 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
Type of connection. Ensure that the type is Microsoft Fabric OneLake.
4Enter properties specific to the Microsoft Fabric OneLake connection:
Property
Description
Runtime Environment
The name of the runtime environment where you want to run tasks. Select a Secure Agent.
Workspace Name
The name of the workspace in Microsoft Fabric OneLake.
Lakehouse Path
Path or name of the lakehouse present in the workspace. You can specify the path in one of the following ways:
- root directory (/) to access the files in the workspace.
- lakehouse name/Files to access the files present in the lakehouse.
Authentication Type
Authentication type to access Microsoft Fabric OneLake. Service Principal Authentication uses the client ID, client secret, and tenant ID to connect to Microsoft Fabric OneLake.
Client ID
The application ID or client ID of your application registered in Microsoft Entra ID.
Client Secret
The client secret for your application registered in Microsoft Entra ID.
Tenant ID
The ID of the Microsoft Entra instance in which you created the application.
Microsoft Fabric OneLake Endpoint
The type of Microsoft Fabric OneLake endpoint that you want to connect to.