Connect to Microsoft Azure

  1. Before connecting SQL Server to Chartio, log in to your Microsoft Azure account.
  2. 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.

  3. Click Dashboard at the top of the page.

    Click the Dashboard link on chinook

  4. Scroll down and click the link to Manage allowed IP addresses in the bottom right-hand corner of the screen.

    Click Manage allowed IP addresses

  5. Add a new rule using the following IP address:

    Rule Name: Chartio
    Start IP Address: 52.6.1.1
    End IP Address: 52.6.1.1

  6. Click Save at the bottom of the page.

  7. 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.