Stitch Integration Guide

Ascend > Stitch User Guide 

Overview

Ascend, in collaboration with Stitch (a Talend company), offers a new integration for extracting data from the Ascend Advertiser API and loading the data into a cloud data warehouse or data lake(Snowflake, BigQuery, Redshift, AWS S3, etc.). Stitch supports over 100 data sources and is built on the Singer.io project, the open-source standard for moving data.

The Pepperjam integration creates database tables by extracting data from the following Pepperjam objects (API endpoints):

• • Report/Performance Objects
    • creative_performance
    • creative_performance_by_publisher
    • publisher_performance
    • transaction_details
    • transaction_history
  • Creative Objects:
    • creative_advanced
    • creative_banner
    • creative_coupon
    • creative_generic
    • creative_product
    • crative_promotion
    • creative_text
  • Other Objects:
    • group
    • group_member
    • itemized_list
    • itemized_list_product
    • publisher
    • term

Initial Load: For the first integration load, the integration performs an initial load of ALL data for each of the objects.

Ongoing Sync: For the Report/Performance and Creative objects, the integration incrementally loads the data based on the modified datetime; meaning only new/updated data is loaded for each integration load. For the Other objects, the integration re-loads ALL data in the table for each integration load.

Setup

StitchData.com Account

In your web browser, go to Stitch (https://stitchdata.com) and Sign In (if you have an existing Stitch account) or Enter your email and click Sign up for free (if you do not have a Stitch account).

Stitch offers a few different pricing tiers based on the types of integrations you need and the data volumes. While in 14-day trial, you can access the Pepperjam integration to extract and load data for free, without row limits.

If you are creating a new Stitch account, you will need to Set Up a Destination to your data warehouse. Each Stitch account has a single Destination (data warehouse/data lake) and one or more Integrations (e.g. Pepperjam). Stitch provides a general setup guide as well as a guide specific for each Destination.

Pepperjam Integration

From the Stitch homepage, select the Integrations page (tab at the top). Then click the “Add Integration” button (upper left corner).

In the search dialogue, search for Pepperjam and click on the Pepperjam integration.

Next, you will Configure your Pepperjam Integration with the following parameters:

• Integration Name: Enter a lower_case_name, without spaces. This name will become the schema (or dataset) name in your Destination data warehouse.
• API Key: The API requires an API Key for Pepperjam to authenticate you as a user. This key is required as a query parameter for all API requests. Login to Pepperjam’s Ascend Console UI. Navigate to https://ascend.pepperjam.com/merchant/api/. Select Generate New Key. Save this API Key in your password manager and enter the API Key into the Stitch parameter.
• Sync Historical Data: Uncheck the box and select the absolute start date, a date on or before your company started using Pepperjam. Stitch will load ALL data from this date forward for the initial load sync.
• Replication Frequency: Select an integration frequency. Due to Pepperjam daily API constraints, loading this data every 24 hours is recommended.
• Check and Save: Click Check and Save to test your connection and save the integration. If your API Key is valid, then you will be directed to the Choose Your Data screen.

Discovery Mode (Choose Your Data)

This screen displays all of the Pepperjam Tables (aka Objects or Endpoints) for selection using checkboxes. Stitch allows you to select ALL or a subset of tables. Then, for each table, you may select ALL or a subset of fields to load to your database.

Select each Table (e.g. publisher_perfomance) by selecting the checkbox. This will take you to the field selection screen.

Select Track All Fields: On the field selection screen for each table, click on the checkbox left of Field Names and select Track All Field to select ALL of the fields from the table.

Return to Table Selection: Click on your Integration Name (e.g. pepperjam) in the “Breadcrumb” at the top left of the Field selection screen to return to the Table Selection screen.

Repeat for Each Table and All Fields: Repeat the steps above for Table Selection and Field Selection to select the desired tables and fields to load into your Destination data warehouse.

Finalize Your Selections: Once you have selected all of the desired Tables and Fields, click the Finalize Your Selections button in the lower right corner. Then click Yes, Continue to finish and run your initial load sync.

Monitoring and Maintaining

For each Integration (e.g. Pepperjam), Stitch provides an Integration monitoring and configuration dashboard with the following tabs:

• Summary: High level overview of integration loads and the number of rows loaded.
• Tables to Replicate: Discovery Mode for table and field selection.
• Extractions: Timeline and logs for recent job loads.
• Loads: Summary of records loaded per table.
• Settings: Reset API Key, Start Date (to completely reload), and frequency.

Summary

Tables to Replicate

Extractions

Loads

Settings