Future State - The Oracle Consulting Blog

How do you simplify a database transformation project?

Kathy Wu
Communication Manager

We share 3 steps to delivering success



Author: Tolgahan HANCI, Senior Oracle Consultant

In recent years, there has been a gap in the market for alternative modern enterprise cloud solutions that can meet a comprehensive set of needs including performance, flexibility, and scalability - all at an affordable cost. 

A tremendous rise in demand for data analytics and increasing volumes of data has meant that some on-premises enterprise Data Warehouse (DWH) solutions are struggling to fulfill the requirements of modern DWH. Although businesses might achieve a certain degree of flexibility and scalability by lifting and shifting these workloads to the public cloud, high cost and scalability will still remain as the primary concern for companies attempting to get the same performance with their on-premises solution.


“The main challenge during these migrations included lack of required know-how, skillset or time that is required by the customer to drive this type of transformation project. At Oracle Consulting we can step in and provide our vast experience and service to help our customers.”

– Tolgahan Hanci, Senior Principal Consultant

In order to address legacy issues and provide the best database solution in the market, Oracle offers two Exadata Cloud solutions:


Both of these Oracle Exadata Cloud offerings provide modern, flexible, agile and scalable features that meet and exceed business needs. Besides their flexible and scalable features, Oracle Exadata Cloud solutions provide an extremely improved performance compared to any on-premises DWH, whilst significantly lowering the total cost of ownership. ExaCC/ExaCS also provide a robust Disaster and Recovery (DR) solution with Oracle Data Guard, and secure customer data with Transparent Data Encryption (TDE).


The benefits of moving to Exadata Cloud:

  • Improved performance with lower cost – Market research company International Data Corporation (IDC) says organizations using Exadata Cloud@Customer were able to reduce operational costs by 47% and realize a 256% return on investment.

  • Better flexibility - Workloads easily move between on-premises data centers, Cloud@Customer deployments, and Oracle Cloud Infrastructure, enabling customers to modernize operations.

  • Enhance scalability - Allows customers to create 25 Petabyte (PB) data warehouses and accelerate data-driven insights through rapid analysing. 

  • Automation - Common DBA tasks, such as indexing and tuning, can be automated and therefore increase workforce efficiency.


These benefits are acknowledged by many of our customers and we see increasing demands from customers who want to offload legacy data warehouse solutions to Oracle Exadata Cloud Services.  

The main challenge during these migrations includes lack of required know-how, skillset or time that is required by the customer to drive this type of transformation project. At Oracle Consulting we can step in and provide our vast experience and service to help.


3 steps to deliver success: 


Having specific know-how on the source system (Oracle and non-Oracle database solutions) will ensure the ability tounderstand the architecture and help customer in running the complex code conversion tasks. 


The ability to bring hands-on experiences and knowledge from similar transformation projects also plays an important role in the success. Within our organization, we have a specialized and experienced consultant team with a broad knowledge of our competitor’s solutions.



Duration of the project is an important key to success for customers. A long duration is often a challenge for the business and may likely impact customer decisions to act. Since there is a shift in technology and in many cases also conversion of the code is required in such transformation projects, they are generally categorized as long-term projects. The duration of the project is most often heavily influenced by the number and complexity of the objects in the source system and in the surrounding applications. The length of this type of project can typically vary from 6 to 18 months. 

Oracle Consulting’s vast experience and knowledge collected by individuals during similar migration projects over the years allows us to sustain the quality of delivery and at the same time reduce project duration. Data migration automation is one example of an important tool we at Oracle Consulting can offer.



Our experience shows that tight collaboration between the customer and our consulting team is key for project success, since these types of projects are typically complex.



The structure of an DWH transformation project:

  1. It starts with a discovery phase in which current environment and the workload is retrieved. 

  2. This is followed by an analysis phase in which collected information is analyzed and the target architecture and migration plan is defined. 

  3. The third step covers code conversion, data migration and integration with other environments. 

  4. The final step is the transition phase, where Oracle Consulting assists with post go-live support and perform the knowledge transfer.



As Oracle Consulting, we are ready to guide our customers on their cloud journey from expensive and legacy on-premises solutions to a modern and flexible Oracle Cloud solution.



Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.