It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×11,992
×1,235

question asked: Jun 05 '17, 11:57 a.m.
question was seen: 1,487 times
last updated: Jun 07 '17, 12:24 p.m.

Related questions

Data Collection Component mapping files

0
Roanna Rague (21●2●13) | asked Jun 05 '17, 11:57 a.m.

 So I asked a previous question about migrating Data Manager ETLs to DCC. I have looked at this document: 



which has been helpful, but does this explain how to replace XDC files? 

  We've found our DCC ETLs, which are all in a .ttl file format. We have some XDC files that we no longer wish to use, however, XDC files map XML data to database tables. 

How would we go about taking XML data and mapping it to database tables without using XDC files?

Thank you

One answer

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Francesco Chiossi (5.7k●1●11●19) | answered Jun 07 '17, 11:34 a.m.

Hello Roanna,

the xdc files where needed to convert the XML returned from the REST API in an SQL format that data manager could consume, they where not actual database tables.
In the case of DCC the definition of what you would add in the xdc files is in the ttl files / resource group.

Best Regards
Francesco Chiossi

Comments
Roanna Rague commented Jun 07 '17, 12:24 p.m.

 Ok thank you. Our XDC files were apparently customized. It seems that they are mapping some specific data, we wish to duplicate what they are mapping in our .ttl file. The problem is, we cannot see what tables this information is being mapped to, or exactly what information is being mapped? 


At the top of the XDC file there is a <ResourceGroupCategory guid = "...." name="...">
Is it the 'name' that will tell us what is being mapped? 

Or is all of this pointless to try to decipher? Sorry we're new to ETLs and DCC, and these custom jobs were written by some contractors who then left. 

Thank you for your previous answer. 

Your answer

Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.