Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Chapter 14 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 Properties
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.
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.
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 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.
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.
2.
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.
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.

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved