Copyright © TIBCO Software Inc. All Rights Reserved


Chapter 13 Domain Models : Importing and Exporting Domain Models

Importing and Exporting Domain Models
You can import domain model information from a database, from a Microsoft Excel spreadsheet, and from the source of a database concept property. (Database concepts are available in the TIBCO BusinessEvents Data Modeling add-on).
After you import a domain model, associate it with a property. See Associating Domain Models with a Property
Import From the Source of a Database Concept
You can import all values from the database column that corresponds to a database concept property for use as the domain model entry for that property. This is explained in TIBCO BusinessEvents Data Modeling Developer’s Guide.
Export To and Import From Excel
You can export a domain model to an Excel spreadsheet. The description for each domain model entry goes in column A, and the value goes in column B. When you import from an Excel spreadsheet, similarly, column A is used as the description, and column B is used for the value.
In TIBCO BusinessEvents Decision Manager, you can export decision tables to Excel and import them from Excel. When you do so, you also export and import domain models associated with properties used in a decision table column. See TIBCO BusinessEvents Decision Manager User’s Guide for details.
To Import Domain Model Entries from Excel
1.
Right-click the folder where you want to create the domain model and select Import > TIBCO BusinessEvents > Domain Model.
In TIBCO BusinessEvents Studio Explorer, select any item in the project entity and select File > Import > TIBCO BusinessEvents > Domain Model.
2.
Click Next. You see the Import Domain Model Wizard.
If you invoked the import wizard by right-clicking a folder, that folder is selected as the parent folder. You can choose a different one as desired.
3.
4.
5.
6.
7.
Click Finish. You see a message, "Domain Import Successful." Click OK.
8.
You see the Domain Model editor. The column values appear as domain entries. You can add, edit, duplicate, and remove entries as appropriate.
To Export Domain Values to Excel
1.
Right-click the domain you want to export and select Export > TIBCO BusinessEvents > Export Domain to Excel.
In TIBCO BusinessEvents Studio Explorer, select any item in the project entity and select File > Export > TIBCO BusinessEvents > Export Domain to Excel.
2.
Click Next. You see the Export to Microsoft Excel File Wizard.
3.
In the Select Excel File to Export to field, browse and select the Excel file to which you want to export the domain model information.
To create a new Excel file, specify a filename that does not yet exist. If you specify an existing Excel file, the file contents are replaced with the exported domain model information.
4.
If you invoked the export wizard by right-clicking a domain model, that domain model is selected. You can choose a different one as desired.
5.
Click Finish. You see a message, "Export Domain Model to File Successful." Click OK.
Import From a Database Table
When you import domain model information from a database, the result set from the SQL query is transformed for use as domain model entries. This feature is supported with Oracle Database.
To Import Domain Model Entries from a Database Table
1.
Add a JDBC Connection resource and configure it to connect to the database from which you want to import the domain model. See TIBCO BusinessEvents Developer’s Guide for details.
2.
Right-click the folder where you want to create the domain model and select Import > TIBCO BusinessEvents > Domain Model.
In TIBCO BusinessEvents Studio Explorer, select any item in the project entity and select File > Import > TIBCO BusinessEvents > Domain Model.
3.
Click Next. You see the Import Domain Model Wizard.
If you invoked the import wizard by right-clicking a folder, that folder is selected as the parent folder. You can choose a different one as desired.
4.
5.
6.
7.
In the JDBC Resource URI field, browse and select the JDBC Connection resource that connects to the database you want to use.
The connection information from the JDBC Connection resource displays. You can override it here as desired.
Click Next. You see a list of tables in the database. Expand the list of tables to see the columns that match the datatype specified in step 6.
8.
Select one or more columns, then click the Create Domain for Selected Columns button. Values of all columns are used for the domain model entries.
Click Advanced and enter an SQL query whose resultset is used to create the domain entries. This option enables you to make use of joins, where clauses, and so on. Then click Execute Query.
9.
Click Finish. You see a message, "Domain Import Successful." Click OK.
10.
You see the Domain Model editor. The column values appear as domain entries. You can add, edit, duplicate, and remove entries as appropriate.

Copyright © TIBCO Software Inc. All Rights Reserved