ETL Software Business Requirements

ETL software extracts data from source systems, transforms it, and loads it into warehouses, lakes and applications on a schedule or continuously. Data engineering teams and IT departments buy it to replace hand-written scripts with pipelines they can schedule, monitor and audit.

110 requirements for choosing ETL and data integration software, each written so a vendor can answer it and you can check the answer. Delivered as an Excel workbook.

Inside the Workbook

• 80 functional requirements in 9 areas, each with how to verify it
• 30 non-functional requirements written for this category
• Suggested priorities (41 Must) that you change, with weights that follow
• A vendor response form with six response types, from Standard to Not supported
• 6 scripted demo scenarios, each mapped to the requirements it tests
• A weighted scorecard for up to five vendors, by area, with Must gaps counted

Functional Areas

• Connectivity (9)
• Extraction and change capture (9)
• Transformation (15)
• Data quality (8)
• Loading (6)
• Orchestration and scheduling (9)
• Monitoring and error handling (7)
• Development and deployment (9)
• Metadata, lineage and access (8)

Deeper Vendor Due Diligence

Security, privacy, contract and exit questions are in the RFP question bank: Integration & interoperability, Security, Data protection & privacy, Deployment & hosting, Business continuity & disaster recovery, Migration & exit.

Built For

IT, business and procurement teams writing requirements before a software selection, and consultancies running one for a client. The Consultancy License covers use with any number of clients.