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 Looker to the Connect AI Virtual SQL Server API, follow these steps.1
Log in to Looker.
2
In the navigation pane, select Admin. Under the Database category, select Connections.
3
On the Connections page, click Add Connection.
4
Enter the connection settings:
- Name—the name for the connection in models.
- Dialect—select Microsoft SQL Server 2017+.
- SSH Server—leave this disabled.
- Remote Host:Port—enter tds.cdata.com in the first field and 14333 in the second field.
- 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, test@cdata.com.
- Password—enter the PAT you generated on the Settings page. Leave the rest of the connection settings at their default values unless you need to modify them.
5
At the bottom of the page, click Test These Settings to ensure that you can connect to Connect AI.
6
Click Add Connection to create the connection and return to the Connections page.