The sections below describe the pages and options you will be presented with when importing from an external database:
Configuration page—The options here determine basic configuration information including selection of the table, or view to import from.
Column mapping—This page allows you to map the columns from tables to those in the database.
Results page—This page shows you the import results.
This screen allows you to specify the source table or view in the external database on which the add-on reads data from and choose the Java class used to map data. All the tables in the connected external database display in the SQL table view property's drop-down list. The options include:
Options | Definition |
|---|---|
Import mode |
|
Force import | When activated, this option disables all triggers and constraints. Otherwise, all triggers and constraints are enabled. |
| Ignore the empty or null values | By default, the existing record is not updated with null and empty cell values from the imported data. |
| Check empty or null primary keys | The add-on verifies that all primary keys are mapped and validates the data before importing. If you disable this option, the add-on does not perform this verification. |
| SQL table or view | Allows you to choose from external database tables or views based on the data source names which are declared in the configuration. |
| SQL predicate | Defines the SQL predicate as conditions to filter out data of SQL table or view to import into an EBX® table. |
| Mapping Java class | Displays all pre-defined SQL java classes used to map columns. |
This page allows you to map source columns in the database table with EBX® table columns. You can select or ignore columns by checking the checkbox before each field name prior to data import.
This page provides an overview of results from an import. From this page you can exit, or start a new import.