# Mload in Clover Etl

**URL:** <https://forum.cloverdx.com/t/mload-in-clover-etl/712>\
**Category:** CloverDX Platform\
**Created:** [May 20, 2010, 12:00am UTC](https://forum.cloverdx.com/t/mload-in-clover-etl/712 "2010-05-20T00:00:00Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![mohankrishnas](https://avatars.discourse-cdn.com/v4/letter/m/6bbea6/32.png) [@mohankrishnas](https://forum.cloverdx.com/u/mohankrishnas)\
**Post date:** [May 20, 2010, 12:00am UTC](https://forum.cloverdx.com/t/mload-in-clover-etl/712/1 "2010-05-20T00:00:00Z")

</div>

Does clover etl have mload option to load data from oracle to teradata. if so please help me out in doing so

---

<div class="post-metadata">

**Author:** ![avackova](https://avatars.discourse-cdn.com/v4/letter/a/65b543/32.png) [@avackova](https://forum.cloverdx.com/u/avackova)\
**Post date:** [May 20, 2010, 10:48am UTC](https://forum.cloverdx.com/t/mload-in-clover-etl/712/2 "2010-05-20T10:48:45Z")

</div>

Hello,  
CloverETL doesn’t have Teradata bulk loader. To load data from Oracle to Teradata, you need to unload data from Oracle with [DBInputTable](http://wiki.cloveretl.org/doku.php?id=components:readers#dbinputtable) and load it to Teradata with [DBOutputTable](http://wiki.cloveretl.org/doku.php?id=components:writers#dboutputtable).

---

<div class="post-metadata">

**Author:** ![dpavlis](https://avatars.discourse-cdn.com/v4/letter/d/90ced4/32.png) [@dpavlis](https://forum.cloverdx.com/u/dpavlis)\
**Post date:** [May 21, 2010, 9:43am UTC](https://forum.cloverdx.com/t/mload-in-clover-etl/712/3 "2010-05-21T09:43:55Z")

</div>

You could use SystemExecute to funnel CloverETL data records into **mload**. SystemExecute allows you to read records from input port, format them into text representation and then send them through STDIN to mload for uploading into DB.

You may also look at Clover’s Oracle bulk loader and just modify it for **mload**. Mload seems to allow reading data from STDIN which makes this a lot easier.

---

<div class="post-metadata">

**Author:** ![mohankrishnas](https://avatars.discourse-cdn.com/v4/letter/m/6bbea6/32.png) [@mohankrishnas](https://forum.cloverdx.com/u/mohankrishnas)\
**Post date:** [May 22, 2010, 10:21am UTC](https://forum.cloverdx.com/t/mload-in-clover-etl/712/4 "2010-05-22T10:21:49Z")

</div>

hi ,

Could you tell me how to use this systemexecute . What should be given in the system command

---

<div class="post-metadata">

**Author:** ![dpavlis](https://avatars.discourse-cdn.com/v4/letter/d/90ced4/32.png) [@dpavlis](https://forum.cloverdx.com/u/dpavlis)\
**Post date:** [May 24, 2010, 9:22am UTC](https://forum.cloverdx.com/t/mload-in-clover-etl/712/5 "2010-05-24T09:22:04Z")

</div>

Hi,

Check our wiki: [http://wiki.cloveretl.org/doku.php?id=components:others#system\_execute](http://wiki.cloveretl.org/doku.php?id=components:others#system%5Fexecute)