Creating Environments

After creating a system in the Metadata Manager, you can create environments under the system. An environment can be created for different database types and flat files by fulfilling prerequisites and providing the connection parameters.

  1. Go to Application Menu > Data Catalog > Metadata Manager.
  2. Under the System Catalogue pane, right-click the system created by you.
  3. Click New Environment.

    4. The New Environment page appears.

  4. Enter appropriate values in the fields. Fields marked with a red asterisk are mandatory. Refer to the following table for field descriptions.

    5. Field Name

    Description

    System Environment Name

    Specifies the unique name of the environment.

    For example, EDW-Test.

    For more information on naming conventions, refer to the Best Practices section.

    System Environment Type

    Specifies the type of the environment.

    For example, development, test, or production.

    Data Steward

    Specifies the name of the data steward responsible for the environment.

    For example, Jane Doe.

    For more information on configuring data steward list, refer to the Configuring Data Stewards topic.

    Server Platform

    Specifies the server platform of the environment.

    For example, Windows.

    Server OS Version

    Specifies the OS version of the environment's server.

    For example, Windows Server 2012 R2.

    File Management Type

    Specifies the file management system (if the environment is a file-based source).

    For example, MS Excel.

    File Location

    Specifies a file path (if the environment is a file-based source).

    For example, C:\Users\Jane Doe\erwin\Mike - Target System

    Production System Name

    Specifies the system name being associated with the environment as the production system.

    For example, Enterprise Data Warehouse.

    Production Environment Name

    Specifies the environment name being associated with the environment as the production environment.

    For example, EDW-PRD.

    Version Label

    Specifies the version label of the environment to track change history.

    For example, Alpha.

    For more information on configuring version display, refer to the Configuring Version Display of the Environments topic.

    DQ Score

    Specifies the overall data quality score of the environment.

    For example, High (7-8).

    For more information on configuring DQ scores, refer to the Configuring Data Profiling and DQ Scores topic.

    Database Type

    Specifies the database type.

    For example, Sql Server.

    Select the type of database from where you wish to scan metadata.

    Depending upon your choice of database type you need to provide additional fields (connection parameters) appearing on the right hand side.

    Note: There are no additional fields for MS Excel File, and XSD.

  5. Click to test the connection.

    6. If the connection with database is established successfully then a success message pops up.

  6. Click Save and Exit.

    7. A new environment is created and stored in the environment tree.

    Once an environment is created, you can scan source or target metadata from the database type.

Different database types have different prerequisites and connection parameters: