Metabase

​

Prerequisites

Before you connect Metabase to Connect AI, you must perform the following prerequisites.

In Connect AI:

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

To use the Open Source version of Metabase with Connect AI, you need to have a Java Runtime Environment installed on your system. Metabase recommends version 11 of JRE. See the Metabase Documentation for details.

​

Download and Install the Metabase JAR File

1. Download the Metabase OSS JAR file.

2. Create a new directory and move metabase.jar to the new directory.

3. In the new directory, run the JAR file:

   java -jar metabase.jar
   

   Metabase logs its progress in the terminal as it starts up. Wait until you see the message Metabase Initialization Complete before you start Metabase.

4. Visit http://localhost:3000/setup to start Metabase and complete your setup.

   
5. Follow the prompts to set up an admin account.

​

Connect to Connect AI

Step 4 of the Metabase setup is adding your data. To connect to Connect AI, do the following:

1. Click SQL Server.

   
2. Enter the following information:

   • Display name—the name of your data for display purposes.
   • Host—tds.cdata.com
   • Port—14333
   • Database name—接続したいConnect AI データソースのConnection Name を入力します。例：Salesforce1
   • Database Instance name—N/A
   • Username—Connect AI のユーザー名を入力します。ユーザー名は、Connect AI の画面の右上に表示されています。例：[e-mail]
   • Password—Settings ページで生成したPAT を入力します。

   

   Leave the rest of the connection settings at their default values unless you need to modify them. You can change the database details later in Metabase Admin.

3. Click Next.

4. Click Take me to Metabase.

​

Query Your Data

1. In the Home screen, click New > SQL Query.

   
2. Select the database you just added.

   
3. Create a SQL query for the data.

   
4. Click Run query to retrieve your data.

   
5. Click Save to save your query and add it to your collection.