One of the largest North American agricultural enterprises has been envisioning and designing a new cloud-based Business Intelligence and Data Warehousing architecture. They were using...
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 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 an 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 the 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 store, we would use a combination of Polybase with partition switching to optimize the data load into the large fact tables on Azure Synapse Analytics.
At DB Best, 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.
For qualified Microsoft customers, we have access to Microsoft Business Incentive Funds where Microsoft will co-invest for training, future-state architectural design engagements, and proof-of-concept projects.
This engagement allows you to integrate existing relational data sources with new big data sets using your team’s existing skills.
Are you looking to stay ahead of the competition by using Azure? Our full day Azure data platform readiness training can jump start your team to better understand what is possible.
Everyone is talking about the need for a digital transformation, but how do you get there? See how our future-state architecture design can use cutting edge technology to meet your organization’s needs.
Building an Ultimate Cloud-based Business Intelligence Solution for Agriculture
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. In addition, we prototyped as part the proof of concept migrated 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.
We have a great set of blog posts and data sheets to help you better understand our capabilities as the leader in database migration services and prove out possibilities and expertise in moving Oracle data warehouses to Microsoft Azure cloud platform.
Our customer has been supporting Oracle based online transaction processing (OLTP) system. They decided to take advantage of the modern data analysis capabilities of SQL Server's data ...
This white paper explores challenges that arise when you migrate from an Oracle 7.3 database or later to SQL Server 2014. It describes the implementation differences of database objec...