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:
CUSTOMER
CUSTOMER_ADDRESSES
INVENTORY_MOVEMENT
LOCATION
MANUFACTURING_ORDER
MATERIAL
OUTSOURCE_PURCHASE_ORDER_RECIPE
PRODUCT
PRODUCTION_OPERATION
PURCHASE_ORDER
PURCHASE_ORDER_ROW
RECIPE
SALES_ORDER
SALES_ORDER_ADDRESS
SALES_ORDER_FULFILLMENT
SALES_ORDER_ROW
STOCK_ADJUSMENT
STOCK_TRANSFER
SUPPLIER
TAX_RATE
VARIANT
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.