- Before connecting SQL Server to Chartio, log in to your Microsoft Azure account.
Select SQL Databases from the navigation, then select the name of the database you’d like to connect to.
Make note of the server name and port number at the bottom of the page; you’ll need those for the Server Name and Database Port fields in Chartio’s data source connection form.
Click Dashboard at the top of the page.
Scroll down and click the link to Manage allowed IP addresses in the bottom right-hand corner of the screen.
Add a new rule using the following IP address:
Start IP Address:
End IP Address:
Click Save at the bottom of the page.
- Once you’ve collected the necessary information from your Microsoft Azure Portal and added access to Chartio’s external IPs, you can follow the instructions to connect SQL Server to Chartio.
MySQL Azure connection
We currently do not have have listed support for MySQL Azure, only Microsoft Azure.
We can only have a connection that doesn’t require an SSL CA file. You’ll need to find a way to ‘Allow Unsecured Connections’. We’ll still connect with an SSL connection from our end but can’t use their certificates.