Managing the Data Source

Open Plan enables you to manage your data source using the PPM Datasource Management Tool dialog box.

Clicking Data Sources from File Menu > Preferences displays the PPM Datasource Management Tool dialog box. You can use this dialog box to add, edit, and delete data sources. You can change to a different data source by selecting it from the list.

If you are currently connected to the data source you are modifying, your changes will not take effect until the next time you start Open Plan.

Datasource Configuration Files

The PPM Datasource Management Tool stores data source information in the datasources.dat file and uses the config.dat file to determine the location of the data source repository.

  • datasources.dat file contains the data source definitions used by Open Plan. By default, the datasources.dat file is in the ProgramData folder.
  • The config.dat file specifies the location of the data source repository used by the application. By default, the config.dat file is in C:\ProgramData\Deltek\PPMDatasources\.

By default, applications use a locally installed datasources.dat file. Administrators can optionally configure applications to use a centralized data source repository located on a shared network location. When a centralized repository is configured, the path to the shared datasources.dat file is stored in config.dat.

Open Plan Configuration and Database Files

Open Plan installs its editable configuration files and Access database files in the ProgramData folder. You can update these files without running Open Plan as a machine administrator.

C:\ProgramData\Deltek\<Product Name>\<Platform Name>

  • <Product Name> is the product and version you installed, for example, Open Plan Professional 9.0.
  • <Platform Name> is x86 or x64, depending on your installation.

Configuration Files

Each file has the same security settings:

  • Users: GenericRead, GenericWrite, and GenericExecute Microsoft Windows access rights
  • Administrators: GenericAll access rights
FileWhat you can now do without administrator rights
Datasources.datCreate, edit, and delete the data source configurations you use to connect Open Plan to your database. This works in Open Plan, the Open Plan Data Tool, and EPM SA.
AddIns.datCreate, edit, and delete items on the Open Plan Add-Ins menu.
Transfer.datCreate, edit, and delete the General Import script items that appear in the General Import and General Export dialog boxes.
OPMaster.cfgLet the Open Plan Data Tool update its configuration data.

Access Database Files

The following Access database files are installed in the C:\ProgramData\Deltek\<Product Name>\<Platform Name>\Access folder:

  • Briefcase.dat
  • OPMASTER.mdb
  • OPP.mdb
  • OPP_BRIEFCASE.mdb

Related Topics

Related Procedures