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
That's not a great use case for Appian. But have a look at this.
community.appian.com/.../transferring-processing-large-data-sets-etl