Join ETL Solutions at the 17th international conference on Petroleum Data Integration, Data and Information Management, where we will be showcasing our practical, efficient data management products and services. The event, which is organised by Petroleum Network Education Conferences, takes place in Houston on 14-16 May. We will be conducting live demos of our E&P ...

In last week’s blog post (click here to read) we assessed the challenges of migrating diverse Oil & Gas data to corporate data stores.  This week, we will explain the metadata-driven method we use to support the migration of legacy databases to our clients’ standards. Our Transformation Manager migration tool is used in a once-only ...

Many companies are today engaged in the standardization of the data they hold in corporate data stores. In the Oil & Gas sector, a great variety of data stores are used, such as OpenWorks, Corporate Data Store, Seabed, Finder and PPDM. In this post we will take a look at the challenges of migrating this ...

The global nature of the automotive industry means that data often has to be integrated across different markets and diverse Dealership Management Systems (DMS).  This case study illustrates how we extract data from different systems, creating seamless integration of all the different formats. The challenge Snap-on Business Solutions’ Prism product provides sophisticated analysis and reporting ...

The latest release of Transformation Manager, a robust data integration toolkit for developers, is launched today. Transformation Manager is a software suite capable of tackling even the most complex data movement projects.  With a ten-year track record in data movement, Transformation Manager is used by some of the world’s largest companies to manage their data. ...

Our data migration service uses a clear process to mitigate risk and maximise the opportunity for project success.  This process has been applied by our consultants to deliver migrations of even the most complex data. Stage 1: Configuration At the start of any data migration, our consultants carry out a structural configuration to ensure that ...

Big Data, which is data so large and complicated that it is hard to process using traditional applications, has exploded into ever more complex data sets. But how big are these data sets? This week we found a great infographic by American Internet Services (click here to view its source), which estimates that 2.5 quintillion ...

ETL Solutions attended the first Standards Leadership Council Meeting at London Heathrow on 26 February 2013.  The aim of the meeting was to build on the launch of the Council by assessing the work carried out so far by its members and its plans for the future. Ten potential projects were identified by the meeting, ...

In software development, a proof of concept can be a vital tool to demonstrate the software’s capabilities and its fit with the client’s requirements.  But how do you go about creating one?  A recent example from our data integration work in the Oil & Gas industry illustrates the steps we take to create a successful ...

The Challenge The client is a global oilfield services company with a long track record in the Oil & Gas industry.  To maintain their position as the leader in the sector, the client’s new product development plan included a Professional Petroleum Data Model (PPDM) based software product.  The product required a data integration framework capable ...