Nintex
Nintex
This page outlines the steps to connect Nintex to the CData Connect Cloud Virtual SQL Server API.
Prerequisites
Before you connect, you must first do the following:
- Connect a data source to your CData Connect Cloud account. See Connections for more information.
- Generate a Personal Access Token (PAT) on the Settings page. Copy this down, as it acts as your password during authentication.
Connecting to CData Connect Cloud
To establish a connection from Nintex to the CData Connect Cloud Virtual SQL Server API, follow these steps.
-
Log into Nintex Workflow Cloud.
-
In the Connections tab, click Add New.
-
Select
Microsoft SQL Server
as the Connector type. -
Click Connect. This opens the SQL Server connection wizard.
-
In the wizard, enter a Connection Name, such as
CData Connect Cloud
. -
Enter your Connect Cloud Username.
-
Enter your Connect Cloud PAT in the Password field.
-
Enter
tds.cdata.com
in Database Host. -
Enter the name of the Database to connect to.
-
Click Connect.
-
Configure the Connect Cloud Owner and User permissions and click Save Permissions to complete the connection.