Designing Reliable SQL Projects addresses a problem most SAP landscapes know too well: Stale warehouses and failed night jobs undermine dashboards the C-suite already promoted.
The SQL Project Cockpit defines source objects, target tables, field mapping, delta parameters, and schedules — monitored in SQL Job Monitor with package-level error detail.
SQL Transfer moves SAP data to MSSQL or PostgreSQL using project-based jobs with methods I (full refresh), A (append), U (upsert), D/L (delta), package sizing, and parallel processing.
Capabilities you use in iDataEngine
- Methods I, A, U, D, L with delta parameters
- Project clone and monitoring KPIs
- Package size and parallel processing
- Connection test from the maintenance screen
- Masking on SAP → SQL direction
- Key-field matching for update-or-insert loads
Recommended workflow
- Configure source objects, fields, mappings, or rules using session language and customer/system context.
- Enable monitoring alerts and review dashboard KPIs for the first production cycle.
- Run Test (iDataView Test, SQL First Row, API Test Service, or AG scan) before scheduling or publishing.
- Save and capture the generated URL, job ID, or snapshot reference in your change record.
Real-world scenario (2021)
E-commerce stock sync every ten minutes via upsert into PostgreSQL — website stays fast when SAP is slow because SQL Transfer owns the cache layer.
Why it matters
Dual-engine parity means you are not locked to one DBA religion — architecture stays portable while jobs stay monitored the same way.
That combination is why enterprises adopt iDataEngine as a lifecycle platform — not a one-off integration tool.