2.1 ERP Integration

Connecting to ERP systems.

The Gateway can connect to any SQL-based ERP database:

• SAP (via SAP HANA or SQL export)
• Microsoft Dynamics (SQL Server)
• PSI PENTA (SQL Server / Oracle)
• proALPHA (SQL Server)
• Sage (SQL Server)

[ERP Database] <-> [Data Gateway] <-> [Applications]

1. Configure Gateway on Dynamics SQL Server
2. Read-only user with view access
3. OData endpoint for Excel/Power BI

• Only expose views (no base tables)
• Dedicated database user
• Read access sufficient for reporting