XDC to Relational Database
Hello, I have asked multiple questions about XDC files, trying to figure out how to decipher them...but I don't think I asked this question: how do you know what columns in the database the XDC file is mapping to?
2 answers
Hi Roanna,
The DbName parameter correspond to the repository name, where the information will be stored. The data mapping information between the field and the actual table and column where it is stored, it's part of the architecture of the produt and at that level isn't usually available to general overview . It's part of the product code.
Hi Roanna,
XDC file itself does not have mapping information between Reportable REST API (application side) and DW database columns. They are mapped in Data Manager in Rational Insight or DCC job in CLM.
- In Data Manager, if you open one of the Fact Build in ODS, then you will see the data flow. The database icon in left side is coming from XDC and the right side is database column.
- In DCC, the mapping files are found in /server/conf/dcc/sites/dcc-updatesite/plugins/com.ibm.rational.datacollection.service_XXXXXXXX.jar. Unzip this jar file, and open these mapping (.ttl) files. For the detail how to read the mapping files, please read the article below. Note: you need to know RDF triples to understand the mapping definition.
https://jazz.net/wiki/bin/view/Main/DataCollectionCustomizationUsingDCC
Comments
Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Aug 02 '17, 4:04 a.m.There is no information in this question that makes it relevant to this forum. No product versions this forum supports and no other info that can be used. Please use a search engine to find a forum that is relevant for you and while we are at it, consider reading How should I ask a question in the Forum if I want to receive useful answers? and improve your question writing skill.
Thanks