Creating a Data Source

Go Up to Working with Data Sources

To create a data source

1. In the Team Server main menu, select Data Catalog.
2. Click the New Data Source button on the upper-right corner. Team Server displays the New Data Source dialog box.
3. In the New Data Source dialog box:
   1. Type a unique Name for your new data source.
   2. Select a Class for your new data source.
   3. Type a Definition that provides detailed information about the data source, such as its purpose and audience. You can also include a Production Level, Location, and Status.
   4. In the Type combo box in the Connection Properties area, select the database management system (DBMS) that stores the database.
   5. Complete 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.
   6. Optionally, under Custom Properties, you can define custom properties for the data source. For each property:
      1. Type the Name and Value for the property.
      2. Click Add to add the defined property-value pair to the list of properties of the data source.
   7. 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 of the following options:
         • User/Password. Define User Name and Password for the login credential. You can edit it later to modify or include more information.
         • OS Authentication. Type the Trusted Host and Role.
         • Use existent Login Credentials. Allows you to choose credentials that already exist.
         • No login information. Allows you to create or relate the login credential later.
   8. Click Save to save your new data source.

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

See Also

• Creating a Data Asset
• Deleting a Resource
• New Data Source