Process Variable data to SQL database table

There are some good functional answers on this thread already, but I am curious about the volume of data you are dealing with and the frequency at which you want to perform this transfer. When you say "all the data from Oracle", how much data are you talking about? And how often will your application be doing this operation? At large scale, alternative methods would be preferred over doing this transfer in memory (via process variables).

There are some good functional answers on this thread already, but I am curious about the volume of data you are dealing with and the frequency at which you want to perform this transfer. When you say "all the data from Oracle", how much data are you talking about? And how often will your application be doing this operation? At large scale, alternative methods would be preferred over doing this transfer in memory (via process variables).

the data is around 10k and the scheduler will run everyday

I would have to agree with Steven above that I wouldn't necessarily want to use Appian for that job.  It's a BPM and custom business application platform, built for those functionalities and not strictly as a database transfer tool.

Another question I have now is how long are you going to be running this on a daily basis.  Is there a legitimate business case for using 2 different DBMSs at the same time?  If you were decommissioning one, that would make sense, but I would expect the data to be much larger than 10k and done once.