/ENGINEERING REFERENCE
Connecting SAP or other systems via a handover database
You load selected data from your SAP into a database in your own infrastructure. Edmund reads only that database and does not connect to SAP.
Overview
How it works
- The handover database runs in your infrastructure.
- You load selected data from your SAP into it. Edmund does not connect to SAP.
- Other source systems can feed the same database.
- Edmund reads only the handover database. It connects through a read-only account and checks every query it generates as read-only before running it. The connection runs over a NAT gateway with port forwarding, a Site-to-Site VPN or VPC peering.
Supported databases
The handover database can run on any of these engines.
| Engine | Notes |
|---|---|
| Microsoft SQL Server | |
| PostgreSQL | |
| Oracle | Service name or SID. |
| Snowflake | Database, schema and warehouse. |
| SAP HANA | |
| InfluxDB | Time-series database. |
Other engines can be added as connector development.
Because Edmund reads only the handover database, it does not matter which database your SAP itself runs on.