Lower costs, greater scalability, and seamless integration with advanced analytics and AI tools.

Unlock your data’s full potential by migrating your Business Warehouse (BW) to a Cloud data platform.

BW to Cloud Datawarehouse Migration Service

The transition from Business Warehouse (BW) to a Cloud data platform service leverages Lemongrass’s extensive experience in analyzing, extracting, and testing SAP data for Enterprise customers. This strategic approach minimizes technical debt and enhances the efficiency and effectiveness of the migration process.

Pilot Phase: The pilot phase is integral to the BW to Cloud Datawarehouse Migration process, providing a testing ground with clear success criteria for evaluating the target Cloud data platform’s suitability. Lemongrass specializes in SAP data extraction and the development of Cloud-native SAP data marts. Explore our SAP Data Analytics Accelerator for more information.

Discovery and Assessment Phase: During the Discovery and Assessment phase, it is essential to create an inventory of all BW objects, data sources, and data consumers. This phase not only identifies technical debt but also ensures that only critical objects and data sources actively used by the business are migrated.  

BW Migration Approach

  • Initial assessment to capture and assess inventory of objects to be migrated, data sources, data consumers, dependencies, reports, SLAs
  • Comprehensive assessment to align on target data platform, high-level architecture of target platform, migration plan for BW objects, estimation of timeline and cost of migration
  • Gap Analysis of customization required on pre-built Data Marts
  • Analyze and agree pilot scope
  • Choose data sources and workflows, tables/objects for POC
  • Choose target Cloud data platform (Cloud Native, Snowflake Databricks)
  • Choose data extraction tools (Lemongrass Extractor, Cloud Native, SAP, Third Party)
  • Build Pilot architecture
  • Define success criteria
  • Execute POC/Pilot – Deploy Lemongrass Data Accelerator
  • Data Lake architecture
  • Plan security architecture, including user roles, access controls, and data encryption
  • Capture and design for data governance requirements
  • Design integration with existing source systems, such as ETL processes, reporting tools, and third-party applications
  • Design for data consumers – BI Tools, SQL users, and others
  • Design for scalability to handle future growth and performance optimization
  • Define phases of migration
  • Map objects/jobs/ETL workflows to phases
  • Map reports to data models to data sources
  • Identify potential risks and develop mitigation strategies
  • Create communication and training plan
  • Setup initial load of data from data sources using SLT, Appflow or other ETL tools
  • Setup CDC/Incremental load of data from data sources
  • Deploy pre-built data marts
  • Customize Data Marts as per the gaps identified during assessment
  • Develop/customize reports
  • Perform testing to validate data accuracy, integrity, and performance
  • UAT test and sign off
  • Deploy Data Marts and all objects
  • Setup initial and incremental load for data sources
  • Run both BW and Cloud Data Platform environments in parallel to compare results and performance
  • Continuously validate data between BW and target Cloud platform to ensure consistency
  • Monitor performance metrics in both environments to ensure target platform meets expectations
  • Identify and resolve any issues or discrepancies that arise during the parallel run
  • Perform a final data synchronization to ensure the required data is available in target Cloud data platform
  • Plan and execute the decommissioning of BW
  • Provide support and troubleshooting assistance to users

Elevate your data strategy by migrating your Business Warehouse (BW) to a Cloud data platform!