Writing Field Mappings to the Reporting Database

From Version 8.0 of Precision Bridge, there is a new reporting option to write all the field mappings in a project into the reporting database. Currently, this option is supported for Oracle, MS SQL, Postgres and My SQL Databases only.

Generation of this report can be automated using the Precision Bridge Command Line

Note that this export is intended for reporting purposes only and should not be used as a backup of your project definitions. 

To enable this feature, the reporting database connection will need to be specified when the project is opened:

See the article Writing Migration Reports to Precision Bridge Web Reporting for more information on configuring a reporting database.

Once the project is opened, use the menu option shown below:

A dialogue for the Report options will show:

There are three options available in writing the field mapping information:

• Include Disabled Mappings - If there are Form Mappings in your project that are disabled, they will not be included in the report unless this option is checked.
• Include Unmapped Target Fields - Target fields that have not been mapped will not be included unless this option is checked.
• Delete previous mapping information for this project - After the field mappings have been successfully written to the database, Precision Bridge will delete all previous field mapping records for this project if this option is checked. The records to delete will be identified by the Project Name.

Click Generate Report to start the process of writing the field mappings to a database. The fields will be written to a table called PB_REPORT_PROJECT_MAPPINGS.

If the table is not found by Precision Bridge, you will be asked if you want to create it.

The following information will be written for each field mapping reported:

Column	Notes
PROJECT_NAME	The name of the project
PROJECT_VERSION	The current version number of the project
REPORT_TIMESTAMP	Timestamp of when the report was written
FORM_MAPPING_IDENTIFIER	The user defined identifier for the form mapping
SOURCE_TABLE	The name of the source table
TARGET_TABLE	The name of the target table
IS_ENABLED	Set to 1 if the form mapping is enabled, 0 otherwise.
MAPPING_TYPE	The precision bridge mapping type, for example, 'Simple'
TARGET_FIELD_NAME	The name of the target field
TARGET_FIELD_TYPE	The data type of the target field
TARGET_FIELD_LENGTH	The field length of the target field (if applicable)
SOURCE_FIELD_NAME	The name of the source field
SOURCE_FIELD_TYPE	The data type of the source field
SOURCE_FIELD_LENGTH	The field length of the source field (if applicable)
MAPPING_DETAIL	For more complex mapping types, this will provide additional details (e.g assignment expression or lookup mappings)