ETL Import

Go Up to ETL

When using the MetaWizard Import in tandem with a Data Lineage for an ER/Studio license, the imported data lineage information from ETL tools such as Microsoft SQL Server Integration Services (SSIS) is imported and appears in Data Flows in the Data Lineage tab.

To import with the MetaWizard Import after registering the Data Lineage license

1. In ER/Studio ER/Studio Data Architect, click Tools > Import File > From External Metadata.
2. In the Import External Metadata and ETL Mappings dialog, use the Import from drop-down list to select the tool from which you want to import ETL/Data Lineage information. ER/Studio ER/Studio Data Architect displays related information below the Available Options.

   

   Note: Click inside the Value column to enable editing. Items with a red dot usually indicate information that you must provide.

   

3. Continue with the wizard until complete, selecting the necessary options such as the level of consistency checking, etc.

When the import is complete, you can view your Data Flows using the Data Lineage tab of the Model Explorer.

See Also

• ETL
• Data Lineage Workflow