Data ingestion and transformation

Messy data in, a planning-ready model out.

Horizon connects out of the box to all major ERPs, such as SAP, Oracle and Microsoft Dynamics, and also works with a simple Excel or CSV. AI-guided mapping turns extracts, spreadsheets and ERP tables into one planning-ready structure, flags missing or incorrect values, and carries the mapping over every cycle. No IT project required.

Start with Horizon InstantBook a demo
SourcesQualityMapping
Data scan
Example · this cycle’s data
ERP · SAPConnectedExcel · promotionsUploadedCSV · customersUploaded
48,210 records checked56 flagged
Missing lead times41 itemsAdd in Horizon
Unit of measure mismatch12 itemsFix at source
Duplicate item codes3 itemsLink
Mapping saved for the next cyclePublish to planningPublished
3ways in

ERP connectors out of the box, Excel or CSV

ERPExcelCSV
1structure

planning-ready, from extracts, spreadsheets and ERP tables

ExtractsSpreadsheetsERP tables
<24hours

up and running with Horizon Instant

ConnectMapPlanLive
ERP tablesSAP, Oracle, DynamicsSpreadsheetsExcelExtractsCSVConnectERP, Excel, CSVScanData qualityMapAI-guidedLinkItems, customersValidateChecksPublishTo planningOne planning-ready modelThe mapping carries over every cycle · no IT project required
Dataplanning-ready
ConnectERP, Excel, CSV
ScanData quality
MapAI-guided
LinkItems, customers
ValidateChecks
PublishTo planning
One planning-ready modelThe mapping carries over every cycle

What you can do

Your data, ready to plan with.

ERP connectors

Connected to your ERP out of the box

  • Horizon connects out of the box to all major ERPs, such as SAP, Oracle and Microsoft Dynamics.
  • No ERP connection yet? A simple Excel or CSV works too.
  • Customer data is kept separate per customer and never used to train public models.
Data sources
Example
ERP · SAPSales orders, shipments, items, customersConnectedExcel · promotions calendarUploaded by marketingUploadedCSV · customer hierarchyExported from CRMUploadedYOUR DATAKept separate per customerNever used to train public models

Data quality scan

Missing or wrong values, flagged automatically

  • Missing or incorrect values get flagged automatically.
  • Planners fix them at the source or add the missing data directly in Horizon.
  • Validation checks run before the data is published to planning.
Data quality · this cycle
Example
Data quality scan · 48,210 records56 to fixMissing lead times41 itemsAdd in HorizonUnit of measure mismatch12 itemsFix at sourceDuplicate item codes3 itemsLinkValidation checks run before publishing to planning

AI-guided mapping

One planning-ready structure, mapped once

  • AI-guided mapping turns extracts, spreadsheets and ERP tables into one planning-ready structure.
  • Items, customers and locations linked across sources.
  • No IT project required, and the mapping carries over every cycle.
Mapping · sales orders
Example
SOURCE FIELDHORIZON FIELDMATCHMATNRItem code98%KUNNRCustomer97%WERKSLocation95%MengeQuantity93%Promo start (Excel)Event start88%Mapping saved · reused every cycleNo IT project

Learn more

Learn more about data ingestion and transformation.

What is demand planning?How does AI improve demand planning?Horizon InstantDemand planning

FAQ

Data ingestion and transformation, answered.

Which systems does Horizon connect to?

Horizon connects out of the box to all major ERPs, such as SAP, Oracle and Microsoft Dynamics, and also works with a simple Excel or CSV.

Do we need an IT project to get our data in?

No. AI-guided mapping turns extracts, spreadsheets and ERP tables into one planning-ready structure, and the mapping carries over every cycle.

What happens with missing or incorrect data?

Missing or incorrect values get flagged automatically, so planners can fix them at the source or add the missing data directly in Horizon. Validation checks run before the data is published to planning.

What does planning-ready mean?

Items, customers, locations and history linked and checked in one structure that the forecasting and supply engines can use directly.

Is our data used to train models for others?

No. Customer data is kept separate per customer and never used to train public models.

How fast can we start?

Start with Horizon Instant: your ERP connected and real demand planning on your own data, up and running in less than 24 hours.

Get your data planning-ready.

Horizon Instant: up and running in less than 24 hours.

Start with Horizon InstantBook a demo