SAP S/4HANA Cloud is a future-ready enterprise resource planning (ERP) system with built-in intelligent technologies, including AI, machine learning, and advanced analytics. It transforms business processes with intelligent automation and runs on SAP HANA – a market-leading in-memory database that offers real-time processing speeds and a dramatically simplified data model.
SAP S/4HANA Cloud is the next-generation successor to the SAP Business Suite ERP platform. S/4HANA Cloud is intended to be easier to use and administer while helping to solve more complex problems and handle vastly larger amounts of data than its predecessor.
The Progress DataDirect S/4HANA Cloud driver supports all the OData APIs that are available as services from within S/4HANA Cloud along with custom OData APIs. The driver itself can extract, update, delete and create data using any of the existing APIs that support these functions. Direct access to the underlying HANA database isn’t generally given, which is why SAP provides an API layer to access the crucial data found in S/4HANA Cloud.
The Progress DataDirect S/4HANA Cloud driver automatically normalizes the response data from all the available APIs in a S/4HANA Cloud instance and creates a relational data model composed of schemas, tables and column. What does this mean? The S/4HANA Cloud APIs return data in JSON format. JSON is difficult to read and even more difficult to work with in BI, ETL and analytics tools. Simply put: the S/4HANA Cloud driver is the bridge between any SQL-enabled tool or application to S/4HANA Cloud. Once normalized, the data model (see image below) will consist of over 200 schemas, hundreds of tables and thousands of columns covering master data for business partners, materials, inventory, material ledger, sales and accounting.
We hope this tutorial helped you to get started with the Progress DataDirect SAP S/4HANA JDBC connector and connect to your data in SAP S/4HANA Cloud. Feel free to contact us if you have any questions about using the driver and we will be happy to help you.