How can I send data from one database to another database in uipath?

Help Activities
, , , ,
1

I want to extract data from one database and send it to another database. How can I do that.

2

Hi @burak

  1. Use a Connect activity to connect the source datatable. Build the corresponding connection string in the configuration wizard of the activity.

  2. Use Execute Query activity to get the data. Store the data in a variable dt_sourceData of variable type datatable.

  3. Use another Connect activity to connect to the destination database.

  4. Use Insert Datatable activity to insert the datatable dt_sourceData to the destination database, to which the connection has been established.

Hope this helps,
Best Regards.

2 Likes