one database data to another

[JASON_OJS]

HI,

I encountered a database transformation problem, i want to use Alteryx to dynamic transform data from databse1 to databse2

I may have hundreds of tables to perform the data migration, how to use Alteryx dynamically connect 2 database and perform this, pls help! (table name from 2 database are same)

[BrandonB · Accepted solution]

Does any actual transformation/filtering/calculation/standardization happen or are you purely loading data from one place to the next?

If the data is purely moving from database A to database B, you can create a macro with an Input Data tool and and Output Data tool with a control parameter and two action tools (one for the Input and one for the Output). This control parameter would be reading in table names and the action tool would be swapping out the table name in both the input and output. 

Then your list of hundreds of table names would feed into the macro and each loop would be processing the next table name, reading in the data and writing out to the second database. 

You can find training on batch macros here: https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Macros 

[JASON_OJS · Accepted solution]

This is a great solution! Thank you so much for your help!!!