Automation of Bulk Upload of data

rishub over 7 years ago

Hi All,

We need to upload a text file into AppianDB daily night that contains almost 60000 rows. I was thinking of going for a stored procedure for that but our will be on the Application server & the DB is present on another server. Can anyone guide a way how can I do it without creating an Appian process as I don't want to parse such large data into our system.

Thanks in Advance
Rishu

Discussion posts and replies are publicly visible

Parents

0 rishub over 7 years ago

Thanks for update ryanh. The only issue that I am facing for database job is that the file will be loaded on different server than the server where DB is. These servers are hosted by third party so we don't have access to them so I am not sure how the stored procedure will get file from remote server.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 rishub over 7 years ago

Thanks for update ryanh. The only issue that I am facing for database job is that the file will be loaded on different server than the server where DB is. These servers are hosted by third party so we don't have access to them so I am not sure how the stored procedure will get file from remote server.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data