OrdwayLite
Ordway is a cloud-based billing and revenue automation platform.
Features
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | check | BILLING_RUN, COUPON, CUSTOMER, CUSTOMER_NOTE, ORDERS, CHART_OF_ACCOUNT, PAYMENTS_METHOD, PAYMENTS_RUN, PLAN, PRODUCT, STATEMENT, SUBSCRIPTION and REVENUE_RULE tables and their child tables. |
| History mode | ||
| Custom data | check | PLAN, BILLING_SCHEDULE, CUSTOMER, CREDIT, JOURNAL, INVOICE, ORDERS, CHART_OF_ACCOUNT, PAYMENTS, PRODUCT, SUBSCRIPTION, USAGE, and REVENUE_RULE tables. |
| Data blocking | check | |
| Column hashing | check | |
| Re-sync | check | |
| API configurable | check | API configuration |
| Priority-first sync | check | INVOICE, JOURNAL, PAYMENTS, REVENUE_SCHEDULE, and USAGE tables and their child tables. |
| Fivetran data models | ||
| Private networking | ||
| Authorization via API | check |
Supported deployment models
We support the SaaS Deployment model for the connector.
Setup guide
Follow our step-by-step Ordway setup guide to connect Ordway with your destination using Fivetran connectors.
Sync overview
To capture new records, we incrementally sync the following tables and their child tables:
BILLING_SCHEDULEBILLING_RUNCHART_OF_ACCOUNTCOUPONCREDITCUSTOMERINVOICEJOURNALORDERSPAYMENTSPLANREFUNDREVENUE_SCHEDULESUBSCRIPTIONUSAGE
To capture updates and deletes, we re-import the following tables once a week:
BILLING_RUNCHART_OF_ACCOUNT
To capture updates and deletes, we also re-import the remaining tables and their child tables during every sync.
Schema information
This schema applies to all Ordway connections.
Explore Ordway schema ERD