Project Information
Country
United State
Industry
Organization Size
Solution Area
Products & Services
• Azure SQL Datawarehouse
• Azure Data Factory
• Azure Automation
• VPN Gateway
About Company
A USA based agency which implements Central Repository of Integrated data for one or more disparate sources for state government administrative agency. They are the trusted insurance provider among US. They help design and implement insurance program which can help there customers to choose among various insurance programs.
Project Summary
Client had multiple production databases on-premise which they require to move to Azure Datawarehouse, in that way they can build there daily reports on the live data using the Alteryx designer tool, since they had vast number of transactions happening on the on-premise they needed a source that can handle these transactions on daily basis, and can be performant in order to build various production related reports.
Challenge
The challenge was to schedule a daily movement of data from on-premise to Azure SQL Datawarehouse so that all transactions remains at the destination and completely sync. They have 5 databases of size of at least 400gb each. They also need an automation process to start and pause Azure SQL Datawarehouse. Analysis of 5 database with 300 tables each and provide them migration plan was set to be completed in 10 working days.
Solution
We assigned a group of Azure Experts and did deep analysis, understand the environment and requirements. We used Azure Data Factory v1 to connect to on premise database, we used another windows server at the same network to install data gateway in order to solve connection issues. Building incremental load pipelines to move data daily according to dates. Building json scripts to move the data daily as an incremental copy.
Automated Azure Datawarehouse using automation account to start/stop at certain. Our team completed the challenge in 5 working days, which consisted out designing a flow using .JSON scripts and schedule the pipelines that needed to be run daily.
Connect with IFI Tech
Related Projects
Yuze Digital India modernizes fintech platform with Azure Kubernetes Service (AKS)
Project Information Country India Industry Financial Services Organization Size 51–200 Employees Solution Area Cloud Modernization & Containerization (AKS) Products & Services • Azure Kubernetes Service
ConnectPay rehosts its Windows Server-based payment platform on Azure, improving global traffic management and security
Project Information Country United States Industry Financial Services Organization Size 51–200 Employees Solution Area Windows Server Migration and Infrastructure Modernization Products & Services • Microsoft
Accelerating Financial Analytics with Azure Synapse at Nuvama Wealth
Project Information Country India Industry Financial Services Organization Size 1000+ Employees Solution Area Data Products & Services • Power BI• Azure Synapse Analytics About Company
Insights
IFI Techsolutions Renews Microsoft Azure Expert MSP Status for 2026
IFI Techsolutions has renewed its Microsoft Azure Expert Managed Service Provider (AEMSP) status for the fourth consecutive year. The designation was first achieved in 2023,
The 8 Benefits of Working with an Azure Expert Managed Services Provider
Launching virtual machines and moving workloads to the cloud is only one part of working with Azure. The real challenge starts after that. Managing cloud
Unlock Your Azure Cloud Potential with the Right Azure Managed Services Partner
As businesses continue to digitize their operations, the demand for reliable and scalable computing environments has increased. Teams are expected to deliver faster, maintain performance,