ETL Tool Evaluation

Rating items		Evaluation Result	Remarks
Supported platforms	Sun Solaris, HP-UX, ibm aix, AS/400, OS/390, SCO UNIX, Linux, Windows
Supported data sources	DB2, Informix, Oracle, Sybase, SQL Server, teredata, oledb, SAS, text, Excel, SAP, PeopleSoft, IMs, VSAM, qsam on 390, FTP, XML, messagequeue, Weblog
Data Conversion	Field ing
	Automatic ing matching
	Field splitting
	Multi-field Hybrid Operation
	Cross-heterogeneous database Association
	Custom Functions
	Support for Multiple Data Types
	Complex Condition Filtering
	Batch Data Loading
	Time type conversion
	Can environment variables be dynamically modified?
	Record deduplication
	Extract breakpoint
	Merge or calculate records
	Record splitting
	Can the extracted fields be dynamically modified?
	Transform rows and columns
	Sort
	Statistics
	Commonly used conversion functions such as scale
	Generation of proxy primary keys
	Debugging Functions
	Extract Remote Data
	Processing Method of incremental Extraction
	Manufacturing sample data
	Whether the data comparison function is supported during the conversion process
	Data Preview
	Data cleaning and standardization
	Group and aggregate by row or column
Integration and release	Integration with OLAP
	Integration with front-end tools
	Integration with modeling tools
	Whether various external applications can be called (including stored procedures and applications developed in various popular languages)
	Whether custom conversion process is supported
	Support integration with statistical analysis tools
Manage metadata (Data Source Definition, ing rules, conversion rules, loading policies, etc)	Openness of metadata Storage
	Portability of metadata Storage
	Provides multiple methods to access metadata
	Metadata Version Control
	Supports open metadata standards
	Supports XML for metadata exchange
	Support distributed metadata access and management
	Generate a metadata report
	Metadata-Based Query
	Broadcast and reuse of metadata
Management and scheduling Functions	Performance monitoring
	Backup and recovery during extraction
	Upgrade
	Version Management
	Development and release
	Supports unified and custom management platforms
	Supported time trigger Methods
	Event triggering
	Supports command line execution
	Allows you to manage and allocate computer resources.
	Server Load balancer
	Automatic Document generation
	Can other tasks be executed during scheduling?

ETL Tool Evaluation