SSIS Components for DataRobot

Build 21.0.7930

Establishing a Connection

Connecting with the DataRobot Connection Manager

Adding a new DataRobot connection to the SSIS package is straightforward. Right-click within the Connection Manager window and select New Connection from the menu. Then, choose the DataRobot Connection Manager from the Add SSIS Connection Manager window.

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

Authenticating to DataRobot API

Various login credentials must be supplied to connect to the standard API and Prediction API of DataRobot.

Authenticating with a Login and API Key

Set the User and Password to your login credentials, and specify PredictionInstance. Additionally, set the APIKey connection property to your API Token, if you have obtained one already. If you are using a Cloud Prediction instance for DataRobot, you will need to supply DataRobotKey as well. To obtain the APIKey, follow the steps below:

  1. Login to the DataRobot UI, and click the person icon in the top right corner of the UI.
  2. From the drop down menu, select "Profile".
  3. Profile information will appear, including your "API Token".

To obtain the DataRobotKey, do the following:

  1. Login to the DataRobot UI, and click "Deployments" in the top-most toolbar.
  2. Open a deployment.
  3. In the deployment's menu, select the "Integrations" tab.
  4. Your DataRobotKey is the second entry in the
    headers
    JSON object.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930