# Is it possible to a batch load or perform loading of multiple objects from Salesforce using Matillion ETL?

**URL:** <https://matillioncommunity.discourse.group/t/is-it-possible-to-a-batch-load-or-perform-loading-of-multiple-objects-from-salesforce-using-matillion-etl/1928>\
**Category:** Matillion ETL\
**Created:** [October 27, 2022, 9:27pm UTC](https://matillioncommunity.discourse.group/t/is-it-possible-to-a-batch-load-or-perform-loading-of-multiple-objects-from-salesforce-using-matillion-etl/1928 "2022-10-27T21:27:31Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![sreevidhyas](https://avatars.discourse-cdn.com/v4/letter/s/858c86/32.png) [@sreevidhyas](https://matillioncommunity.discourse.group/u/sreevidhyas)\
**Post date:** [October 27, 2022, 9:27pm UTC](https://matillioncommunity.discourse.group/t/is-it-possible-to-a-batch-load-or-perform-loading-of-multiple-objects-from-salesforce-using-matillion-etl/1928/1 "2022-10-27T21:27:31Z")

</div>

Is it possible to a batch load or perform loading of multiple objects from Salesforce using Matillion ETL?

---

<div class="post-metadata">

**Author:** ![ChrisHastie-InterWorks](https://sea2.discourse-cdn.com/flex002/user_avatar/matillioncommunity.discourse.group/chrishastie-interworks/32/41_2.png) [@ChrisHastie-InterWorks](https://matillioncommunity.discourse.group/u/ChrisHastie-InterWorks)\
**Post date:** [November 1, 2022, 8:23am UTC](https://matillioncommunity.discourse.group/t/is-it-possible-to-a-batch-load-or-perform-loading-of-multiple-objects-from-salesforce-using-matillion-etl/1928/2 "2022-11-01T08:23:14Z")

</div>

You can use the [Salesforce Query](https://documentation.matillion.com/docs/2389995) 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](https://documentation.matillion.com/docs/2980027) 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.

&nbsp;

Hope this helps.

&nbsp;

Example of selecting all columns using Advanced mode:

 ![0694G00000OHbfwQAD_0D74G000008hGWlSAM](https://us1.discourse-cdn.com/flex002/uploads/matillioncommunity/original/1X/d05e781ec1952618852c6de542c12a7e9efeca91.png)

&nbsp;

Example of variable for target table:

 ![0694G00000OHbhsQAD_0D74G000008hGWlSAM](https://us1.discourse-cdn.com/flex002/uploads/matillioncommunity/original/1X/09f4129710c62c235c607d20d35350b841876a50.png)