SQL Database for r-pac, a Leading Global Merchandiser

Project Information

Country

United State

Industry

Manufacturing

Organization Size

1000+ employees

Solution Area

Data & AI

Products & Services

• Not defined

Project Summary

Client was looking for Disaster Recovery and robust solution for SAP workload at on premises DC, wanted to move to enterprise grade datacenter with secured and compliance as per industry standards. SAP being critical workload , wanted to host on scalable and available solution with Disaster recovery for Business continuity plan. R-PAC has a SQL database on VM which consists of around fifty databases. The requirement was to build a data warehouse and plan a scalable architecture for analytics.

Challenge

R-PAC has Multiple Websites which has the SQL database on VM as the backend. It has been observed that the data volume is increasing over time in tables which impacts the query speed and performance of Websites. Large Data volume of historical without any archival mechanism is a challenge.

Solution

IFI Techsolutions provided a solution to build a data lake over the historical data and keep live transaction data in SQL for up to 1year. The archival of historical data will overcome the data volume challenge in SQL databases on VM. Also, the historical data will be used as a source for our Power Bi to build insights for Analytics.

Business Benefits

Improved performance of SQL SERVER that reduce the downtime of Websites
The reduction in cost of On-premises SQL database.
Build insights and create reports on Historical data to make key decisions in business.
Provide Historical data to customers based on Ad hoc requirements.

Connect with IFI Tech

Related Projects

Web Application Modernization for a Dynamic Production company Based in INDIA

Custom Managed Services Intermiles

Project Information Country India Industry Travel & Tourism Organization Size 250+ Employees Solution Area Hybrid Cloud, O365, IT infra Support Products & Services • Not

Web Application Modernization for a Dynamic Production company Based in INDIA

Project Information Country India Industry Motion Pictures & Films Organization Size Small (50-100 Employees) Solution Area Web Application Modernization Products & Services • Azure Frontdoor•

Migrate On-Premises Workload on Azure

Project Information Country United State Industry Energy & Resources Organization Size 1000+ employees Solution Area Infrastructure Products & Services • Azure Virtual Machines• Azure Backup•