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 would like to connect to.

    Make note of the server name and port number at the bottom of the page; this is the information you’ll use in the Server Name and Database Port fields when creating a connection to Chartio.

  3. Click Dashboard at the top of the page. Click the Dashboard link on chinook

  4. Scroll down and select 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 the Save button at the bottom of the page.

  7. Once you have collected your information from your Windows Azure management console 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 does not require an SSL CA file. You will 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.