I would like to copy multiple table from Database A to Database B.
Is it possible to develop one workflow (Using Batch Macro) that can copy multiple table at once instead of creating one workflow for each table? If yes, do you mind to guide and explain?
Yes, it can be developed with a batch macro,
You can put a text input with the list of tables in the main wqorkflow and pass the name of the tables as a parameter,
if it is in the same database and different schema you can use the pre-sql or post-sql option of the output data tools
if they are in different databases, you read the source table and write to the target table of the other database in separate tools