You can fully automate the process with third party tools, e.g. have a look at this blog post for converting XML Guidewire to a relational database, Hive, ORC or Parquet https://sonra.io/2019/08/08/masking-and-converting-guidewire-xml-to-oracle/ ... View more