How to Use the Bridge Wizard
Before using this wizard, make sure that the classpath environment variable for your system contains the path to the JDBC driver you intend to use:
•For Oracle, include Classes12.zip
•For Microsoft SQL Server, include sqljdbc.jar
For example, the path to the JDBC driver for a standard Oracle 10.2 installation would be:
You can set this environment variable either from a DOS command line using the "set" command, or from the Advanced tab of the System Properties feature. System Properties can be accessed by right-clicking on the My Computer item, and selecting Properties.
Note that the USoft Binder and Definer must be restarted if this environment variable is set or changed while they are running. If they are not restarted, the changes will have no effect.
Starting the Wizard
To start the Bridge Wizard, choose Tools, Data Model Tools, Bridge Wizard form the Definer menu bar. The first page of the Bridge Wizard will then appear.
Bridge Wizard Page 1
The fields available on the first Bridge Wizard page are described below. In general, it is recommended that you use the TAB key to navigate between fields.
•Read Tables button:
Once you have completed all the fields, press the Next button to go to the second page of the Bridge Wizard.
Bridge Wizard Page 2
On this Bridge Wizard page, you can select the tables that you want to import. If you only want to import certain columns from a table, you should also check the box for the table containing those columns. The next wizard step gives you the option of (de-)selecting particular columns.
When you press Next to go to the third page of the Bridge Wizard, the selected tables and their columns are added to the XML file used for the import step.
Bridge Wizard Page 3
On this Bridge Wizard page, you can select or deselect columns from the tables selected on the previous wizard page, to obtain a list of those columns that you actually want to import into the repository.
NOTE: If you deselect (uncheck) mandatory columns (marked with !) the USoft application is prevented from inserting data into that table. If you deselect primary keys, this will prevent a manual commit following the import.
Press the Next button to go to the fourth and final page of the Bridge Wizard.
Bridge Wizard Page 4
The Bridge wizard is now ready to import the selected tables and columns into your repository. Press Back to check, and if necessary correct the information you provided, or Finish to start the import.
If errors are detected, you can manually correct them before committing the changes.
A Batch log file containing details of the import will be created in the standard logging folder.
The Bridge Wizard stores many settings from previous runs. These settings are stored in an XML file which is located in the standard USoft temp folder, and is named USOFT_BRIDGE_SETTINGS.xml.