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

Add Data Source Dialog Box

Use this dialog box to create a new 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 Enter a unique name for the data source.

It cannot contain spaces and the following characters: , + = [ ] / \ " : < > ? * . ( ) { } | ~ ! ^ ;

Schema You can enter 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 only if the database is in Unicode. Under most circumstances,this option is used only for Microsoft Access databases and double-byte languages, such as Chinese, Russian, and Hebrew.
Note:

The Database is Unicode option is not used by wInsight Analytics.

Extended Properties You can set 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.