Microsoft SQL Server
Last updated
Last updated
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.net suffix
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.
That's all, now navigate to the Query Editor to query your data
