Steps overview: Integrate SQL Server Integration Services via Edge

The integration steps vary slightly depending on how you choose to connect to your data source.

Integrate via Shared Storage connection

# Step Description
1 Review the preflight checks. Key considerations to help ensure successful integration, including required Edge, technical lineage, and data source-specific permissions, network requirements and more.
2

Create a Shared Storage connection.

A Shared Storage connection allows you to grant your capabilities access to files from a shared folder.

Important Shared Storage connection is not supported for Collibra Cloud sites.
3 Prepare the data source files Prepare the data source files and store them in the folder that you created when you created the Shared Storage connection.
4

Add the Technical Lineage for SQL Server Integration Services (SSIS) capability for Shared Storage connections.

 Add the technical lineage capability to your Edge or Collibra Cloud site. The capability allows the lineage harvester to retrieve data from your data source.
5 Synchronize the technical lineage.

You can synchronize your technical lineage manually or automatically by adding a synchronization schedule.

Integrate via Cloud Storage connection

# Step Description
1 Review the preflight checks. Key considerations to help ensure successful integration, including required Edge, technical lineage, and data source-specific permissions, network requirements and more.
2

Create a Cloud Storage connection.

For guidance on how to create a connection between your cloud-based storage system and Edge or Collibra Cloud site, go to the appropriate topic:

  • Create an AWS connection to an Edge or Collibra Cloud site.
  • Create an Azure Data Lake Storage connection to an Edge or Collibra Cloud site.
  • Create a Google Cloud Platform connection to an Edge or Collibra Cloud site.

3 Prepare the data source files

Prepare the data source files and store them in your cloud-based storage system. The files must be in one of the following:

  • An AWS S3 bucket.
  • An Azure Data Lake Storage container.
  • A Google Cloud Storage bucket.
4

Add the Technical Lineage for SQL Server Integration Services (SSIS) (Cloud) capability for Cloud Storage connections.

 Add the technical lineage capability to your Edge or Collibra Cloud site. The capability allows the lineage harvester to retrieve data from your data source.
5 Synchronize your technical lineage.

You can synchronize your technical lineage manually or automatically by adding a synchronization schedule.

What's next

After you synchronize the technical lineage, you can view the ingestion report. This shows the impact of technical lineage synchronization on the assets in Collibra.

Helpful resources