BY PRAGMATIC WORKS
An independent oil and gas company, focused on the acquisition, exploitation, development and production of oil and gas properties, was struggling with
platform architecture for their growing data volumes. Business data is used to optimize oil production costs,
which translates into greater margins and increased proﬁtability. ETL processes had slowed considerably, which hindered the ability to fully utilize data.
With the current data volume, a number of issues were causing concern, including SQL Server Analysis Services processing running longer than expected; SQL Server Integration Services executing longer than expected;
and exception handling and logging not consistently applied to SSIS packages. Expected data growth and acquisitions would soon be causing bottlenecks with both manpower and computing capabilities.