Search

SSIS

SSIS

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

Note：CData Connect Cloud でSSIS を設定して使用する前に、データソースをCData Connect Cloud アカウントに接続する必要があります。詳細は、Connections を参照してください。

Install the Provider

Follow these steps to download and install the Components:

  1. Open the Client Tools page of CData Connect Cloud.

  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 CData Connect Cloud

To add a new CData Connect Cloud 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 CData Connect Cloud 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 CData Connect Cloud Source or the CData Connect Cloud Destination. You can set the connection properties in the CData Connect Cloud Connection Manager window.

Connect to a Workspace

To connect the SSIS client to a specific workspace, you specify the workspace name in the Workspace field of the CData Connect Cloud Connection Manager.

Learn More

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