Grafana

This page outlines the steps to connect Grafana to the Connect AI Virtual SQL Server API.

Prerequisites

Before you connect, you must first do the following:

• Connect a data source to your Connect AI account. See Sources for more information.
• Generate a Personal Access Token (PAT) on the Settings page. Copy this down, as it acts as your password during authentication.

Connect to Connect AI

To establish a connection from Grafana to the Connect AI Virtual SQL Server API, follow these steps.

1. Download and install Grafana for your operating system from the Grafana website.

2. Once installed, access Grafana at http://localhost:3000/.

3. Log in to Grafana with your username and password for Grafana. If this is your first time logging in, the username is admin and the password is admin.

4. On the navigation menu, click Connections > Add new connection.

   
5. Search for Microsoft SQL Server as your data source.

6. Click Add new data source.

   
7. (Optional) Enter a new name for the data source.

8. Enter the following connection settings.

   • Host—tds.cdata.com:14333
   • Database—enter the Connection Name of the Connect AI data source you want to connect to (for example, Salesforce1).
   • Username—enter your Connect AI username. This is displayed in the top-right corner of the Connect AI interface. For example, [e-mail].
   • Password—enter the PAT you generated on the Settings page.

   
9. Click Save & test. A Database Connect OK message appears.

10. On the navigation menu, click Explore.

11. Select the connection you created. Choose the tables and columns you want to query.

    
12. Run the query and visualize your data as you want.