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
Secure and Scalable Azure Virtual Desktop Implementation for RevHC
Project Information Country United States Industry Healthcare Technology Organization Size Enterprise Solution Area Virtual Desktop Infrastructure (VDI) on Microsoft Azure Products
Unified Hospitality Operations with Microsoft Dynamics 365 Business Central
Project Information Country India Industry Hospitality Organization Size 51–200 Employees Solution Area Finance and Operational management Products & Services • Microsoft Dynamics 365 Business Central
Yuze Digital Bank Strengthened Cloud Resilience with Microsoft Azure Disaster Recovery
Project Information Country UAE Industry FinTech Organization Size Digital banking platform serving customers across the UAE region Solution Area Cloud Infrastructure Disaster
Insights
How to Migrate from Azure Pay-As-You-Go to CSP: A Complete Guide for Businesses
Are you using Azure? Still managing your billing directly? As your cloud use grows, understanding bills, controlling costs, managing subscriptions, and finding the right support
Microsoft Copilot for Business: 30-Day Free Trial and Exclusive FY27 Offers for SMBs
Microsoft’s new Copilot in 30 initiative and FY27 Copilot promotions give SMBs a faster, lower-risk path to AI adoption. IFI Techsolutions helps organizations evaluate, deploy,
How Microsoft AI Is Reshaping Modern Enterprises
AI is no longer just an idea that businesses are testing. In 2026, it is becoming a central part of how enterprises operate, helping employees