Learn more about
ETL
database-migration, SaaS, Data-warehouse, data-lake, ETL, application-modernization, aws, Oracle to PostgreSQL migration, cloud-migration, PostgreSQL, Oracle, Improving the performance, AWS Batch, Amazon S3
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 […]
Oleksii Savchenko (DB Developer), Oleksii Svitlychnyi (Technical writer)
operational-data-management, database monitoring, security, SQL Server, cost-optimization, SharePoint, ETL, health check, Azure SQL Database, azure
Operational Data Management for a Global Biotech Leader
Our client, a global biotech company with a presence in over 80 countries and a workforce of 4,000 employees, depends on a complex IT environment that includes both on-premises and cloud-based components. This infrastructure supports everything from research and development to manufacturing and corporate operations, with SQL Server playing a pivotal role across various environments. […]
Sergii Zymbytskyi, Oleksii Svitlychnyi
Databricks, azure, big-data, Data-warehouse, Data-platform, cloud-migration, Business-intelligence, SQL Server, Microsoft Azure, Azure-DevOps, Azure-Data-Factory, ETL, Oracle
EDW to Azure Databricks Migration
ABCloudz recently completed a significant project migrating an Enterprise Data Warehouse (EDW) from an on-premises SQL Server 2014 to Azure Databricks for a leading global retailer operating 3,000 offline stores across 40 countries. This migration was essential for addressing physical server limitations and outdated technology that hindered data processing and storage capabilities. Embracing Big Data […]
Sergey Shtypuliak (DB Engineer), Oleksii Svitlychnyi (Technical writer)
Unleashing the power of data integration: a head-to-head comparison of AWS Glue vs. Azure Data Factory
Nowadays, it’s hard to imagine effective Business Intelligence without ETL (extract, transfer, and load) tools. These tools help you integrate data from multiple sources into a single database environment. Instead of keeping data in silos, you get an efficient and consistent data warehousing method where all data brings you value, regardless of its format and […]
Oleksandr Smolovyk, Mykhailo Ievsieiev
Expand capacity with an IBM DB2 SQL Azure SQL Database migration
One of the world’s largest distributors of non-food consumable products wanted to rationalize their data platform and business intelligence strategy. Their current IBM DB2 database system lacked a repository to host historical audit-related data, so they could hardly retrieve data from past years. Then we came up with an Azure cloud database solution that could […]
Andrii Koval