ETLGEN / USER GUIDE

Configure ETLGen settings

Connect the application to its metadata store and define a predictable output workspace.

What ETLGen stores

ETLGen uses SQL Server tables in the ETLGEN schema to store specifications and connections. Generated files remain in the output folder you choose.

Connection settings

Enter the SQL Server instance, database, and authentication method supplied by your administrator. Windows Authentication and SQL Server Authentication are supported.

Security note

Connection details are encrypted and stored on the local computer. ETLGen does not send these settings to SSR Software Design.

Output folder

Choose a local or shared folder where generated artifacts can be reviewed by your team. ETLGen creates these folders as needed:

ADF Scripts — Azure Data Factory definitions.
Configuration files — SSIS configuration assets.
DDL Scripts — table creation scripts.
Log files — generation and validation logs.
Specification Document files — Excel specifications.
SSIS Packages — generated packages and templates.

Save and validate

Select Save. If the ETLGEN tables do not exist, ETLGen places ETLGEN_CreateTableScript in the DDL Scripts folder so an administrator can run it. Return to Settings from the Home menu when the workspace needs to change.