Setting up Kraken to connect 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.
Required connection information for SQL Server
- 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 for predictive analysis
In order for Kraken to access the data stored in your data warehouse, you may have to whitelist the Big Squid IP Address. Please contact your Customer Success Manager for more information
More Information on Connecting to MS SQL Server