> ## Documentation Index
> Fetch the complete documentation index at: https://mintlify-poc.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Integrate Fivetran with Tiger Cloud

> Automatically sync data from multiple sources to simplify ETL processes

export const SERVICE_SHORT = 'service';

export const PG = 'Postgres';

export const CONSOLE = 'Tiger Console';

export const CLOUD_LONG = 'Tiger Cloud';

export const SERVICE_LONG = 'Tiger Cloud service';

export const SELF_LONG = 'self-hosted TimescaleDB';

[Fivetran][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.

![Fivetran data in a service][fivetran-data-in-a-service]

This page shows you how to inject data from data sources managed by Fivetran into a {SERVICE_LONG}.

## Prerequisites

To follow the steps on this page:

* Create a target [{SERVICE_LONG}][create-service] with Real-time analytics enabled.<p />

  You need [your connection details][connection-info]. This procedure also
  works for [{SELF_LONG}][enable-timescaledb].

[create-service]: /deploy-and-operate/tiger-cloud/get-started/create-services

[enable-timescaledb]: /deploy-and-operate/self-hosted/install-and-update/install-self-hosted

[connection-info]: /integrations/find-connection-details

* Sign up for [Fivetran][sign-up-fivetran]

## Set your service as a destination in Fivetran

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

![Fivetran data destination][fivetran-data-destination]

1. In [Fivetran Dashboard > Destinations][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 [{SERVICE_LONG} connection details][connection-info], 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
{SERVICE_LONG}. This section shows you how to inject the logs for your Fivetran connections into your {SERVICE_LONG}.

![Fivetran data source][fivetran-data-source]

1. In [Fivetran Dashboard > Connections][fivetran-dashboard-connectors], 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 {SERVICE_LONG} destination.
5. Select `Start syncing all my data now` and click `Start initial sync`.

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

## View Fivetran data in your service

To see data injected by Fivetran into your {SERVICE_LONG}:

1. In {CONSOLE}, click `Data view`, select your {SERVICE_SHORT}, then run the following query:

   ```sql theme={"dark"}
   SELECT *
   FROM fivetran_log.account
   LIMIT 10;
   ```

   You see something like the following:

   ![Fivetran data in a service][fivetran-data-in-a-service-1]

You have successfully integrated Fivetran with {CLOUD_LONG}.

[connection-info]: /integrations/find-connection-details

[fivetran]: https://fivetran.com/docs/getting-started

[fivetran-dashboard-connectors]: https://fivetran.com/dashboard/connections

[fivetran-dashboard-destinations]: https://fivetran.com/dashboard/destinations

[fivetran-data-destination]: https://assets.timescale.com/docs/images/integrations-fivetran-destination-timescal-cloud.png

[fivetran-data-in-a-service]: https://assets.timescale.com/docs/images/integrations-fivetran-sync-data.png

[fivetran-data-in-a-service-1]: https://assets.timescale.com/docs/images/integrations-fivetran-view-data-in-service.png

[fivetran-data-source]: https://assets.timescale.com/docs/images/integrations-fivetran-data-source.png

[sign-up-fivetran]: https://www.fivetran.com/