SSIS (Files / Integration Services / Integration Services Catalog / Azure)

Learn how to configure SSIS (Files, Integration Services, Integration Services Catalog, Azure) as metadata sources for Cloudera Data Lineage (formerly Octopai).

SSIS method

In the Octopai Client, select the SSIS method implemented in your organization.

Figure 1. Select the SSIS method in the Octopai Client

SSIS Files

Figure 2. Setting up SSIS Files Metadata Source

SSIS Integration Services

Figure 3. Setting up SSIS Integration Services Metadata Source

SSIS Integration Services Catalog

Figure 4. Setting up SSIS Integration Services Catalog Metadata Source

SSIS Azure

Permissions prerequisites

  • Define a user with the db_owner role on the SSISDB instance for the Integration Services Catalog.

Set up the metadata source

Figure 5. Configure the SSIS Azure metadata source

Verify extraction results

After a successful run, confirm the metadata archive in the target folder. See Verify extracted metadata files.

Troubleshoot

If an error occurs during the extraction, see Troubleshoot connector extraction failures.