Informatica
440 Case Studies
A Informatica Case Study
Capitol Lighting, a family-owned omnichannel retailer with eight showrooms and e-commerce sites (1800lighting.com and Capitol Lighting Pro), struggled with siloed systems — ERP, PIM, Salesforce Commerce Cloud and marketing tools — that forced teams to reconcile data in spreadsheets and could delay new-product listings up to four weeks. Decision-makers lacked a single, trusted view of performance, and manual reporting made it hard to measure marketing ROI accurately.
By deploying Informatica Intelligent Cloud Services (Cloud Data and Application Integration) to connect on-premises and cloud systems into a central SQL Server warehouse and Tableau dashboards, Capitol Lighting automated data flows and eliminated manual reconciliation. The integration created real-time, trusted reporting for executives and marketers, reduced manual data entry, and pushed product information directly into Salesforce Commerce Cloud so new SKUs appear in days rather than weeks — up to 5x faster time to market, says Fayaz Shaikh, Director of Data at Capitol Lighting.
Fayaz Shaikh
Director of Data