Microsoft SQL Server

Squid can connect to a Microsoft SQL Server database to serve as a data source for your Squid application.

Microsoft SQL Server is a relational database management system. With Squid, you can integrate with your Microsoft SQL Server database and even join data with other database integrations.

To integrate your Microsoft SQL Server database with Squid, complete the following steps:

1. Open the Squid Console and select your application to use with Snowflake.
2. Click the Integrations tab, and then click Available integrations to view all integrations.
3. Select the Microsoft SQL Server integration.
4. Provide the following configuration information:

• Integration ID - Choose an ID that is brief and helps identify the integration.
• Database endpoint - The database host including the port number.
• Microsoft SQL Server username
• Microsoft SQL Server password - To keep it private, store your password in Squid Secrets.
• Schema - The name of the schema to connect to - If none is provided, the default dbo schema is used.
• Database name - The name of the database to connect to.
• SSL configuration (if needed)

Once you've entered the connection information, click Test connection to confirm that the connection is configured properly.

Securing your database

By default, security rules are required, and in a production environment, it's essential to never allow access to the integration without them. Learn more about securing your database data in the security rules documentation.

Datatype Mapping

The following table outlines the datatype mapping between Microsoft SQL Server and Squid:

Microsoft SQL Server Type	Squid Type
bigint	number
binary	string
boolean	boolean
char	string
date	date
datetime	date
datetime2	date
datetimeoffset	date
decimal	number
float	number
image	string
int	integer
json	map or array
money	number
nchar	string
ntext	string
numeric	number
nvarchar	string
real	number
smalldatetime	date
smallint	integer
smallmoney	number
text	string
time	string
tinyint	integer
uniqueidentifier	string
varbinary	string
varchar	string
year	number

To learn how to work with Microsoft SQL Server data in Squid, view the Client SDK documentation.