The Bridge Wizard

The Bridge Wizard can be used to import a selected set of tables into your USoft repository from any database that has a JDBC driver. Domains are automatically created with the correct data type. Relationships are also created automatically, with the same properties that were specified in the source database.

Supported data types and their translation

The JDBC protocol translates all database datatypes to JDBC equivalents. An XML file containing all supported JDBC data types and their mapping to USoft data types is located in the USoft-install-dir/app folder, and is named: DataTypeMap-jdbc-generic.xml. Do not edit this file as it is used in the import process.

Supported relationship properties

Update rules and delete rules are imported with the same specifications used in the source data.