SQL Server

Establishing a workspace connection to a SQL Server database allows any workflow in that workspace to access tables in the database.

To establish a connection to your SQL Server database, click the Integrations tab in your workspace and select New Integration.

When establishing a connection, the following information is required:

Input

Description

Connection Name

Choose a name for your connection

Host

Database host URL

Username

User's identifier (read/write permissions will be based on user permissions)

Password

User's password

Port

Database port (uses 1433 by default)

Database

Database name

Once an integration is established, open a workflow and select Import from SQL Server to pull tables from your database into Cascade.

Last updated