Onelake Integration for ERP Data

I need a clean, automated pipeline that lands data from three operational systems—Navision ERP, our SGA warehouse platform, and a GMAO maintenance tool—into a structured SQL layer hosted in Microsoft Fabric OneLake.

Scope of data
• Navision ERP: customer, inventory, sales, and production records
• SGA: warehouse, order, and shipping information
• GMAO: work-order details and machine-estop events

What I expect
1. Connection setup to each source (API, ODBC, or native connector—whatever is most reliable).
2. A repeatable extraction routine with incremental loads so the lake stays current without full reloads.
3. Basic transformations that normalise field names, data types, and key relationships before writing to the target SQL tables.
4. Separate destination tables inside OneLake SQL for each data group, with primary keys and indexes ready for reporting.
5. Error handling, logging, and a simple dashboard or log file that shows last-run status.
6. Deployment scripts plus concise documentation so my team can maintain or extend the flow later.

If you have hands-on experience with Fabric pipelines, Azure Data Factory, SSIS, or comparable ETL tooling and can deliver a tested end-to-end solution, let’s talk timelines and milestones.