SnapLogic Fast Data Loader

Overview

SnapLogic Fast Data Loader (FDL) is a data ingestion tool that simplifies the tasks of replicating data and synchronizing data for data analysts and business analysts. Using FDL, you can quickly load data from your cloud apps into a cloud data warehouse using a simple, no-code, point-and-click user interface. For example, you can source your customer data from Salesforce, service data from ServiceNow, business spend data from Coupa, and transactional and product usage data from cloud-based Oracle and Microsoft SQL Server databases and load all this data to your Snowflake, Amazon Redshift, or SAP cloud data warehouse so that the data is available for transformations within the cloud data warehouse and downstream analytics for further use.

You can find out about the FDL pricing on SnapLogic Community.

You can configure pre-built data integrations with the following endpoints.

Source data endpoints:

Destination data warehouses:

Key Features

  • Simple three-step process: select, load, and integrate without any coding. You simply configure your source and destination endpoints and then load your data.

  • Syncs large amounts of data from various sources, faster and at regular intervals.

  • Loads data to several popular cloud data warehouses.

  • Tracks data changes and schema changes, and performs incremental data loads.

  • Stores historical data using Slowly Changing Dimension Type 2 (SCD2) so that data changes are not lost.

  • Supports multiple data types.

Workflow

The integration workflow includes the following key steps:

  1. Choose and connect your source.

  2. Choose and connect your destination.

  3. Set up and verify.

  4. Set up an integration schedule to replicate the data loading.

Creating Data Integration

  1. Log in to the Intelligent Integration Platform with your SnapLogic credentials.

  2. Click the tic-tac-toe icon at the top left of the page.
    If you have access to FDL, the Fast Data Loader integration workflow page is displayed. Else, you can get access by using the FDL registration page.
    Note: If you have existing integrations you will be directed to the FDL Dashboard. You can click New Integration to configure a new integration.

  3. In the Choose and connect your source section, select the source from which you want to load your data.
    Learn more about configuring a source endpoint, Create your data integration in FDL

  4. In Choose and connect your destination section, select the destination cloud data warehouse into which you want to load your data.
    Learn more about configuring a destination endpoint, Create your data integration in FDL.

  5. In the Set up and Verify section, do the following tasks:

    1. Choose one of the following integration methods:

      • Reload: To reload the data.

      • Upsert: To upsert the data, which inserts new records and updates existing records. FDL creates a table if a table does not exist, and then loads the data.

      • SCD2: To load historical data using the Slowly Changing Dimension Type 2 (SCD2) table.

    2. In Concurrency, select a value to indicate the number of users who can access data at the same time.

    3. From the Table to integrate drop-down list, select the table into which you want to integrate the data.

  6. In the Name your integration field, specify a unique name for your integration.

  7. Click one of the following options to save your integration:
    Save: To save your integration.
    Save and Load: To save your integration and load the data. The default frequency is set to 6 hours.

    Your new integration is displayed in the dashboard.

    Integration Workflow

     

  8. On the dashboard, click the Scheduler icon on your integration to set a schedule for your integration.

Contact FDL customer support at fdl-support@snaplogic.com for assistance.


See Also