Link to External Database Page of the Data Tool Wizard

Use this page to connect to the BCR Snapshot database.

By using this page, you can link the main database to the BCR Snapshot database. The BCR Snapshot database will hold the snapshots of your project throughout the Budget Change Request workflow completion. To ensure that the BCR Analysis Reporting feature works correctly, the main database and the BCR Snapshot database must have the same tables, configuration, and product version.

The Link to External Database page is placed after the Options page or the Define Results page and before the Confirmation page of the Cobra Data Tool Wizard. This page displays if the main database has PM Compass 8.2 tables. You must configure this page with the connection details of the BCR Snapshot database. If not configured, you will not be able to use the BCR Analysis Reporting feature.

Attention: For more information on the BCR Analysis report, see "The BCR Snapshot Database" in the Deltek Cobra Installation Guide.

Contents

Field Description
Data Source This field displays the name of the selected main data source.
Link to BCR Snapshot Database By default, this option is selected if the selected main data source has already been linked to the BCR Snapshot database.

Select this option to enable the Database Owner field, the Provider field, and the Configure button and to specify the connection details of the BCR Snapshot database.

Database Owner By default, this field displays the database owner assigned to the selected main data source.

Use this field to enter the name of the BCR Snapshot database owner. This field is required.

If this field is empty and you click the Next button, the Data Tool displays an error message.

Provider By default, this field displays the provider of the BCR Snapshot database linked to the selected main data source. This field displays only Oracle providers if the selected main data source is Oracle and only SQL providers if the selected main data source is SQL.

Use this field to select from a list of available providers where you can connect to the data source.

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
  • Oracle Provider for OLE DB
  • SQL Server Native Client 10.0
  • SQL Server Native Client 11.0

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.

Back Click this button to return to the Options page.
Next Click this button to display the Confirmation page.
Note: If you click the Next button without configuring the selected provider, the Data Tool displays an error message.
Finish Click this button to run the data tool process.