Previous Topic
Table/View/Synonym Properties
This topic describes the properties of a Table/View/Synonym object in a catalog.
| Property Name | Description |
|---|---|
| Collection Name | Designer displays the property for tables in a MongoDB connection only.
You can use it to specify the name of the collection in the MongoDB database. Data type: String |
| Database Name | Designer displays the property for tables in a MongoDB connection only.
You can use it to specify the name of the database in the MongoDB database. If the database you specify exists in the MongoDB database, Designer connects to the database; otherwise, Designer gets no data. Data type: String |
| Description | Specifies the description of the object. Data type: String |
| Element Path | For tables in a MongoDB connection, the property specifies the element name path from the top level document if the table is mapped to a document array element. The path is the element names separated by ".". The property value is blank if the table is mapped to the top level element. Designer uses "\" as an escaped char. If the element name contains "." and "\", Designer records them as "\." and "\\".
For tables in a JSON/Elasticsearch connection, the property shows the element path from the root element to current element, and is read only. Data type: String |
| Linked Parameter | Specifies the parameter to bind to the parameter in OOJDBC.
Designer does not display this property for tables in a JSON/Elasticsearch connection.
Data type: String |
| Name | Specifies the mapped name of the object in the catalog.
Data type: String |
| Qualifier | Specifies the name of the database catalog which contains the object. Designer does not display this property for tables in a MongoDB/JSON/Elasticsearch connection.
Data type: String |
| Schema | Specifies the name of the schema which contains the object. Designer does not display this property for tables in a MongoDB/JSON/Elasticsearch connection.
Data type: String |
| Table Name | Specifies the name of the object in the raw database. Designer does not display this property for tables in a MongoDB/JSON/Elasticsearch connection.
Data type: String |
| Type | Specifies the type of the object. Choose an option from the drop-down list. After you edit the type, Designer moves the object to the corresponding resource node automatically. Designer does not display this property for tables in a JSON/Elasticsearch connection. Data type: Enumeration |
Back to top