Integrate Fivetran with Tiger Cloud

Fivetran is a fully managed data pipeline platform that simplifies ETL (Extract, Transform, Load) processes by automatically syncing data from multiple sources to your data warehouse.

This page shows you how to inject data from data sources managed by Fivetran into a Tiger Cloud service.

Prerequisites for this integration guide

To follow these steps, you'll need:

• A Tiger Cloud service.

  These steps use Tiger Cloud, but the same approach applies to a self-hosted TimescaleDB instance.

• Your connection details.

• A Fivetran account.

Set your service as a destination in Fivetran

To be able to inject data into your Tiger Cloud service, set it as a destination in Fivetran:

1. Add a destination

   In Fivetran Dashboard > Destinations, click Add destination.

2. Select the PostgreSQL connector

   Search for the PostgreSQL connector and click Select. Add the destination name and click Add.

3. Connect Fivetran to your service

   In the PostgreSQL setup, add your Tiger Cloud service connection details, then click Save & Test.

   Fivetran validates the connection settings and sets up any security configurations.

4. Click View Destination

   The Destination Connection Details page opens.

Set up a Fivetran connection as your data source

In a real world scenario, you can select any of the over 600 connectors available in Fivetran to sync data with your Tiger Cloud service. This section shows you how to inject the logs for your Fivetran connections into your Tiger Cloud service.

1. Add a connection

   In Fivetran Dashboard > Connections, click Add connection.

2. Select the Fivetran Platform connector

   Search for the Fivetran Platform connector, then click Set up.

3. Save and test the connection

   Leave the default schema name, then click Save & Test. You see All connection tests passed!

4. Build data models

   Click Continue, select Yes, build data models for me, and click Continue. Your Fivetran connection is connected to your Tiger Cloud service destination.

5. Start the initial sync

   Select Start syncing all my data now and click Start initial sync. Fivetran creates the log schema in your service and syncs the data to your service.

View Fivetran data in your service

To see data injected by Fivetran into your Tiger Cloud service:

1. Query the synced data

   In Tiger Console, click Data view, select your service, then run the following query:

   SELECT *
   FROM fivetran_log.account
   LIMIT 10;

   You see something like the following:

   

You have successfully integrated Fivetran with Tiger Cloud.