Modernizing the Oracle ODS Data Warehouse for SaaS flexibility with PostgreSQL on AWS

Imagine trying to keep up with the evolving needs of higher education institutions while ensuring your systems are cost-effective and scalable. This was the challenge faced by our client, a company providing a suite of software solutions for educational institutions. They needed to modernize one of their core components—an Operational Data Storage (ODS) system, which essentially served as a Data Warehouse for preparing data for BI (reporting), originally built on Oracle—by migrating to PostgreSQL in AWS. The primary goal of […]

Oleksii Savchenko (DB Developer), Oleksii Svitlychnyi (Technical writer)
Introduction to the 12-step Migration and Modernization Methodology

At ABCloudz, we know that a successful migration or modernization project relies on a solid foundation and a well-defined approach. Our approach is encapsulated in the 12-step Migration and Modernization Methodology, which we’ve developed and refined over 20 years of practice. It has proven so effective that it was adopted by AWS to guide their cloud migration best practices.To illustrate this methodology in detail, we’ve created a series of four blog posts, each covering a critical phase of the migration […]

Adam Robertson
Migration Solution Document Capturing the Project Roadmap — Part 4

Welcome to the fourth and final blog post in the overview series dedicated to our 12-step Migration and Modernization Methodology that was adopted by AWS. We started by defining workloads and examining their interdependencies, which set the stage for capturing the current architecture and designing the future state architecture as part of the first step of the methodology — Future State Architecture Design. Next, we focused on gathering and analyzing project artifacts to inform a detailed effort estimation and project […]

Adam Robertson
Analyzing Migration Project Efforts and Crafting the Project Plan — Part 3

Welcome to the third blog post in the overview series dedicated to our 12-step Migration and Modernization Methodology that was adopted by AWS. In our first and second blog posts, we explored the critical role of defining workloads in migration projects and laid out the process of capturing the current architecture and designing the future state architecture as part of the first step of the methodology — Future State Architecture Design.This provided a solid foundation for understanding the scope and […]

Adam Robertson
Current and Future State Architectures — Part 2

Welcome to the second blog post in the overview series dedicated to our 12-step Migration and Modernization Methodology that was adopted by AWS. In the first blog post, we began exploring the first step of the methodology — Future State Architecture Design.We focused on the definition of a workload and outlined how categorizing system components into specific workloads provides a solid foundation for the entire project. However, workload definition is just one part of the broader Future State Architecture Design […]

Adam Robertson
Workload Definition Shapes the Migration & Modernization Roadmap — Part 1

Welcome to the first blog post in the overview series dedicated to our 12-step Migration and Modernization Methodology that was adopted by AWS. In any migration or modernization project, it’s crucial to start with a clear understanding of the system’s components and their relationships. This is where workload definition comes into play. Defining workloads correctly sets the stage for the entire project, making it possible to scope, assess, and plan each step with precision. Workload definition is one of the […]

Adam Robertson
Migrating from Oracle to SQL Server for a food manufacturing company

ABCloudz recently helped The Morning Star Company, one of the world’s largest producers of tomato products, migrate their Oracle database to SQL Server. The Morning Star Company operates three processing facilities in California, handling nearly 10% of the global tomato production. Their IT infrastructure included both Oracle and SQL Server databases, but due to the high cost of Oracle licenses, the company decided to gradually retire their Oracle servers and migrate to SQL Server. They reached out to ABCloudz for […]

Oleksii Savchenko (DB Developer), Oleksii Svitlychnyi (Technical writer)

Ready to start the conversation?

ABCloudz emerged from the world of data and established itself as a go-to partner for any IT needs. Our professionals are ready to help. Drop us a line today!

Hi there! How can I help you?

ABCAssist