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.
This is the user name of the database account that is to be accessed using JDBC. The wizard will automatically fill a number of other fields if you supply a user name that has previously been used.
This is the connection string that identifies the database you want to access. Examples of JDBC connection strings can be found in the dropdown list.
This is the password associated with the RDBMS user. Upon leaving the password field the Bridge wizard will attempt to connect to the database to query the list of available schemas. If a password is not supplied, or is invalid, error messages are displayed to call attention to the password error, and to the failure to collect schema information.
Once a connection has been made to the database, the dropdown list associated with this field is filled with a list of available schemas. You can then select a schema from this dropdown list. If the request for schema information from the database fails, it is also possible to enter a schema name manually. If a particular database does not support schemas, you can enter any string in this field.
The name filter allows sets of table names to be filtered using a regular expression. E.g. A.*|B.* will not show any tables starting with A or B. Note that all \ characters have to be doubled to take account of the escape character (\) used internally. A filter which is always present is BIN\\$.*|\\/.*
This is the name of the XML file that will be used to store your retrieved tables/columns/relations. This is the file that is imported into the Definer when the wizard completes its tasks.
•Read Tables button:
If you press this button, all tables will be read from the JDBC data source, and the contents of the Tables file will be overwritten. If you do not press this button (to save time, for example) the current contents of the tables file will be used in the next wizard step.
Once you have completed all the fields, press the Next button to go to the second page of the Bridge Wizard.