SSIS

This page outlines the steps to use the SSIS Components for Connect AI.

​

Prerequisites

Before you can configure and use SSIS with Embedded Cloud, you must first connect a data source to your account. See Sources for more information.

​

Install the Provider

Follow these steps to download and install the Components:

1. Open the Integrations page of Connect AI.

2. In the Dev Tools section, click SSIS.

3. Download and run the setup file.

4. The installer can automatically detect software that supports SSIS. Select the options that you want the installer to configure.

​

Connect to Embedded Cloud

To add a new connection to the SSIS package, follow these steps:

1. Right-click within the Connection Manager window and select New Connection from the menu.

2. Choose the Connect AI Connection Manager from the Add SSIS Connection Manager window.

3. The OAuth endpoint opens in your default web browser. Log in to complete the OAuth process.

Alternatively, you can create a new connection directly using the Connect AI Source or the Connect AI Destination. You can set the connection properties in the Connect AI Connection Manager window.

​

Learn More

To learn more information about using the SSIS Components for Connect AI, click here.