JDBC
Quick answer
Use JDBC integration when a system exposes only its database (no API), typically legacy applications.
Key takeaways
- Through a JDBC adapter (in PI/PO or CPI), SAP integration can query and update external databases with SQL, moving data between SAP…
- JDBC adapter in the middleware.
- SQL for read/write operations.
- Watch out: Wrong tool for the integration style.
What JDBC integration does
Through a JDBC adapter (in PI/PO or CPI), SAP integration can query and update external databases with SQL, moving data between SAP and systems that have no proper API. It is a pragmatic way to integrate database-only applications, though it couples to their schema.
Key aspects
- JDBC adapter in the middleware.
- SQL for read/write operations.
- Polling for changed data.
- Schema coupling to the target database.
When to use it
Use JDBC integration when a system exposes only its database (no API), typically legacy applications. Prefer proper APIs where available; JDBC integration is a pragmatic fallback that requires care around the target’s schema and data integrity.
Common pitfalls
- Wrong tool for the integration style.
- Ignoring monitoring/error handling.
- Point-to-point instead of governed integration.
Want to learn this properly?
Our live, instructor-led SAP Training covers this hands-on, with real projects and a certification path.
Check your understanding
Which statement is true of JDBC?
- A. Fiori performance depends on the whole stack, the UI5 app, the OData service, and the backend/CDS, plus…
- B. It is a pragmatic way to integrate database-only applications, though it couples to their schema.
- C. This FAQ hub answers the questions people most often ask when learning and working with SAP, the conceptual…
Show answer
B. It is a pragmatic way to integrate database-only applications, though it couples to their schema.
Covered in the “What JDBC integration does” section of this lesson.
Which of these also applies to JDBC?
- A. Upgrading without reading the notes.
- B. Prefer proper APIs where available; JDBC integration is a pragmatic fallback that requires care around the…
- C. Copying without understanding the context.
Show answer
B. Prefer proper APIs where available; JDBC integration is a pragmatic fallback that requires care around the…
Covered in the “When to use it” section of this lesson.
Which part of the Learn SAP curriculum covers JDBC?
- A. SAP integration
- B. SAP FI
- C. SAP examples
Show answer
A. SAP integration
This lesson sits in the SAP integration section of the Learn SAP course.