Can you please confirm if you are looking to process multiple XML files when using XML target connection in IICS?
Source connection is XML and source files also xml files i have to read multiple xml files at a time and proecess target as oracle.(IICS).
Source ---XML----Multiple xml files (More than 1 file) simple one to one mapping.
Not sure if it helps, user had similar query and someone suggested to use Hierarchy Parser transformation.
For Hierarchy Parser transformation, use the .txt file as input. Provide the XML location in the text file, I hope it reads all the XML files.
I am working on a similar use case but my issue is I need to process multiple files with datetimestamp in it to a hierarchy parser transformation.
Here is the detailed description.
In IICS, is there a way to rename multiple xml files that are received from a source to a static name inorder to be used as an input file for a hierarchy parser as the input file only accepts static names.
Is there any other way to find a file through a wildcard character and can be used in the input file to a hierarchy parser in IICS?
I did try this option but it did not work.
I would appreciate any find of help.
Can you please clearly elaborate and explain what are your source files and the required output as your first and second statements are contradicting.
And one suggestion to your question of processing multiple files, even though the names are different if the structure is same then the files will be processed without any issues.
If you have any queries, please reach out to me over mail.
I did create a list file using dir command in the preprocessing step that contains all the files to be processed in a format like:
The hierarchy parser is now able to process multiple files. I was concerned about the filenames being static for the input to the hierarchy parser transformation instead of using any parameters for the filenames.
And the output is being merged into one text file in spite of the input being multiple files. Is there any way that will give out a one-to-one file, instead of many to one.