The customer has opted for a modern cloud-based data and analytics platform and wants to leverage the added value quickly and transform the organization into a new way of working and thinking. Various measures are planned for the transformation process, which are to be supported by the new platform. To do this, it is necessary to replicate productive data in the new environment in order to support the use case-driven development of the platform.
Oracle DWH migration to Databricks
Challenge
- Development of a company-wide data platform with Databricks
- Use case-driven development of the platform
- Timely provision of data for the development of the platform to activate the organization
- Iterative implementation of use cases and reports to inform management of progress
- Timely development of initial AI use cases with the new platform
- Long runtimes for the creation of risk reports and risk indicators in the actuarial department
Approach and customer benefits
- Timely implementation of use cases on the Databricks platform
- Time equalization of interface adaptation through replication of pre-processed and quality-assured data from the DWH
- Building expertise in the new platform by learning with proprietary data and mapping requirements
- Initiating the company's transformation away from data and key figures toward data as a product
- Achieving strategic milestones and providing positive feedback to management
- Creating the database for initial AI use cases
- Support in setting up the landing zone in the new platform
- Support in lifting and shifting data from the current Oracle data warehouse
- Support in interface analysis and setting up access to Oracle for replication using Oracle GoldenGate
- Support in implementing replication
- Ensuring operational continuity
Tools and technologie
- Oracle Datenbank (DMBS)
- Oracle GoldenGate
- Databricks Data Intelligence Plattform