Open topic with navigation

TIBCO BusinessEvents® Enterprise Edition 6.3.1

# Metadata Properties Reference

Metadata Properties enable you to configure metadata information for the database concepts and their properties.

## Metadata Properties for a Database Concept

Property Name | Global Variables supported? | Description
--- | --- | ---
`OBJECT_NAME` | Yes | Name of the database table or view.
`PRIMARY_KEY_PROPS` | No | Displays a comma-separated list of names of database concept properties that are derived from primary key columns in the database, enclosed in square brackets, for example, `[ORDER_ID, ITEM_ID]`. The values are generated at import time. If there are no primary key columns, the square brackets are empty. The value of `PRIMARY_KEY_PROPS` is used to generate the `extId` (external ID) for a database concept instance. The value is overridden by the value of `EXTID_PROPS`. Primary key information from `PRIMARY_KEY_PROPS` is also used in some RDBMS catalog functions. (The value is not overridden by `EXTID_PROPS` for this purpose.)
`EXTID_PROPS` | No | Not created by the import utility. Add as needed. If none of the columns imported for a database concept are primary keys (and so `PRIMARY_KEY_PROPS` has no value), or if you want to override the value of `PRIMARY_KEY_PROPS`, use the `EXTID_PROPS` metadata property to define an `extId` value. The value of these property names at runtime should uniquely identify a database concept instance. Set the value to a comma-separated list of database concept property names. The value is case sensitive. Unlike `PRIMARY_KEY_PROPS`, square brackets are not required. The value of `EXTID_PROPS` overrides the value of `PRIMARY_KEY_PROPS`.
`JDBC_RESOURCE` | No | A JDBC URI to which this database concept maps.
`OBJECT_TYPE` | Yes | T for table V for view
`SCHEMA_NAME` | Yes | Name of the database schema from where this concept originates.

## Metadata Properties for a Database Concept Property

Property Name | Description
--- | ---
Primitive Properties
`COLUMN_NAME` | Name of the column in the database.
`DATA_TYPE` | Data type as specified in the database.
`LENGTH` | Length as defined in the database.
`PRECISION` | Precision as defined in the database.
Relationship Properties
`REL_TYPE` | C - If the concept held in this property is a contained concept. R - If it is a reference. Note: All relationships are modeled as references, even those defined as contained concepts.
`REL_KEYS` | A table containing join keys mapping source and target concepts. The Name and Value fields show the column names from the database tables that either form a Containment or Reference relationship. Name is the property name of the concept, and Value is the property name of the related concept.

Did you find this helpful?

YesNo
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO BusinessEvents® Enterprise Edition

Copyright © 2004-2024. Cloud Software Group, Inc. All Rights Reserved.