Edit on GitHub
Katana Lite link
Updated October 17, 2023
Katana is a cloud-based Manufacturing ERP (MRP) platform.
Featureslink
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | check | All tables |
| Custom data | ||
| Data blocking | check | Column level |
| Column hashing | check | |
| Re-sync | check | Connector level |
| History | ||
| API configurable | check | API configuration |
| Priority-first sync | ||
| Fivetran data models | ||
| Private networking |
Setup guidelink
Follow our step-by-step Katana setup guide to connect Katana with your destination using Fivetran connectors.
Sync overviewlink
To capture new records, we incrementally sync the following tables:
CUSTOMERCUSTOMER_ADDRESSESINVENTORY_MOVEMENTLOCATIONMANUFACTURING_ORDERMATERIALOUTSOURCE_PURCHASE_ORDER_RECIPEPRODUCTPRODUCTION_OPERATIONPURCHASE_ORDERPURCHASE_ORDER_ROWRECIPESALES_ORDERSALES_ORDER_ADDRESSSALES_ORDER_FULFILLMENTSALES_ORDER_ROWSTOCK_ADJUSMENTSTOCK_TRANSFERSUPPLIERTAX_RATEVARIANT
We also re-import these tables once a week to capture updates and deletes.
Schema informationlink
This schema applies to all Katana connectors.
To zoom, open the ERD in a new window.