Data Integrity Institute Inc. provides on site ETL seminars, ETL tool selection, ETL platform selection, ETL project review, ETL performance estimation, ETL obstacle and bottleneck identification, ETL best practice review and staff training.

Independent on site ETL seminars can make any ETL project feasible and significantly save on implementation time and money. All major ETL tool vendors agree that the early identification of risks and bottlenecks is crucial. Not following such best practices is the leading cause of ETL project failure.

Data Integrity Institute Inc.'s on site seminars will identify and provide:

ETL tool selection

• what is the optimal ETL tool for the required ETL tasks
• the fit of ETL tool for the business requirements
• the fit of ETL tool for the data vault size
• the fit of ETL tool for the required data mapping complexity
• the fit of ETL tool for the selected ETL platform
• the fit of ETL tool for available development resources
• overall ETL performance (records per minute, records per $)
• is the already selected ETL tool an optimal choice
• is eventually already selected ETL tool a feasible choice
• will the already selected ETL tool be able to perform in the long run
• the already selected ETL tool's ability to reuse (pooling) recourse consuming (expensive) database objects (connections, SQL statements)
• does the selected ETL tool protect corporate data
• capability of underlying internal SQL engine in major ETL tools for massive data vault comparison sorting
• capability of underlying internal SQL engine in major ETL tools for massive data vault B-Tree indexing

ETL platform selection

• what ETL platform (hardware, CPU, memory, storage, external network, internal network, operating system, database engine, middleware, development tools) is optimal for required ETL tasks
• is the already selected ETL platform an optimal choice
• is the already selected ETL platform a feasible choice
• will the already selected ETL platform be able to perform in the long run
• does the selected ETL platform protect corporate data
• what should be installed on an ETL platform
• what should not be installed on an ETL platform

ETL best practice review

• what ETL best practice will be optimal for required ETL tasks
• is the already selected ETL best practice (recommended by major ETL tool or by major integrator) an optimal choice or a risky trap
• whole record set (table level) vs. single record set (row level) ETL processing
• impedance matching (ETL overheating) by 'M' to 'N' mapping
• database recourse (connection, SQL statements) pooling
• lookup (desktop database stile lookup) trap
• data validation, data quality, and data cleansing
• metadata management
• documentation
• knowledge transfer, coaching, training
• production data, development data, testing data

ETL project review

• business requirements review
• project resources (executive level, management level, business analysts, technical leads, developers, quality control, implementation, maintenance and support, knowledge transfer)
• project timeline (business specifications, metadata specification, mappings specification, production platform setup, development platform setup, testing platform setup, learning curve, development, implementation, testing, maintenance)
• project budget and hidden costs (ETL platform, ETL tool, enriched (parallel) ETL tool version, additional plug-ins, dependent tools, licensing, support and maintenance, human resources, on site training and coaching, external resources)
• change request, support and maintenance

ETL security review

• data overexposure protection
• production environment, development environment, staging environment, testing environment
• staging data risk
• forgotten staging data risk
• production resource access
• development resource access
• implementation resource access
• testing resource access
• maintenance and support resource access

Contact Data Integrity Institute Inc.

For further information on how Data Integrity Institute Inc. can help you to implement, save or maintain an ETL project, please send a detailed inquiry to: info@DataIntegrityInstitute.com , or call (416) 282-2298