Database concepts are BusinessEvents concepts that you create by mapping tables or views from a database to BusinessEvents concepts. One table or view maps to one BusinessEvents database concept definition. A row in the table or view maps to one database concept instance.Database concepts are ordinary BusinessEvents concepts with additional functionality. They enable you to perform database operations such as insert, update, delete and query, using rules and rule functions. In this way, you can keep the database concepts synchronized with their database equivalents (see Performing Database Operations for more details).Database concepts are created using the DB Import utility. This utility introspects the specified database schema and generates BusinessEvents concepts.Optionally, you can import database constraints, that is, relationships between tables. In the BusinessEvents project the table relationships become relationships between concepts.Optionally, you can create a simple event for each concept you import. The payload of each simple event contains the corresponding concept’s schema.In order to work with external databases, concept instance are serialized to XML. By default, when concept instance objects are serialized to XML, properties with null values are excluded. You can control handling of null properties in the XML representation of serialized concepts. Note that for numeric datatypes, some special handling may be required for interoperability. See Configuring How to Handle Null Concept Property Values for details.The feature has been tested with Oracle 10g Enterprise Edition (see the readme file for specific version information) using the following drivers:
Copyright © TIBCO Software Inc. All Rights Reserved.