Data Export gives you direct MySQL database access to your Traede data, so you can build custom reports and dashboards in external BI tools like PowerBI or Tableau. The database updates automatically twice a day — at 12:00 and 00:00 - without any manual exports.
When to use Data Export
- Use Data Export if you need regular, complex reports that combine data from multiple modules (orders, inventory, invoices, etc.).
- Use internal reports + Excel for occasional or simpler reporting needs.
Key Features
- Automated nightly updates - All data is refreshed automatically every night
- MySQL server access - Direct database access for integration with BI tools
- Custom fields support - Export includes both standard data and custom fields
- Comprehensive data coverage - Access to all major Traede modules (orders, customers, inventory, products, invoices, production orders, etc.)
- One-time setup - Configure once and maintain ongoing access
- External tool integration - Designed for PowerBI, Tableau, and similar platforms
Pricing
- One-time setup fee
- Monthly subscription fee
Contact the consulting team at consulting@traede.com for information and setup scope.
Available data tables
Once connected, you have access to the following data:
| Group | Tables |
|---|---|
| Customers | customers, customer_groups, customers_agents, customers_customer_groups |
| Products | products, products_variants, products_categories, products_product_groups, products_suppliers, products_tags, products_variants_bundles, products_variants_colli, products_variants_drops |
| Inventory | inventory, inventory_changes, inventory_locations |
| Orders | orders, orders_lines, orders_agents |
| Invoices | invoices, invoices_lines, invoices_agents |
| Production orders | production_orders, production_orders_lines, production_orders_delivery_notes, production_orders_delivery_notes_lines |
| Suppliers | suppliers |
Furthermore we will add all order and product custom fields - If you need a full overview of your data reach out to support@traede.com