ETLGEN FAQ
A little clarity.
A better start.
Answers to common questions about ETLGen and its SQL-driven integration workflow.
What is ETLGen?
ETLGen is a data integration automation tool, formerly known as SSISGen. It generates integration artifacts from T-SQL queries or ETL specifications.
What can ETLGen generate?
The product website describes Azure Data Factory pipelines and data flows, SSIS packages, table DDL scripts, and Excel ETL specification documents.
Do I need to learn a new programming language?
ETLGen is designed around existing SQL knowledge. You can start from T-SQL or define sources and transformations through the interactive specification workflow.
Can I work with more than database tables?
The documented source types include flat files, tables, views, functions, and stored procedures. Check the product documentation for configuration details relevant to your environment.
Can I keep using generated outputs without ETLGen?
Yes. The existing product documentation states that generated ADF artifacts, SSIS packages, and Excel ETL specifications can be used independently of ETLGen.
Does ETLGen support complex SQL?
The product website describes support for nested queries and subqueries. Validate your particular transformations and generated outputs in your development environment.
Where can I find pricing, licensing, and system requirements?
Consult the existing ETLGen download page and product documentation for available information. Check those resources for the details that apply to your release.