Creating a Data Source

From TeamServer ER/Studio
Jump to: navigation, search

Go Up to Working with Data Sources

To create a data source:

  1. Select Data Sources.
  2. Click the New Data Source button on the upper-right corner.
  3. On the New Data Source dialog box that opens:
    1. Enter a Name for your new data source. Names of data sources in Team Server must be unique.
    2. Write a Definition that provides detailed information about the data source, such as its purpose and audience. You can also optionally enter a Production Level, Location, and Status as per your convenience.
    3. Select from the Type combo box the database management system (DBMS) that stores the database.
    4. Fill the fields after the Type field and before the Custom Properties field. These fields change depending on the selected DBMS Type. See Data Source Fields for a Specific Database Management System.
    5. Optionally, under Custom Properties, you can define custom properties for the data source. For each property:
      1. Enter the Name of the property.
      2. Enter the Value for the property.
      3. Click Add to add the defined property-value pair to the list of properties of the data source.
    6. Under Login Credentials, you can define the login credential to connect the data source. If you prefer, you can do this step later.
      1. Select one option:
        • User/Password: Define User Name and Password for the login credential. You can edit it later to modify or include more information.
        • OS Authentication: Enter Trusted Host and Role.
        • Use existent Login Credenditals. Allow you to choose one that already exists.
        • No login information. Allows you to create or relate the login credential later.
    7. Click Save to save your new data source.

Notepad blue icon 2.pngNote: Adding data sources in Team Server makes them available into ER/Studio Data Architect for the purposes of connecting or mapping.

See Also