Is it possible to a batch load or perform loading of multiple objects from Salesforce using Matillion ETL?
You can use the Salesforce Query component to ingest data from Salesforce into your target data platform. If you wish to rotate through multiple tables, I would suggest using one of the Iterator components to loop through a list of input table names, and set the Salesforce Query component to use "Advanced Mode" so that you can provide it with a `SELECT * FROM...` query to retrieve all fields. You will want to pass in a variable for the table name in Salesforce and also use that to determine the name of the destination table.
Hope this helps.
Example of selecting all columns using Advanced mode:
Example of variable for target table:
