Hello !
We will see here how to setup SDA (Smart Data Access) to access my data in SAP IQ - NLS(Near Line Storage). Assuming that we are running an SAP HANA database (>SPS06).
SMART DATA ACCESS
In SAP BW, SAP HANA Smart Data Access is used as the source for Open ODS views and for query access to data in Sybase IQ as a near-line storage solution. With SAP HANA Smart Data Access, data can be merged in heterogeneous EDW landscapes (data federation).SAP HANA Smart Data Access make it possible to access remote data, without having to replicate the data to the SAP HANA database beforehand. The following are supported as sources: Teradata database, SAP Sybase ASE, SAP Sybase IQ, Intel Distribution for Apache Hadoop, SAP HANA. SAP HANA handles the data like local tables on the database. Automatic data type conversion makes it possible to map data types from databases connected via SAP HANA Smart Data Access to SAP HANA data types.
The following are example of activities that you can perform using SAP HANA Smart Data Access:
When using SAP HANA Smart Data Access for query access to data in Sybase IQ as a near-line storage solution and as a source for Open ODS views, it offers the following advantages:
Near Line Storage(NLS)
To begin with, SAP will take complete control of persistence management for its Business Warehouse and will offer an SAP owned NLS implementation for Sybase IQ. Instead of having to rely on partner solutions, customers will then receive all the components required for running an EDW directly from SAP, including the DWH application (SAP NW BW), the databases (SAP HANA DB and SAP Sybase IQ) and an intelligent NLS management solution.
SAP is pursuing a three-step color-coded persistence management concept.
Active data that has to be accessible on a permanent basis for read and write processes is referred to as ‘hot’ data. As would be expected, this data is stored in the main memoryof the HANA DB.
Warm data, which is not accessed quite so often, is best stored in the HANA DB file system. Whenever this data is loaded into the main memory for processing, it is displaced with higher priority once processing has finished.
To achieve this, the BW development team has developed a non-active data concept in order to optimize the displacement strategy for BW tables in the HANA DB. Here, tables with warm data are flagged and are prioritized for displacement from the main memory whenever they are used. These tables are normally partitioned in the default setting, and only the partitions of the table that are affected by the transaction are loaded to the main memory.
Solution Overview
Prerequisites:
Procedure:
4. Grant Remote Source privileges to SAP user In SQL
GRANT CREATE VIRTUAL TABLE, DROP ON REMOTE SOURCE "SAPHBW_NLS" TO "SAPHBW";
Hope it's worth. Thank you...Cheers !!
Ajay Kumar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
37 | |
10 | |
5 | |
4 | |
4 | |
3 | |
3 | |
3 | |
2 | |
2 |