Can HANA use along with present database?

[Former Member]

Hello All,

At present my client is not using SAP HANA functionality. Present data base is Oracle. Frequently SAP job get fail due to memory issue.

Or some time job run very log time. I need advice Can we use SAP HANA to run big data job along with present database means the job which require more database space will only run on HANA does it possible? if it is possible if yes how?

[rama_shankar3]

Vina:

If you are looking at solving the performance issue for good. You need to have your client contact their SAP account manager to look at migrating to HANA. Note: HANA for ECC is in GA version now and the migration is easy with few customers in production.

Addressing your question: if you want to have HANA as a secondary DB to  process Oracle transactions from ECC and replicate back to Oracle -  you will introducing unwanted complexity in the environment. I would not recommend you take this approach. Instead, look at your hardware and memory used to run Oracle so that you can fine tune for short-term and long-term move to HANA.

Good luck!

Regards,

Rama

[stefan_koehler]

Hi Vina,

i have another totally crazy idea .. why not analyzing and tuning the business process / task with the Oracle database instead of introducing a whole new technology stack?

I know that HANA is considered as the sexiest software alive, but i am pretty sure that you also get this business process finished in time (SLA) with Oracle.

Regards

Stefan

[former_member184768]

Hi,

I agree with Stefan and also have another point to add.

Agree on the point that just to perform some SAP jobs which are running out of memory, you may not want to introduce HANA. It is just too expensive for such a thing. As Stefan suggested, you may want to fine tune the Oracle database itself along with the business process (may be even increase the database buffer cache) to address the SAP jobs issue.

But if you are looking for more use cases, than just speeding up the jobs, then HANA would be a good choice. It also depends on your organization future technology roadmap, IT budgets, business cases / use cases which cannot be implemented with the existing technology, but can be addressed with In-Memory architecture etc.

So based on other parameters, you may wish to consider the option to implement HANA.

Recently got to know about SAP RTDP (Real Time data platform), which mentions that even migrating to Sybase IQ (which provides Columnar architecture) can be more cost effective and can provide performance benefits. Hence even that option is worth looking into.

Regards.

Ravi

[Former Member]

Yes, you can run SAP HANA as the secondary database for Oracle. You can use SLT to keep data synchronized between SAP HANA and Oracle.

Then you can point your complex queries and reports that run against the Oracle DB against the HANA DB. I have seen 1000x improvement in long running queries and reports using this mechanism.

John

[Former Member]

HI John,

Thanks for feedback.

Can you provide more information regarding solution like

1. How both database synchronized

2. Installation of HANA is expensive

3. Any technical limitation while installing HANA

4. Any additional point if you would like to share

[Former Member]

Hi Vina,

I agree with John, and you can use HANA as a second database in this case.

In advance to your questions:

1) you should use SLT (SAP Landscape Transformation) [check http://help.sap.com/saplt or http://scn.sap.com/docs/DOC-9002] or Sybase Replication Server installed and configured on your environment. Then you should create and enable the replication between Oracle and HANA Tables [help can be found http://www.saphana.com/docs/DOC-3791 and http://www.saphana.com/docs/DOC-2441].

2) Many variables can influence the total expense.

3) SAP HANA is an appliance. It requires some features such as hardware and software. [check http://help.sap.com/hana].

Regards,