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 Octopai.

SSIS method

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

Figure 1. Select the SSIS method in the Cloudera 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 the extracted metadata file

Access the Cloudera Octopai Target Folder (TGT)

Go to the TGT folder located on the server where the Cloudera Octopai Client is installed.

The default path is C:\Program Files (x86)\Octopai\Service\TGT.
Open the ZIP file with the connector name.

Example:

Figure 6. Example connector archive
Verify the quantity and quality of the inner files.

Troubleshoot

If an error occurs during the extraction, check the following:

Confirm that the required permissions are in place.
Send the log with the connector number and name to Cloudera Support. The default log path is C:\Program Files (x86)\Octopai\Service\log.

Figure 7. Example log file location