I am able to extract attributes from XML data using GetFile>SplitXml> EvaluateXQuery processor. Now, I have many attributes that I need to put inside the SQLData.
In my database I have a table with (block_id,kp_begin,kp_end) header. So, can anyone please tell me how can we insert the collected dynamic attributes into the table, which processor should I use and what will be the configuration?
Can you share a snippet of what the original XML looks like? I'm wondering if you need the SplitXML or not. Also it looks like you have a number of "records" in each split XML file, so you probably don't want to put all the values into attributes. Instead, consider PutDatabaseRecord with an XMLReader, if there are multiple entries in the XML that each correspond to a row in the database, PutDatabaseRecord with XMLReader should do all the work for you.
Thanks for your quick reply.Here is the xml snippet. Yes, you are correct, I have a number of records in the XML out of which I just want Block_Id, Kp_Begin, Kp_End. Can you please tell me what will be the configuration in PutDatabaseRecord that case