Integrate Mode Analytics with Tiger Data

Mode Analytics is a collaborative analytics platform that lets you query, visualize, and share data through SQL, notebooks, and dashboards.

This page shows you how to connect Mode to Tiger Data as a data connection, so that you can explore and visualize the data in your service or database.

In this integration guide, you:

• Add your service or database to Mode as a data connection.
• Verify that Mode can query your data.

Prerequisites for this integration guide

To follow these steps, you'll need:

• A Tiger Cloud service, or a running instance of self-hosted TimescaleDB.

• Your connection details.

• A Mode workspace, with permissions to add a database connection.

Add your service or database to Mode

Mode's Direct Connect option connects to publicly accessible databases over an encrypted connection. Tiger Cloud services are publicly accessible by default. For self-hosted TimescaleDB, make sure your instance accepts connections from the public internet, or use Mode's Bridge agent instead if it's only reachable over a private network or virtual private network (VPN).

1. Open the database connection settings in Mode

   In Mode, click your name in the top-left corner, then select Connect a Database.

2. Choose Direct Connect

   Select Direct Connect, the option for databases reachable over the public internet. If your database isn't publicly reachable, for example a self-hosted instance behind a firewall or VPN, use Mode's Bridge agent instead.

3. Enter your connection details

   Select PostgreSQL as the database type, then enter your connection details:

   • Host and Port: your host and port.
   • Database name: your dbname.
   • Username and Password: your user and password.

   Turn on SSL. Tiger Cloud rejects unencrypted connections; for self-hosted TimescaleDB, turn it on if your instance is configured to require SSL.

4. Allowlist Mode's IP addresses

   Direct Connect reaches your database from a fixed set of Mode IP addresses. Add the current list from Mode's connection documentation to your database's network or firewall allow list. In Tiger Cloud, add them to your service's IP allow list under Security in the console.

5. Test and save the connection

   Click Connect. Mode tests the connection and reports whether it succeeded; if it fails, Mode shows whether the problem is SSL, network access, or credentials.

Verify the integration

To confirm Mode is working with your service or database:

1. Open a new query

   In Mode, click + New > Query, then select your connection from the data source list.

2. Run a query

   Run a simple query against one of your tables:

   SELECT * FROM <table_name> LIMIT 10;

   You see rows from your service or database in the results pane, confirming that Mode can read your data.

You have successfully integrated Mode Analytics with Tiger Data.

Troubleshooting

• Connection fails with an SSL error: confirm SSL is turned on in the connection settings. Tiger Cloud requires encrypted connections; for self-hosted TimescaleDB, confirm your instance is configured for SSL if you enabled it.
• Connection times out: confirm Mode's IP addresses are added to your database's allow list, and that the host and port are correct. If your database isn't publicly reachable, use Mode's Bridge agent instead of Direct Connect.
• Authentication failed: confirm the username and password match your connection details exactly.

For other connectivity and authentication issues, see Troubleshoot Tiger Cloud integrations.

Next steps

Find your connection details

Locate the host, port, database, user, and password for your service.

Integrate Tableau with Tiger Data

Connect Tableau to your service or database to build dashboards.