Microsoft SQL Server is a relational database management system with the primary function of storing and retrieving data as requested by other software applications.
You'll need to provide certain details and credentials, so Pecan can access the relevant data in Microsoft SQL. If you need help with the below steps, be sure to consult with your internal IT or DevOps team.
Prerequisite steps
First, make sure you whitelist these Pecan IP addresses:
54.246.108.184 34.254.11.37 54.216.8.168 54.217.189.54 54.73.234.235 54.170.135.39 79.125.57.39
Before you add an MSSQL connection, if you haven’t already, you’ll need to create a role with Read and Write permissions, so Pecan can access your server.
How to configure a Microsoft SQL Server connection
Log in to Pecan, select the “Connections” tab, and click Add connection.
Select “Microsoft SQL Server” and complete the following fields:
Connection name – This is how you’ll identify the connection when creating and working with models on the platform. Names should be unique and reflect the data source and what’s stored in it. Valid characters include letters, numbers, and underscores. Connection names can’t be changed once created. Example: “mssql_paid_downloads_fall_2021”
Connection type – Select "Read" if the connection will be used to import data into Pecan. Select "Write" if it will be used to export predictions from Pecan to your Microsoft SQL Server.
Server – this is the address that provides remote access to your server.
Username and Password - these credentials are for the Read-only account that will enable Pecan to access your server.
Database – this is the name of the database Pecan should use. Servers can hold many different databases; if you want to use multiple databases to create models in Pecan, but they sit on the same server, you’ll need to create a new connection for each database.
Port – Provide the connection port for your server. If you leave this blank, Pecan will automatically use the default port 1433.
Now, click Test connection to make sure everything is working correctly. Then click Create connection to complete the setup. (For more information, see Testing and creating a data connection.)