A quick guide for choosing an ETL tool - OPIN Systems

3 downloads 244 Views 1MB Size Report
There isn't a single ETL tool that would work for every company. Before ... Consistent data with few, if any, schema cha
Build, buy, or customize:

A quick guide for choosing an ETL tool There isn’t a single ETL tool that would work for every company. Before you start comparing vendors, you’ll need to decide whether you’ll build, buy, or customize your ETL tool.

Build if you have . . . A single data stream that your IT team could easily map in a short span of time A small budget A reliable, permanent IT team Consistent data with few, if any, schema changes

Buy if you have . . . Data streams similar to other companies Frequent schema changes and unstable endpoints Multiple data streams you’ll want to integrate at a later date (scalability) A small IT team and/or non-technical end users

Customize if you have . . . Complex data streams that a commercial off-the-shelf software (COTS) couldn’t handle Big data and the IT team to match A COTS ETL tool that hasn’t been cutting it

www.opin.com | [email protected] | 952.567.2444 Copyright ® 2016 OPIN Systems, Inc. | 7900 International Drive Suite 410, Bloomington, MN 55425