Data Collection Component mapping files
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
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
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.