Client Stories
We help our clients succeed.
Materials
Customer – Manufacture of steel products
Industry – Materials
Customer Situation – On premises SQL Server 2012 analytics infrastructure was due for an upgrade of both software and hardware to ensure continued vendor support and ensure business continuity.
Technical Solution
- Replicated hardware infrastructure on Azure IaaS.
- Upgraded databases from SQL Server 2012 to SQL Server 2019.
- Provisioned Azure Synapse Analytics as the final destination of all existing workloads to enable a phased transfer of capability.
Products and Services
- SQL Server 2019
- Azure SQL Server VMs
- Azure Synapse Analytics
Benefits
- Ability to provide business users with improved query performance versus on-premises infrastructure.
- Ability to onboard new IoT related workloads that were not possible on existing ageing infrastructure.
- Freed up IT resources by shifting the onus of business continuity to the Cloud provider.
- Enabled the analytics team to gradually move new and existing workloads to a PaaS platform so they could support the new environment organically.
Industrials
Customer – Provider of engineering services
Industry – Industrials
Customer Situation – A strategic direction towards moving IT infrastructure to the Azure Cloud was embarked upon after a detailed and holistic business analysis. Their data integration platform was one of the early candidates for migration.
Technical Solution
Refactored iWay integration server data pipelines to Azure Data Factory, specifically:
- Migrated iWay packages to SSIS run time in Azure Data Factory.
- Leveraged Data Migration Assistant to deliver performance and reliability improvements in schema, data, and uncontained objects from the source to the target server.
Products and Services
- Azure Data Factory
- SQL Managed Instance
Benefits
- Compute characteristics of the workload matched in the infrastructure for better economics.
- Migration to platform services enabled lowered operational costs from negating server management and built in business continuity.
Consumer Staples
Customer – Provider of food products
Industry – Consumer Staples
Customer Situation – The legacy analytics platform build on Oracle database and data engineering products was due for modernization because it was unable to meet the business intelligence demands of the organization – from both a scale and turnaround perspective.
Technical Solution
- DSI provisioned an Azure Data Lake to ingest, prepare, transform, enrich, and curate data made available by source systems data providers via Rest API end points.
- These data were then warehoused in Azure SQL Managed Instance (SQLMI) in a format conducive to data consumption and virtualization.
Products and Services
- Azure Data Lake
- Azure SQL Managed Instance
Benefits
- Reduced data duplication and simplified integration for improved data quality and near real-time reporting. This was critical to manage inventory levels.
- Enabled self-service information access via more user friendly and business centric table schemas.