Extracting data from database 1, and putting that same data in database 2

I am planning to use a database as temporary storage of data and with a workflow, move that data from database 1 to its final database (database 2). Is this possible? Any recommendation how to do this?