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—enter the Connection Name of the CData Connect Cloud data source you want to connect to (for example, Salesforce1).

    • Database Instance name—N/A

    • Username—enter your CData Connect Cloud username. This is displayed in the top-right corner of the CData Connect Cloud 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. 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.