In addition to the metadata created or extracted using CloudConnect Designer, you can also write metadata definition in the Source tab of the Graph Editor pane. Unlike the metadata defined in CloudConnect Designer, such metadata written in the Source tab cannot be edited in CloudConnect Designer.
To define the metadata in the Source tab, open this tab and write there the following:
<Metadata id="YourMetadataId" connection="YourConnectionToDB" sqlQuery="YourQuery"/>
Specify a unique expression for YourMetadataId
(e.g. DynamicMetadata1)
and an id of a previously created DB connection that should be used to connect to DB as
YourConnectionToDB
. Type the query that will be used to extract meta data
from DB as YourQuery
(e.g. select * from myTable).
In order to speed up the metadata extraction, add the clause "where 1=0"
or "and 1=0"
to the query. The former one should be added to a query with no
where condition and the latter clause should be added to the query which already contains
"where ..."
expression. This way only metadata are extracted and no data will be read.
Remember that such metadata are generated dynamically at runtime only. Its fields cannot be viewed or modified in metadata editor in CloudConnect Designer.
Note | |
---|---|
It is highly recommended you skip the |