SAP Online Classes provides Best SAP training Online based on current industry standards that helps attendees to secure placements in their dream jobs at MNCs. SOC is one of the most credible ERP SAP Online training provider, offering hands on practical knowledge and full job assistance with basic as well as advanced level ERP SAP Implementation Training. At SOC ERP SAP training Online is conducted by subject specialist corporate professionals with 14+ years of experience in managing real-time ERP SAP projects.
What database does SAP use?
Software Developer @ SAP SE
SAP Software can run on any Database as it is Database and Operating System Independent.
The SAP server has a special abstraction layer called Database Interface which converts Open SQL Statements into Database specific Native SQL.
Therefore, SAP software is Database Independent and runs on Oracle, DB2,SQL Server, SAP HANA, SAP Sybase, MySQL etc .
I hope this helps …
Benedict John Torres,
Freelance IT Consultant at Freelancers (2000-present)
Unsurprisingly, not all customers are too keen with public cloud. For Germans, the term for stolen is “geklaut” so having your data in cloud sounds like your data is stolen.
Germans, especially with their data protection laws, are not too keen on moving to public cloud.
On the other hand, Amazon, Azure and other cloud providers support SAP on cloud. In addition, the some of the past few companies that they acquired are cloud based.
I run a US-based SAP Consulting Business
I’m going to answer this question for SAP, which is the most sophisticated and complex ERP.
The first thing to understand is there are 200,000+ database tables in SAP ERP. It has a huge functional coverage from Finance, Supply Chain, CRM, Warehouse Management, and many other areas.
Because SAP ERP is database-agnostic, the data dictionary exists in the application tier. For this reason you can migrate from Oracle to MSSQL to SAP HANA databases. But, it means there isn’t a DDL in the database, and so you need to figure out the joins yourself by poking around, reading documentation, or app server code in ABAP. Even something as simple as a customer master or material master has several database tables and complex joins.
But it is possible to access SAP data in ERP via SQL for read-only purposes, it’s just complex. Don’t ever do it for write purposes, not only is it not supported, you will almost certainly accidentally corrupt the database. One exception to this is using TRUNCATE to delete contents in rare circumstances.