Data warehouse
The data warehouse pipeline copies your operational data from Miridia into a database that you own. Use it for business intelligence, finance analysis, executive reports, long-term audit storage, or to supply data to other systems.
Supported targets
| Target | Status |
|---|---|
| PostgreSQL | Available |
| BigQuery | Available |
| Snowflake | Available |
| Other warehouses | Via consulting services |
What the pipeline syncs
The pipeline copies the data that you need for analysis:
- Sales orders and their items
- Inventory positions and the inventory movement ledger
- Purchase orders and receipts
- Transfer orders
- Bill of material costs
- Price history
- Forecasts from Miridia Planner
The pipeline runs on a schedule, or when an event occurs. You and our team agree the tables, the schedule, and the schema during the set-up.
Use your own BI tools
The data is in a normal database. Thus each BI tool that reads that database can use it, for example Power BI, Tableau, Qlik, Looker, or Metabase. You do not need an export, and you do not need a special connector for Miridia.
Your data stays yours
When the pipeline copies data into your warehouse, that data belongs to you. You can keep it after you stop the pipeline. There is no lock-in on your analytics.
Other ways to get your data are:
- The REST API, which gives access to all your records.
- A full data export. Contact us to arrange one.
Set up the pipeline
Tell us your requirements
Tell us which target you use, which data you need, and how fresh the data must be.
Prepare the target
Make a database or a dataset for Miridia in your warehouse. Make a user that can create tables and write data in it. Give our team the connection details through a secure channel.
Agree the schema
Our team designs the tables with you. We can also help you design the reports and the models that use the data.
Start the sync
Our team starts the first full sync. After that, the pipeline adds changes on the agreed schedule.