| There are several ETL tools present in the market | | | | performance |
| from open source to java based. If you are evaluating | | | | - Enforce data validation rules by specifying them in |
| the etl tool, you obviously first must compare the | | | | processes |
| decision to purchase an ETL tool against currently | | | | - Document and formalize data flows and mapping |
| used process for data management. Very few IT | | | | rules |
| departments are able to convene the current and | | | | - What are the logging features, and check the loads |
| future development needs of the business users | | | | and handle error conditions? |
| without extensive growth. One way to compensate | | | | A ETL customers should turn up at a logical conclusion |
| the requirement for additional headcount is to improve | | | | about which ETL softwarewill best meet their |
| the effectiveness that modern ETL tools if chosen | | | | requirements and should definitely try to obtain a |
| and employed efficiently. | | | | customer reference from each ETL vendor, |
| There are some steps which we need to follow | | | | preferably another company doing approximately the |
| before purchasing ETL Tools are: | | | | same functions as your organization. A customer |
| - List the operating systems on which the ETL Tool | | | | should focus on the key technical needs to make sure |
| supporting | | | | that the customer reference you get is appropriate |
| - How much amount of data (in GB) in certain period | | | | and helpful for evaluation process. |
| the tool processing?. | | | | Once the customer has completed the evaluation he |
| - Check the connectivity with type of data sources the | | | | would generally request the top two or three ETL |
| ETL tool having. | | | | vendors in to execute a proof-of-concept process. |
| - Check the data format that you have requested | | | | This would permit him to compare the products in his |
| whether it is Text or CSV, XML, any Databases (such | | | | own environment with his own data and business. |
| as Oracle, MySQL, SQL Suite, DB2, Sybase), EDI, | | | | Customer can make their final decision based on the |
| HIPAA, ACORD AL3, any Fixed-Length file format, or | | | | finding according to exercise and select the product |
| any other format | | | | that is best fit for him. |
| - Select the web based ETL Tools for better | | | | |