It is funny cause I work in a company that use both SAP and a Oracle SQL db for finance data, and I totally agree with you i’m in the Oracle team and I’m soo happy not the be in the SAP team, asking them simple monthly export take few hours vs less than minutes in Oracle.
Plus the interface looks horrible and you can’t really access the underlying data outside of their shitty UI.
What is going on in this thread!? If you work in IT, you should know better than what you claim here. It’s completely fine to dislike SAP. It definitely has its flaws but your statement is so blatantly wrong that it almost feels like some kind of orchestrated propaganda.
All the data in SAP is stored in a database system. It can be Oracle, IBM etc. or their propietary HANA database. All data is freely accessible directly in the tables from the application itself (e.g. via transactions like SE16, SQVI, ST04 etc.), you can use Eclipse and other external tools the SAP layer and of course you can also directly access the underlying database completely bypassing the SAP frontend.
Performance- and feature-wise the SAP and HANA database or Oracle in-memory database aren’t any different. If it takes your colleagues hours to extract some data, then it’s either a lot of data, very complex queries or they’re doing something wrong.
I’m sure you are right, I wouldn’t be surprised at all if they are using it wrong for whatever reason and it is underoptimized.
But still the whole thing look like a convoluted system that I would not want to touch
It is funny cause I work in a company that use both SAP and a Oracle SQL db for finance data, and I totally agree with you i’m in the Oracle team and I’m soo happy not the be in the SAP team, asking them simple monthly export take few hours vs less than minutes in Oracle. Plus the interface looks horrible and you can’t really access the underlying data outside of their shitty UI.
What is going on in this thread!? If you work in IT, you should know better than what you claim here. It’s completely fine to dislike SAP. It definitely has its flaws but your statement is so blatantly wrong that it almost feels like some kind of orchestrated propaganda.
All the data in SAP is stored in a database system. It can be Oracle, IBM etc. or their propietary HANA database. All data is freely accessible directly in the tables from the application itself (e.g. via transactions like SE16, SQVI, ST04 etc.), you can use Eclipse and other external tools the SAP layer and of course you can also directly access the underlying database completely bypassing the SAP frontend.
Performance- and feature-wise the SAP and HANA database or Oracle in-memory database aren’t any different. If it takes your colleagues hours to extract some data, then it’s either a lot of data, very complex queries or they’re doing something wrong.
I’m sure you are right, I wouldn’t be surprised at all if they are using it wrong for whatever reason and it is underoptimized. But still the whole thing look like a convoluted system that I would not want to touch