Metabase


Metabase


Prerequisites

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

In CData Connect Cloud:

  • Connect a data source to your CData Connect Cloud account. See Connections 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 CData Connect Cloud, you need to have a Java Runtime Environment installed on your system. Metabase recommends version 11 of JRE. See the Metabase Documentation for details.

Downloading and Installing 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.

Connecting to CData Connect Cloud

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

  1. Click SQL Server.

  2. Enter the following information:

    • Display name—the name of your data for display purposes.

    • Hosttds.cdata.com

    • Port14333

    • Database name—接続したいCData Connect Cloud データソースのConnection Name を入力します。例:Salesforce1

    • Database Instance name—N/A

    • Username—CData Connect Cloud のユーザー名を入力します。ユーザー名は、CData Connect Cloud の画面の右上に表示されています。例:test@cdata.co.jp

    • PasswordSettings ページで生成した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.

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