Use TimescaleIntegrations

Integrate Fivetran with Timescale 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.

Fivetran data in a service

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

Prerequisites

To follow the procedure on this page, you need to:

Set your Timescale Cloud service as a destination in Fivetran

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

Fivetran data destination

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

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

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

Fivetran data source

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

  2. Search for the Fivetran Platform connector, then click Setup.

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

    You see All connection tests passed!

  4. Click Continue, enable Add Quickstart Data Model and click Continue.

    Your Fivetran connection is connected to your Timescale Cloud service destination.

  5. Click Start Initial Sync.

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

View Fivetran data in your Timescale Cloud service

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

  1. In data mode in Timescale Console, select your service, then run the following query:

    SELECT *
    FROM fivetran_log.account
    LIMIT 10;

    You see something like the following:

    Fivetran data in a service

You have successfully integrated Fivetran with Timescale Cloud.

Keywords

FivetranPostgreSQLconnectionintegrate

Found an issue on this page?Report an issue or Edit this page in GitHub.

PreviousDBeaverNextGrafana

Related Content

Integrate with PostgreSQL
Query any other PostgreSQL database or another Timescale Cloud service from your service by using PostgreSQL foreign data wrappers
Integrate Datadog with Timescale Cloud
Datadog is a cloud-based monitoring and analytics platform. Export telemetry data from your Timescale Cloud service with time-series and analytics capability to Datadog
Integrate DBeaver with Timescale Cloud
DBeaver is a free cross-platform database tool for developers, database administrators, analysts, and everyone working with data. Integrate DBeaver with Timescale Cloud
Integrate pgAdmin with Timescale Cloud
pgAdmin is a feature-rich open-source administration and development platform for PostgreSQL. Integrate pgadmin with Timescale Cloud
Integrate qStudio with Timescale Cloud
qStudio is a modern free SQL editor that provides syntax highlighting, code-completion, excel export, charting, and much more. Integrate qStudio with Timescale Cloud
Integrate Terraform with Timescale Cloud
Manage your Timescale Cloud services with a Terraform provider