Blog

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 warehouse features including columnstore for greater value over an Oracle based data warehouse solution. We came up with a comprehensive solution on extracting and transforming their source data and loading it into the target database. As a result, our customer benefited from obtaining a highly standardized and easily manageable solution within a short […]

We’re excited to bring you the latest release of Database Compare Suite. The new version 4.9 features support for Microsoft Azure Synapse Analytics along with some other improvements. Covering 12 Major Database Platforms With the support of Microsoft Azure Synapse Analytics (previously Azure SQL Data Warehouse), the total count of available database platforms in the Database Compare Suite reached the total of 12. This dozen includes 5 specific data warehouse platforms. So, you can keep humongous data under control with […]

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 a fragmented system, based on Oracle database, while the reports were presented as a mix of SQL Server Reporting Services (SSRS) and Excel dashboards. We came up with a solution that allowed to consolidate all reports with Power BI dashboards. In addition, we proposed to migrate the original database to Azure Synapse Analytics (previously Azure […]