Integrate Fivetran with Tiger Cloud

Automatically sync data from multiple sources to simplify ETL processes

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 .

Prerequisites

To follow the steps on this page:

• Create a target with Real-time analytics enabled.

  You need your connection details. This procedure also works for .

• Sign up for Fivetran

Set your service as a destination in Fivetran

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

1. In Fivetran Dashboard > Destinations, click Add destination.

2. Search for the {PG} connector and click Select. Add the destination name and click Add.

3. In the {PG} setup, add your 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 . This section shows you how to inject the logs for your Fivetran connections into your .

1. In Fivetran Dashboard > Connections, click Add connection.

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

3. Leave the default schema name, then click Save & Test.

   You see All connection tests passed!

4. Click Continue, select Yes, build data models for me, and click Continue.

   Your Fivetran connection is connected to your destination.

5. Select Start syncing all my data now and click Start initial sync.

   Fivetran creates the log schema in your and syncs the data to your .

View Fivetran data in your service

To see data injected by Fivetran into your :

1. In , click Data view, select your , then run the following query:

   SELECT *
   FROM fivetran_log.account
   LIMIT 10;
   

   You see something like the following:

   

You have successfully integrated Fivetran with .