Data Warehouse Migration to Microsoft DW Technologies

Are you concerned about the future of your Oracle, Teradata, Netezza, Vertica, and Greenplum solutions? Let us showcase our expertise in helping you perform a data warehouse migration to Azure Synapse Analytics.

Typical challenges that we see

The most common challenge that we experience with data warehouse migrations to the Azure cloud is evaluating Azure Synapse Analytics with enough data.

Proof-of-concept (POC) projects often don’t include enough data to show off the performance of Azure Synapse Analytics

Microsoft designed Azure Synapse Analytics (previously Azure SQL Data Warehouse) for unlimited scale using a massively parallel computer (MPP) architecture. If the existing Oracle Data Warehouse solution uses a large server using a symmetric multiprocessor (SMP) under 10 terabytes of data, performance using Azure Synapse Analytics may produce disappointing results.

We recommend POC projects with Azure Synapse Analytics using a set of tables that are more than 10 terabytes to showcase performance against huge sets of data.

In order to migrate the data to Azure Synapse Analytics, we can utilize several methods for migrating data from on-premises Oracle Data Warehouse tables to Azure Synapse Analytics including:

  • Using parallel servers to export tables as CSV files share and then upload them to Azure storage over Azure ExpressRoute.
  • Taking a similar approach but transferring data to internal SATA HDDs or SSDs and then shipping them to an Azure data center using the Microsoft Azure Import/Export service.

Once the data is in Azure Blob Storage, we would use a combination of Polybase with partition switching to optimize the data load into the large fact tables on Azure Synapse Analytics.

Getting started

At ABCloudZ, we have a set of entry-level offers to help you understand your modernization landscape and demonstrate the value of moving your Oracle data warehouses to Azure Synapse Analytics.

We can help you choose the best option to migrate Oracle DW to Azure Synapse Analytics, modifying the architecture of your entire system to add the latest business intelligence and advanced analytics solutions. We can also work with your team to deliver future-state architectural design engagements or proof-of-concept projects.

Building an ultimate cloud-based business intelligence solution

One of the largest North American agricultural enterprises was considering a new cloud-based Business Intelligence and Data Warehousing architecture. They were using a fragmented system based on Oracle database with reports using a mix of SQL Server Reporting Services (SSRS) and Excel dashboards.

We came up with a solution that allowed them to consolidate all reports with Power BI dashboards. Besides, we prototyped as part of the proof of concept the migration of the original Oracle database to Azure Synapse Analytics. The end result is a proposal that will reduce their license costs and improve the performance of the newly created cloud database system.

Check out our video below to see how we approached this proof of concept solution.