PPM Datasource Management Tool
The PPM Datasource Management Tool consists of a single main dialog box that allows you to define the connection details between PPM Administrator and a database.
Process
The PPM Datasource Management Tool checks the C:\ProgramData\Deltek\PPMDatasources\CONFIG.DAT file to find the DATASOURCES key under the [SYSTEM] section, which specifies where the DATASOURCES.DAT file is located. It manages the DATASOURCES.DAT file based on the specified location.
- If the CONFIG.DAT file is missing, the tool defaults to accessing the DATASOURCES.DAT file at C:\ProgramData\Deltek\PPM\DATASOURCES.DAT.
- If the [SYSTEM] section or DATASOURCES key is not defined, the tool manages the DATASOURCES.DAT file in C:\ProgramData\Deltek\PPM\DATASOURCES.DAT.
Possible Scenarios
| Field | Description |
|---|---|
| File Not Found | If the tool tries to locate the C:\ProgramData\Deltek\PPM\DATASOURCES.DAT file and it does not exist, the tool displays the following error and closes:
"Unable to open C:\ProgramData\Deltek\PPM\DATASOURCES.DAT file. Please re-install PPM Administrator." |
| Invalid Path | If the location specified in the CONFIG.DAT file is incorrect (for example, folder does not exist or the path format is invalid), the tool displays:
"<location> is not a valid path. Please check the path in CONFIG.DAT file." |
| Permission Issues | If the user lacks read or write permissions for the file, the following message displays:
"Unable to open <location> file. Please apply read and write permissions to the file or folder." |
| File Creation |
If the location of DATASOURCES.DAT file is defined in CONFIG.DAT and it does not exist, the tool creates a new one on that location. The message displayed is: "<DATASOURCES.DAT location> file was created. Applying read and write permissions for other users might be needed." |
Contents
| Field | Description |
|---|---|
| Data Sources | This grid displays the list of available data sources and their corresponding connection information, such as the name the data source, database management system (Oracle or SQL Server), and type of the data source provider (Native or OLE DB).
The fields in the grid are read-only. Double clicking a row will display the Edit Data Source dialog box of the selected database. |
| Add | Click this button to display the Add Data Source dialog box with the General tab selected by default. It allows you use to create a new data source or database connection. |
| Edit | Click this button to display the Edit Data Source dialog box, which you use to modify an existing data source connection. |
| Delete | Click this button to delete a selected data source. |
| Import | Click this button to import a data source. Clicking this button displays the Import Data Sources dialog box. |