Best Practice to write data from Excel to Database

Is this a one-time batch import or a regular occurence?

• If it is a one time batch-import, your DBA would probably be able to help you use the DB's specific tools (e.g. SSMS for MSSQL) and get that done painlessly for you.
• If it's a regular occurrence, I would ideally use specialised tools and orchestrate the workflow with Appian if and when required.
• If, for some reason, you want to do this batch-import in Appian, you could transform/save as the Excel as a csv, split the rows and then write to datastore the individual elements of the row mapped to the requisite CDT. While this works in principle I'm not certain this is something I would do with the amount of data you are talking about.

Is this a one-time batch import or a regular occurence?

• If it is a one time batch-import, your DBA would probably be able to help you use the DB's specific tools (e.g. SSMS for MSSQL) and get that done painlessly for you.
• If it's a regular occurrence, I would ideally use specialised tools and orchestrate the workflow with Appian if and when required.
• If, for some reason, you want to do this batch-import in Appian, you could transform/save as the Excel as a csv, split the rows and then write to datastore the individual elements of the row mapped to the requisite CDT. While this works in principle I'm not certain this is something I would do with the amount of data you are talking about.