Project Information
Country
United State
Industry
Organization Size
Solution Area
Microsoft Technologies
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

How IFI Techsolutions Helped Value Design Migrate to a New Azure Tenant with Built-In Disaster Recovery
Project Information Country Japan/India Industry Financial services and financial technology Organization Size 100 to 200 Solution Area Azure infrastructure migration and disaster recovery Project

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 Microsoft Technologies Microsoft Dynamics 365 Business

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

IFI Tech Service Bulletin: Microsoft 365 Issue
What is happening Microsoft has reported an issue affecting Microsoft 365 services today. Some users may see delays or failures with email (Outlook), Teams and

Azure FinOps: How to Improve Cloud Cost Control and Business Value
It’s not easy to keep track of all your spending when cloud costs are growing quickly and make sure that your spending is providing real

Microsoft Defender for Cloud: A Complete Guide to Cloud Security and Posture Management
As an organization’s Azure environment grows, its security responsibilities become more connected. An application team may manage deployments, a platform team may control network settings,

