Comment on page
Microsoft SQL Server
Apica Ascent lets you connect to the Microsoft SQL Server which is a relational database management system (RDBMS) that supports a wide variety of transaction processing, business intelligence, and analytics applications in corporate IT environments.
With Apica Ascent you can easily query, monitor, and visualize the MS SQL Server data
The first step is to create and add MS SQL Server to Apica Ascent and add fill out the below fields and save
- Name: Name the data source
- User: A user of the MS SQL Server which is in the form:
user@server-name - Password: The password for the above user
- Server: This is your server address without the
.database-windows.netsuffix - Port: The port of the MS SQL Server
- TDS Version: TDS Version of your MS SQL Server
- Character Set: Character encoding of your MS SQL Server
- Database name: The name of the database of the MS SQL Server
Also make sure to Check out Microsoft’s documentation for instructions to whitelist your Apica Ascent IP address when connecting to Synapse.
Configuring MS SQL Server
That's all, now navigate to the Query Editor to query your data
Last modified 3mo ago