Workato

This page outlines the steps to connect Workato to the Connect AI Virtual SQL Server API.

Prerequisites

Before you connect, you must first do the following:

Connect a data source to your Connect AI account. See Sources for more information.
Generate a Personal Access Token (PAT) on the Settings page. Copy this down, as it acts as your password during authentication.

To establish a connection from Workato to the Connect AI Virtual SQL Server API, follow these steps.

Log in to Workato.
On the navigation bar, click Projects.
Enter a name for the new project and click Create project.
In your new project, click Create > Connection.
In the search bar, enter “SQL Server”. The Connect to SQL Server screen appears.
In Connect to SQL Server, enter the connection name and the following connection settings.
- Location—The name of the project in which to create the connection.
- Connection type—select Cloud.
- Host—tds.cdata.com
- Port—14333
- Username—enter your Connect AI username. This is displayed in the top-right corner of the Connect AI interface. For example, test@cdata.com.
- Password—enter the PAT you generated on the Settings page.
- Database—enter the Connection Name of the Connect AI data source you want to connect to (for example, Salesforce1).
Click Connect. A Connection established message appears.
The next step is to set up your recipe. In your project, click Create > Recipe.
In Set up your recipe, enter the name and location of your recipe.
Select Run on a schedule.
Select the actions that occur on the schedule.
Select a table from your SQL Server connection, and any filters, if applicable.
Click Save to save the recipe.
Click Test Jobs to test your recipe.