0

How to convert JSON and Excel files to CSV flat files using IICS Data Integration?

James Z
  • 12,209
  • 10
  • 24
  • 44
Rakesh
  • 3
  • 7

1 Answers1

0

There is no simple way. IICS DI is NOT a data conversion utility. Yeah, I do know how it sounds.

Now, having said that: it is possible. You can define Excel as a source and Flat File as a target.

You can read JSON data and try using Hierarchy Parser with Flat File as output. This will be quite a nightmare though.

Now, I will not give a step-by-step instructions. Please give it a try and share any issues, should you come across any.

Or even better: don't give it a try and use some Excel-to-CSV conversion script like discussed here for Windows or here for bash.

Maciejg
  • 3,088
  • 1
  • 17
  • 30
  • I have tried Hierarchy parser for JSON and able to convert the same into CSV file as target. But I need JSON file as dynamic schema, like template will change each time, so i wanted to convert JSON file with dynamic content like header will not same for each time, How to convert this dynamic JSON files to csv automatically.? – Rakesh May 04 '23 at 14:37
  • Also, do we have any Batch script to convert JSON file to CSV file automatically, so that i can use the same script in command task and convert the same. – Rakesh May 04 '23 at 14:39
  • Source needs to refer to one schema. I don't think it is possible to have it dynamic. Informatica is not designed to be generic, rather to have tailored mappings instead. Not to mention that schemas can vary in complexity and it might not even be feasible to have one way to convert anything. – Maciejg May 04 '23 at 15:50