Skip to Content
avatar image
Former Member

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 31, 2017 at 05:44 PM

    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

    Add comment
    10|10000 characters needed 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

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

    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?

    Add comment
    10|10000 characters needed characters exceeded