Need help in reading Huge Volume of XML Data

Certified Lead Developer

Hi,

Reg: Need an advise in pushing the huge volume of XML data to database tables.

Using the SFTP smart service, I am receiving the complex structured .xml file which holds ~200 MB of data in Appian. Now I am looking for a optimal design/solution to push the entire file data into staging tables of the mariaDB. Could anyone help me out with the steps how can I approach this particular situation?

Any suggestions would be really appreciated.

  Discussion posts and replies are publicly visible