Dataflow Automation Connections

Table of Contents

• What is Dataflow Automation?
• What is a Dataflow Automation connection?
• How do I create a SQL Server connection?

Also, check out the walkthrough video:

• VIDEO: Setting up a SQL Server Connection

What is Dataflow Automation?

Dataflow Automation provides organizations Big Data capabilities including long term storage, data management, processing and integration without having to invest millions of dollars and a dedicated team.  

Click here for more information on Dataflow Automation.

What is a Dataflow Automation connection?

Connections store information that is used to communicate with the actions that exist in your Dataflows.

PLEASE NOTE: Connections may be used by more than one Dataflow within your account.

Click here for more information on Connections.

How do I create a SQL Server connection?

To create a SQL Server connection, please follow the instructions below.

STEP 1. From the Dataflow Automation interface, click Connections from the left-hand menu.

STEP 2. Click +.

STEP 3. Name your connection and select SQL Server from the Type drop-down menu.

STEP 4. Enter your SQL Server information and credentials.

STEP 5. With your SQL Server info entered, click Test Connection.

STEP 6. Once setup properly, you'll receive a checkmark next to Test Connection and can now click Save.

Your SQL Server connection is now created.

PLEASE NOTE: If your connection test fails, you'll receive a message similar to the one below.

Be sure to check the credentials you've entered.