Microsoft SQL Server Requirements
Connecting to your Microsoft SQL Server environment requires a user that has read and write access to the database you would like to use for predictive analysis. If your database is not accessible outside of your network, you may need to contact your IT department to whitelist the necessary IP address. Please contact your Customer Success Manager for more information.
Adding a New SQL Server Connection
 |
Click on the "hamburger menu" icon in the top left corner |
|
Click on "Manage Data" |
|
|
Click on the SQL Server data provider card and fill in the details: |
|
|
Data Source: The name or network address of the instance of MS SQL Server |
|
|
User ID: The MS SQL Server login account being used that has read/write access to the database entered in the previous field |
|
|
Password: The password for the MS SQL Server account being used |
|
|
Catalog: The case-sensitive name of the database that contains the data you would like to use |
|
|
Schema: (OPTIONAL) The name of the schema that you would like to use |
|
|
Click the "Connect" button to create the connection. |