Mapping an SQL statement with multiple table joins to a single database concept object.
Article ID: KB0085908
Updated On:
| Products | Versions |
|---|---|
| TIBCO BusinessEvents Enterprise Edition | - |
| Not Applicable | - |
Description
Resolution:
Description:
============
Mapping an SQL statement with multiple table joins to a single database concept object.
Environment:
==========
TIBCO BusinessEvents 3.x,4.x
JDBC Database
Resolution:
=========
1). One database table or view maps to one BusinessEvents database concept definition.
2). If you want to use data from multiple tables then you can create a composite table which will have the data from the result returned by the execution of join between multiple tables. This table can be used to create the database concept in BE.
References:
==========
For more information refer to the section entitled Database Concepts in "tib_be_data_modeling_developers_guide.pdf" under <Tibco_4.0_HOME>/doc/data_modeling/pdf
Description:
============
Mapping an SQL statement with multiple table joins to a single database concept object.
Environment:
==========
TIBCO BusinessEvents 3.x,4.x
JDBC Database
Resolution:
=========
1). One database table or view maps to one BusinessEvents database concept definition.
2). If you want to use data from multiple tables then you can create a composite table which will have the data from the result returned by the execution of join between multiple tables. This table can be used to create the database concept in BE.
References:
==========
For more information refer to the section entitled Database Concepts in "tib_be_data_modeling_developers_guide.pdf" under <Tibco_4.0_HOME>/doc/data_modeling/pdf
Issue/Introduction
Mapping an SQL statement with multiple table joins to a single database concept object.
Feedback
Yes
No
Powered by
