Zip Lite
Zip is an intake and procurement orchestration platform.
Features
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | check | AGREEMENT, CURRENCY, DEPARTMENT, GL_ACCOUNT, LOCATION, LOOKUP, LOOKUP_OPTION, ROLE, SUBSIDIARY, USER_GROUP, USERS, VENDOR, VENDOR_CREDIT, and WORKFLOW tables. |
| History mode | ||
| Custom data | check | PAYMENT_METHOD table |
| Data blocking | check | |
| Column hashing | check | |
| Re-sync | check | |
| API configurable | check | API configuration |
| Priority-first sync | check | AUDIT_LOG, INVOICE, PURCHASE_ORDER, and REQUEST tables and their child 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 Zip setup guide to connect Zip with your destination using Fivetran connectors.
Sync overview
To capture new records, we incrementally sync the following tables and their child tables:
APPROVALAUDIT_LOGINVOICEPURCHASE_ORDERREQUESTVENDOR
To capture updates and deletes, we re-import the following tables and their child tables:
AGREEMENTCURRENCYDEPARTMENTGL_ACCOUNTLOCATIONLOOKUPLOOKUP_OPTIONROLESUBSIDIARYUSER_GROUPUSERSVENDOR_CREDITWORKFLOW
We also re-import the VENDOR table once a week to capture deletes.
Schema information
This schema applies to all Zip connections.
Explore Zip schema ERD