Skip to Content
0

BW/HANA using IQ as NLS - do I have to use SDA in order to retrieve data?

Oct 31, 2017 at 03:10 PM

47

avatar image
Former Member

Hi folks,

I have a question surrounding data retrieval. We are on BW7.30/SPS15, HANA SPS12

If we build NLS as a cold storage to our HANA system (in order to archive off old data) do we need to configure SDA (i.e. virtual tables) in order to pull/read data back from IQ into SAP BW or can we pull directly from IQ itself (thus bypassing HANA altogether)?


I cant seem to find any documentation which answers my question. Hope you can help.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Frank Schuler
Oct 31, 2017 at 05:44 PM
0

Hello Andrew,

Yes, Smart Data Access (SDA) is the IQ NLS way of access for both BW on HANA and BW/4HANA:

SAP HANA Smart Data Access (SDA) for Near-Line Storage in SAP IQ

SAP HANA Smart Data Access

Best regards

Frank

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Andrew,

As Frank pointed out the preferred method is to configure BW to use SDA for all reads to SAP IQ (NLS). But you are not required to use SDA for reads. If you don't configure SDA to SAPIQ in HANA the BW ABAP stack will default to the IQ ODBC drivers and all reads from BW to NLS are handled via the DBSL.

Hope this helps.

Scott

0
avatar image
Former Member Nov 01, 2017 at 08:36 AM
0

Much appreciated for the reply Frank.

So just so I fully understand, in order for the SAP BW user to retrieve data from the cold store NLS (IQ system) the only way is to use SDA?

Share
10 |10000 characters needed characters left characters exceeded