Data Warehouse Sources › Import a Data Warehouse Source

Import a Data Warehouse Source

You use the Data Warehouse Sources dialog to import a data warehouse source. The Detail tab in the Data Warehouse Sources dialog is used to manually define tables and columns of a data warehouse source or import source information from an existing database, script file, .erwin file, CA ERwin Model Manager model, or flat file. You can also use this tab to add a new table to the Tables list, change the name of the selected table, or delete a table as a data warehouse source.

To import a data warehouse source

1. Click in the Data Source tab of the Columns editor or the Domain Dictionary.

   The Data Warehouse Source Selector dialog opens.

2. Click Edit in the Data Warehouse Source Selector dialog.

   The Data Warehouse Sources dialog opens.

3. Select or create a data warehouse source in the Source Name column in the Data Warehouse Sources dialog, and select the Detail tab.
4. Click Import from .CSV File to import a CSV file, or click Import Other to import from a database, script file, or *.erwin file. If you select to import from a database, script file, or *.erwin file, the Data Source Import wizard opens which enables you to select the items to import, set import options, and select case conversion of physical names options.

   When you complete the import process the imported tables and their columns display in the Detail tab of the Data Warehouse Sources dialog.

5. Click OK.

   The imported data warehouse source is saved.