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.
Learning Objectives
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
Key Concept

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).

Christian Savelli

Chris Savelli, senior manager at COMERIT, has been dedicated to SAP BI and Analytics projects since 1998.  He holds multiple SAP certifications covering HANA, BW and ECC applications and has expertise in managing all aspects of the information creation process, utilizing SAP BI technologies to satisfy strategic, analytical and reporting needs. Chris Savelli started his career at SAP and subsequently held senior level positions at consulting companies Deloitte and Accenture. His education background includes a bachelor of science degree in robotics and a master of science degree in engineering both from the University of Sao Paulo, as well as a post-graduate diploma in business administration from the University of California at Berkeley.

See more by this author

Marcos Poles

Marcos Poles, SAP Senior Consultant at COMERIT, has been dedicated to managing and delivering SAP solutions for companies across the globe focused on the integration of SAP ECC, BI, and HANA technologies with other SAP and non-SAP products since 1996. Marcos’s current focus is on the integration of SAP and non-SAP systems with SAP HANA utilizing Business Objects Data Services (BODS) as middleware. Prior to working for COMERIT, Inc., he held an executive level position at Accenture and a senior position at Deloitte consulting. His education background includes a bachelor of science degree in physics and a master of business administration degree in information systems and internet technology, both from the University of Sao Paulo.

See more by this author


Comments

No comments have been submitted on this article. 


Please log in to post a comment.

To learn more about subscription access to premium content, click here.