Start with what you know
Use T-SQL queries, including nested queries and subqueries, or define sources and transformations interactively.
THE ETLGEN PRODUCT
From requirements
to integration.
Use familiar SQL and structured specifications to generate artifacts for Azure Data Factory and SQL Server Integration Services.
02 — FEATURED PRODUCT
Meet ETLGen.
INPUTSQL query
SELECT customer_id,
SUM(order_total)
FROM orders
GROUP BY customer_id;→ETLGen translates
your logic
your logic
OUTPUT 01ADF Data Flow
Sources · joins
derived columns · sink
OUTPUT 02SSIS package
Native package
ready for your project
From SQL to your
next data pipeline.
Turn T-SQL queries or ETL specifications into Azure Data Factory pipelines and data flows, SSIS packages, table DDL scripts, and Excel specifications.
Bring your existing SQL knowledge. ETLGen helps handle the repetitive translation from requirements to implementation.
Generate the artifacts you need
Create ADF pipelines and data flows or SSIS packages, alongside table scripts and ETL specifications.
Keep control of your work
Use the generated ADF artifacts, SSIS packages, and Excel specifications independently of ETLGen.
READY TO TRY ETLGEN?
Download ETLGen ↗Download ETLGen and start building.
Get the application, licensing information, and the latest product access details from the ETLGen download page.
A CLEAR PATH FROM IDEA TO IMPLEMENTATION
Define it once.
Move the work forward.
Describe your transformation
Start with a SQL query or build an ETL specification using sources such as flat files, tables, views, functions, and stored procedures.
Generate your integration
Translate your requirements into ADF or SSIS artifacts and the supporting scripts and specifications.
Make it part of your workflow
Review the generated outputs and continue working with them in your existing data development environment.
EXPLORE FURTHER
Start with the details.
Find product guidance and answers to common questions.