Data Warehouse Sources › Specify General Data Warehouse Source Information

Specify General Data Warehouse Source Information

You use the General tab of the Data Warehouse Sources dialog to specify the options for system name, host name, and DBMS type of the selected data warehouse source. It also displays the name of the database, script file, .erwin file, CA ERwin Model Manager model, or CSV file from which you imported the source data if you imported the data warehouse source. The dialog is available in a physical model when you select the Data Movement check box on the General tab in the Model Properties editor.

To specify general data warehouse source information

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

   The Data Warehouse Source Selector opens.

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

   The Data Warehouse Sources dialog opens.

3. Select the General tab and enter the following information:
   • System Name

     Enter the name of the system in which the data source is located.

   • Host Name

     Enter the name of the host server for the source data.

   • DBMS Type

     Enter the DBMS type in which the source data is located.

   • Version

     Enter the DBMS version in which the source data is located.

   • Type

     Select whether the source data is relational or from a flat file.

4. Click OK.

   The settings are saved.