Advantages over SAP HANA
Let me start with benefits of, SAP HANA:
1. SAP HANA presents real-time evaluation then decision-making capability. It
enables technology over extensive amounts of information while the commercial
enterprise is running on. Thus, that gives immediate real-time insights.
2. The in-memory database technology makes records processing yet transactions
very quick by smart thinking process from RAM. Therefore, facts perform lie
immediately and rapidly processed beyond any know database.
3. SAP HANA lets in information stored and processed in columns and rows of
the database. Also, many operations parallelly processed in SAP HANA namely
opposed traditional RDBMS technology in the typical database for processsing
some query. Thus, analogy is parallel processing technology will increase the
speed of function multifold.
4. In traditional database, customers do use solely one on the transactional
strategies (OLTP then OLAP) at a time. But, in SAP HANA’s in-memory database,
customer is able to get retrieve data from more than a few databases for each
transactional (OLTP) than analytical (OLAP) queries parallelly all at once.
5. You can acquire information besides various external facts sources that fit
the source-agnostic capabilities concerning SAP HANA. Also, that makes the SAP
HANA to function similar with distinct DBMS aged across the organization.
Thus, enabling handy information integration. Without interrupting the
continuous commercial enterprise operations, you execute perform records
integration or total out of various capabilities or records sources within SAP
HANA. You do additionally combine that with SAP Business Object BI solutions
by using tools like
SAP Lumira, Web Intelligence, SAP Crystal Reports, Design Studio, Dashboard
designer, Universe Designer (IDT/UDT), BusinessObjects Explorer, Analysis
Office, MS Excel.
6. If the power fails for some reason the Persistent Data Repository will
ensure that your business is recovered in case of a breakdown. By the
real-time facts counterpart service, we can perform replicate the information
between old SAP ERP and SAP HANA , not distributing existing operations of the
enterprise suite.
7. For third-party software access, it may use features regarding SQL/MDX.
8. Using data modelling and devising tools, data models are performed virtual.
It also makes the procedure over modeling and re-modeling altogether easy.
9. Admin Cockpit correctly manages and display various parameters of units of
SAP HANA making life easy.
Disadvantages partial limitations of SAP HANA:
1. SAP HANA generally runs on SUSE Linux licensed hardware. It creates a
problem because if the customer wants to run on any other hardware, the
expenses concerning licensing are altogether high.
2. Limited hardware utility according to use SAP HANA a pricey investment.
3. SAP HANA does no longer supports all ERP products because of their
different types of architecture. SAP HANA requires ERP users to change their
architecture in imitation of redacting such HANA compatible.
4. The older version becomes out of date at all soon, this due to the face SPS
releases and updates in the SAP HANA versions. And, it would be concerning by
person handing ERP, each time and updating is time-consuming.
5. It has been noticed that SAP HANA server shut down at times of heavy data
processing and calculation load.
6. Using hybrid solutions regarding HANA like walking that incompletely
concerning the cloud integration , incompletely on-premise reasons a cluster
about problems and doesn’t feature properly.
7. Usually, builders whosoever nonetheless proceed along their historic ways
about assignment along with database technologies, are not capable of
conformity with using SAP HANA to its complete potential. They solely utilize
that as a quickly in-memory database, while even are deep other capabilities
yet functionalities that SAP HANA provides.
8. SAP HANA appliance only certified in IA platform.
9. The relative new HANA Database is still addressing issues of that are
related new products.