Katana
Let AI connect your sources for you
Skip the manual setup — run this in your project and the wizard auto-detects your databases and APIs and connects them to PostHog.
Connect Katana to PostHog to sync your data into the PostHog data warehouse for analysis and modeling.
Enter your Katana API key to sync your Katana Cloud Inventory (MRP) data into the PostHog Data warehouse.
Generate an API key in Katana under Settings > API (an active API access add-on / Professional plan is required). The key is sent as a Bearer token and has read access to your factory's data.
Configuration
| Option | Type | Required |
|---|---|---|
API key | password | Yes |
Linking Katana to PostHog
- Go to the Data pipeline page in PostHog
- Click New source and select Katana
- Fill in the required configuration fields
- Click Next, select the tables you want to sync, and then press Import
Supported tables
| Table | Description | Sync method | Incremental field | Primary key |
|---|---|---|---|---|
products | Sellable/producible items in the factory, each with one or more variants. | Incremental, Full refresh | updated_at, created_at | — |
materials | Raw materials and ingredients consumed by manufacturing orders. | Incremental, Full refresh | updated_at, created_at | — |
variants | Individual SKUs of a product or material, carrying sales/purchase prices and barcodes. | Incremental, Full refresh | updated_at, created_at | — |
services | Sellable services offered alongside physical products. | Incremental, Full refresh | updated_at, created_at | — |
customers | Customers you sell to, including contact and billing details. | Incremental, Full refresh | updated_at, created_at | — |
suppliers | Suppliers you purchase materials and products from. | Incremental, Full refresh | updated_at, created_at | — |
sales_orders | Customer sales orders, including status, fulfillment and invoicing state. | Incremental, Full refresh | updated_at, created_at | — |
purchase_orders | Purchase orders raised to suppliers for materials and products. | Incremental, Full refresh | updated_at, created_at | — |
manufacturing_orders | Production orders that manufacture products from materials. | Incremental, Full refresh | updated_at, created_at | — |
sales_returns | Returns raised against sales orders, with refund and restock status. | Incremental, Full refresh | updated_at, created_at | — |
stock_adjustments | Manual stock corrections that increase or decrease on-hand quantities. | Incremental, Full refresh | updated_at, created_at | — |
stock_transfers | Movements of stock between two locations. | Incremental, Full refresh | updated_at, created_at | — |
stocktakes | Physical inventory counts and the adjustments they produce. | Incremental, Full refresh | updated_at, created_at | — |
inventory_movements | Append-only log of every inventory movement created by Katana resources. | Incremental, Full refresh | created_at | — |
inventory | Current on-hand, committed and expected stock per variant and location. Full refresh only. | Full refresh | — | — |
price_lists | Named price lists used for customer-specific pricing. Full refresh only. | Full refresh | — | — |
locations | Warehouses and factories where stock is held and orders are fulfilled. | Full refresh | — | — |
tax_rates | Tax rates applied to sales and purchase orders. | Full refresh | — | — |