How to Move Your Data into SAP HANA with SDA and BODS
- by Christian Savelli, Senior Manager, COMERIT
- Marcos Poles, SAP Senior Consultant, COMERIT
- November 17, 2014
Use this step-by-step procedure prepared by Christian Savelli and Marcos Poles to deploy the combination of Smart Data Access (SDA) and SAP BusinessObjects Data Services (BODS) for data migration from legacy systems to SAP HANA.
Reading this article, learn how to:
- Provision data to SAP HANA via SAP Smart Data Access (SDA)
- Migrate historical data from a legacy database to SAP HANA using SAP BusinessObjects Data Services (BODS)
- Validate data consistency between SAP HANA and conventional databases using the SAP BODS table comparison functionality
SAP Smart Data Access (SDA) is a technology that virtualizes remote data sources into SAP HANA, allowing users to easily access external datasets in real time. SAP BusinessObjects Data Services (BODS) is a complete extraction, transformation, and loading (ETL) tool containing many features for data cleansing, data transformation, and validation.
Many considerations are in play when migrating legacy database-related reporting applications to SAP HANA. From a functional perspective, one of the most important of these considerations is minimizing disruption to business users and operations. A big bang, database export/import may seem a simple and straightforward approach. However, it carries the risk of spending time and effort coping with obsolete tables, views, and system-specific procedures no longer applicable within an SAP HANA context. The challenge is how to clearly pinpoint the relevant, actively-in-use table footprint for migration.
Two technologies can be effectively combined during database-migration projects, which initially assist with the validation of tables prior to their migration. Subsequently, the same two can be used to support the data validation and materialization in the SAP HANA database during cutover and post-go live activities. These technologies are known as Smart Data Access (SDA) and SAP BusinessObjects Data Services (BODS).
Would you like to see this full item?