sticky.io Lite
sticky.io is a payments engine and CRM solution.
Features
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | check | AFFILIATE, BILLING_MODEL, CAMPAIGN, COUPON, GATEWAY_ACCOUNT, GATEWAY_PROFILE, INVENTORY, OFFER, PRODUCT, PRODUCT_VARIANT, USERS, and WAREHOUSE tables. |
| History mode | ||
| Custom data | ||
| Data blocking | check | |
| Column hashing | check | |
| Re-sync | check | |
| API configurable | check | API configuration |
| Priority-first sync | check | CONTACT and ORDERS tables. |
| Fivetran data models | ||
| Private networking | ||
| Authorization via API | check |
Supported deployment models
We support the SaaS and Hybrid deployment models for the connector.
You must have an Enterprise or Business Critical plan to use the Hybrid Deployment model.
Setup guide
Follow our step-by-step sticky.io setup guide to connect sticky.io with your destination using Fivetran connectors.
Sync overview
To capture new records, we incrementally sync the CONTACT and ORDERS tables and their child tables.
We re-import the following tables and their child tables during every sync:
AFFILIATEBILLING_MODELCAMPAIGNCOUPONGATEWAY_ACCOUNTINVENTORYOFFERPRODUCTUSERSWAREHOUSE
We re-import the ORDERS table once a month to capture updates.
Schema information
This schema applies to all sticky.io connections.
Explore sticky.io schema ERD