Loading data: There are several options AVAILABLE to GET data into HANA. SAP provides a real-time replication server called SLT Replication. With this server you can replicate data from a SAP system or non-SAP RDBMS systems into HANA. The data is copied in its native format and will then need to be de-normalized on HANA using information views (attribute views, ANALYTIC views and calculation views). According to the documentation, you can also leverage the Sybase Replication Server for log based replication. In addition, Data Services 4.0 can be used to move data into HANA and can update data at near real time if needed. Data Services 4.0 can also de-normalize the data given its abundance of data transforms and provide data quality and cleansing transforms that will help clean the data before it is loaded into HANA.

Access the data: There are several ways to access the data within HANA. The ideal way to access data is through SAP BUSINESS Objects 4.0. There are multiple tools within the Business Objects 4.0 platform for accessing HANA data. You can utilize Web Intelligence, CRYSTAL Reports, Explorer, “Analysis Edition for Microsoft Office”, Mobile and Dashboard (Xcelsius). In short, any tool in the platform that supports ODBC or a Universe can be utilized to access data within HANA. These options work for SAP BW (powered by HANA) or for HANA (Standalone). If you have SAP BW powered by HANA, you can utilize any of the traditional query tools. For those that like viewing raw data results, you can utilize HANA Studios to execute SQL statements and view the results.

Loading data: There are several options available to get data into HANA. SAP provides a real-time replication server called SLT Replication. With this server you can replicate data from a SAP system or non-SAP RDBMS systems into HANA. The data is copied in its native format and will then need to be de-normalized on HANA using information views (attribute views, analytic views and calculation views). According to the documentation, you can also leverage the Sybase Replication Server for log based replication. In addition, Data Services 4.0 can be used to move data into HANA and can update data at near real time if needed. Data Services 4.0 can also de-normalize the data given its abundance of data transforms and provide data quality and cleansing transforms that will help clean the data before it is loaded into HANA.

Access the data: There are several ways to access the data within HANA. The ideal way to access data is through SAP Business Objects 4.0. There are multiple tools within the Business Objects 4.0 platform for accessing HANA data. You can utilize Web Intelligence, Crystal Reports, Explorer, “Analysis Edition for Microsoft Office”, Mobile and Dashboard (Xcelsius). In short, any tool in the platform that supports ODBC or a Universe can be utilized to access data within HANA. These options work for SAP BW (powered by HANA) or for HANA (Standalone). If you have SAP BW powered by HANA, you can utilize any of the traditional query tools. For those that like viewing raw data results, you can utilize HANA Studios to execute SQL statements and view the results.