Data Integration

The information you need to understand your customers, drive your business and make decisions is likely already in your possession. But if you’re like many companies, this information is stored in disparate systems, using inconsistent formats, making it hard to get the answers you need. I can help you overcome these obstacles to ensure that your decisions are made with the most accurate, complete and up-to-date information.

How it Works: Extract, Transform, and Load (ETL)

ETL is the basic methodology behind any data integration process. In the extraction phase, information is retrieved from a variety of sources, such as internal databases or the internet. Next, each piece of data is transformed to into a consistent format, so that it can be analyzed for accuracy and completeness. The information from different data sources is compared, and business rules are applied to determine which is authoritative. Once an up-to-date data set has been created, this result is loaded into your business data sources, ensuring up-to-date information across your business.

Flexible, Open Source Data Integration

Small businesses and organizations thrive by keeping costs low. By specializing in open source ETL solutions, we can help you manage costs while you manage your information. With experience designing integration solutions using the Jitterbit and Pentaho platforms, as well as writing custom code, I can keep your costs to a minimum, while maximizing flexibility and maintainability.