Discussed while testing and checking with Mark the pottery barn XML extraction for findings on the possible cause of the slow process and the solution for it. Discussed with Jimmy and Mark as well if the parsing can be done directly on Pentaho as Pentaho is the one inserting the data in JDA, as discussed it can be done as the DAT file cannot be processed by Pentaho.