What does this article cover?
- What is Dataflow Automation?
- What is a Dataflow Automation connection?
- How do I create a SQL Server connection?
Also, check out the walkthrough video:
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.
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.
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 in 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.