Skip to main content
New Participant
Feb 21, 2022 1:46 PM UTC
Question

Need help in reading Huge Volume of XML Data

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.

1 reply

stefanhelzle0001
Brainy
Feb 21, 2022 2:48 PM UTC

That's not a great use case for Appian. But have a look at this.

community.appian.com/.../transferring-processing-large-data-sets-etl