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

Prerequisites

Before you can configure and use SSIS with CData Connect, you must first connect a data source to your CData Connect account. See Data Model for more information.

Install the Provider

Follow these steps to download and install the Components:

1. Open the Clients page of CData Connect.

2. In the Dev Tools section, locate SSIS and click Download.

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

To add a new CData Connect 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 Connection Manager from the Add SSIS Connection Manager window.

3. Enter the following information:

   • AuthScheme—select Basic.

   • URL—enter [baseurl]/rest.rsc/, substituting the base URL of your CData Connect server for [baseurl]. For example, localhost:8080 or myConnectInstance.cdata.com.

   • User—enter your CData Connect username as defined on the Users page.

   • Password—enter the Authtoken for the user.

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

Learn More

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