You can import a Business Object Model from a database.
Procedure
Make sure that a database connection profile for the database that you require has been set up, as described in the implementation guide for your destination platform.
If TIBCO Business Studio does not connect automatically to the database, connect as also described in the implementation guide for your destination platform.
Start the database import wizard using one of the following methods:
Right-click the
Business Objects
folder, and select
Import > Database.
Select
File > Import > Business Object Modeler > Database.
The
Import from Database dialog is displayed. It lists any databases that have been found.
Select the database required from the list displayed and click
Next.
The
Select BOM destination location dialog is displayed. This enables you to specify where the imported business object model should be created.
The Business Objects folder of the current project is selected as the default location, You can change this, and you can specify a name for the imported file. Specify the values you want.
You can now either click
Finish, to import all tables in the database, or click
Next to specify what to import.
If you click
Next, the
Database Tables dialog is displayed. By default, all the tables in the database are selected. Select or deselect database tables as you require, and then click
Finish. The selected tables from the database are imported to the location you specified, and a business object model is created from them.
Result
When a model is imported from a database:
Each database table is mapped to a Class in the Business Object Modeler.
Each column in a table is mapped to an Attribute in a business object model Class.
If foreign key constraints are present in the imported tables, an Association is created between the Classes that represent the tables. Even if more than one foreign key constraint is present in the same table, one Association is created.
