Deltek PPM Datasource Management Data Tool Help

Using the Help Search
Using the Help Search
  • Phrase:Returns all topics that contain the exact phrase in the search criteria. Use quotation marks around the phrase.
    Ex."system administration"
  • And:Returns all topics that contain all the words in the search criteria, in any combination. Insert a plus sign between all words in the search criteria.
    Ex.system + administration
  • Or:Returns all topics with any combination of words in the search criteria. This is the default.
    Ex.system administration
For more information:Searching Online Help

Edit Data Source Dialog Box

Use this dialog box to edit an existing data source or database connection.

This dialog box contains two tabs: General and Advanced.

General Tab

Use this tab to set the required connection properties.

Field Description
Name This field displays name of the data source you want to update. It is read-only.
Schema You can change the schema (database name) in this field.

This field is optional and is typically used only with Oracle. However, this field is required if the Oracle Account used has access to more than one schema in the Oracle database.

If you do not enter a schema name, the DATASOURCES.DAT file must identify an Initial Catalog for the data source.

Provider This field displays a list of available providers to use when the tool connects to the database.
Configure Click this button to display either the Data Link Properties dialog box or the Connection Properties dialog box.
If the provider is any of the following, the Data Link Properties dialog box displays.
  • Microsoft OLE DB Provider for SQL Server
  • Microsoft OLE DB Driver for SQL Server
  • Oracle Provider for OLE DB
  • SQL Server Native Client

If the provider is Oracle ODP.NET, the Oracle Data Provider for .NET Connection Properties dialog box displays.

If the provider is SQL Server .NET Framework, the .NET Framework Data Provider for SQL Server Connection Properties dialog box displays.

Advanced Tab

Use this tab to set the following settings:

Field Description
Database is Unicode Select this option if the scripts for creating tables default to a Unicode installation.
Extended Properties You can set or change extended data source properties for a database in this field.

Common Buttons

These button display when you navigate to either tab:

Field Description
OK Click this button to return to the PPM Datasource Management Tool dialog box and add the newly defined data source to the list. The new data source is selected by default.
Cancel Click this button to disregard any change and return to the PPM Datasource Management Tool dialog box.