Creating a SaaS Pipeline

On This Page

A SaaS Pipeline is a Pipeline that you create with any SaaS-based application as your Source, for example, Shopify or Facebook Ads. For the Destination, you can choose any database or data warehouse based on your business requirement.

For some Sources, Hevo also provides you a fully-managed Google BigQuery data warehouse as a Destination. To use it as a Destination in your Pipeline, your email ID and domain must be associated with an active Google, G Suite, or Google Cloud Identity account.

Note: Refer to the list of Sources with which you can use the Hevo-managed Google BigQuery Destination.

Let us see an example of creating a Pipeline and moving the data from the Shopify Source to a Hevo-managed Google BigQuery database. You can select any Destination of your choice.

Prerequisite

  • Access to the Shopify data.

Configure the Source

  1. Log in to your Hevo account. By default, PIPELINES is selected in the Asset Palette.

  2. Select Shopify from the list of displayed Sources (the list of Sources you select at the time of setting up your account with Hevo).

    Create Pipeline

    If Shopify is not available in the displayed list, click View All, search for Shopify, and then select it from the Select Source Type page.

    Select Shopify

  3. In the Configure your Shopify Source page, specify the Shopify connection settings.

    Note: The fields may vary depending on the Source type. Read Sources.

    Configure Shopify

  4. Click TEST & CONTINUE.

Select and Configure the Destination

  1. In the Select Destination Type page, click SET UP DESTINATION to configure Hevo-managed Google BigQuery as the Destination. Alternatively, you can select any other Destination of your choice. Read Destinations.

    Create Pipeline

  2. In the Set up a Destination page, enter a name for the managed BigQuery Destination.

    Create Pipeline

  3. Click CONTINUE.

Final Settings

  • Optionally, as part of the final settings, you can set up Transformations to cleanse the Source data or enrich it in any other way. You can also view the Source to Destination field mapping via the Schema Mapper and edit these, if needed.

    Your first Pipeline with the SaaS Source is created and the data ingestion starts.

See Also

Revision History

Refer to the following table for the list of key updates made to this page:

Date Release Description of Change
Mar-21-2022 NA New document.
Last updated on 11 Mar 2022
Was this page helpful?