Case Study: International Association of Ironworkers achieves reliable 2.5M-record Salesforce data sync with Pumex Computing

International Association of Ironworkers - Customer Case Study

The International Association of Ironworkers, a union with 120,000 members, needed to synchronize 2.5 million records from flawed legacy systems to Salesforce and its IMPACT forum after a costly Heroku implementation failed. Their data had numerous integrity issues and the sync required maintaining complex relationships. The union engaged Pumex Computing for a custom software development and data integration solution.

Pumex implemented a .NET Core ETL application and an MSSQL Server intermediary database to cleanse and synchronize data every ten minutes, utilizing Salesforce APIs. This solution successfully synced all records with an error rate of just .0008% and ensured data integrity for updates and deletes. Pumex also architected a future "Gold Source DB," projecting a 40% reduction in the customer's operational data management costs over three years.

International Association of Ironworkers