# Discussion from OpenMRS list related to data loading,	legacy systems, ETL

**URL:** <https://community.dhis2.org/t/discussion-from-openmrs-list-related-to-data-loading-legacy-systems-etl/7959>\
**Category:** Support - Assistance technique\
**Created:** [22 April 2010 10:12 UTC](https://community.dhis2.org/t/discussion-from-openmrs-list-related-to-data-loading-legacy-systems-etl/7959 "2010-04-22T10:12:09Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![olatitle](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/olatitle/32/45144_2.png) [@olatitle](https://community.dhis2.org/u/olatitle)\
**Post date:** [22 April 2010 10:12 UTC](https://community.dhis2.org/t/discussion-from-openmrs-list-related-to-data-loading-legacy-systems-etl/7959/1 "2010-04-22T10:12:09Z")

</div>

This might be useful input to our ongoing data loading work:

[http://openmrs-mailing-list-archives.1560443.n2.nabble.com/Re-Details-on-Data-Migration-ETL-Module-tt4867404.html#a4867404](http://openmrs-mailing-list-archives.1560443.n2.nabble.com/Re-Details-on-Data-Migration-ETL-Module-tt4867404.html#a4867404)

---

<div class="post-metadata">

**Author:** ![Murodullo\_Latifov](https://dhis2.b-cdn.net/letter_avatar_proxy/v4/letter/m/9fc348/32.png) [@Murodullo\_Latifov](https://community.dhis2.org/u/Murodullo_Latifov)\
**Post date:** [22 April 2010 17:12 UTC](https://community.dhis2.org/t/discussion-from-openmrs-list-related-to-data-loading-legacy-systems-etl/7959/2 "2010-04-22T17:12:34Z")

</div>

Hi,

Good point. I was talking long before on using ETL as generic and flexible way to be used for import/export compared to DXP or similar initiatives going on. There is no one size to fit all, at least for me. Bob did you find any solution so far, as I know you are working on import/export module?

regards,  
murod

> **···**
>
> * * *
> 
> **From:** Ola Hodne Titlestad [olatitle@gmail.com](mailto:olatitle@gmail.com)  
> **To:** DHIS 2 developers [dhis2-devs@lists.launchpad.net](mailto:dhis2-devs@lists.launchpad.net)  
> **Sent:** Thu, April 22, 2010 3:42:09 PM  
> **Subject:** [Dhis2-devs] Discussion from OpenMRS list related to data loading, legacy systems, ETL
> 
> This might be useful input to our ongoing data loading work:
> 
> [http://openmrs-mailing-list-archives.1560443.n2.nabble.com/Re-Details-on-Data-Migration-ETL-Module-tt4867404.html#a4867404](http://openmrs-mailing-list-archives.1560443.n2.nabble.com/Re-Details-on-Data-Migration-ETL-Module-tt4867404.html#a4867404)

---

<div class="post-metadata">

**Author:** ![bobj](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/bobj/32/33033_2.png) [@bobj](https://community.dhis2.org/u/bobj)\
**Post date:** [22 April 2010 21:23 UTC](https://community.dhis2.org/t/discussion-from-openmrs-list-related-to-data-loading-legacy-systems-etl/7959/3 "2010-04-22T21:23:59Z")

</div>

> Hi,
> 
> Good point. I was talking long before on using ETL as generic and flexible  
> way to be used for import/export compared to DXP or similar initiatives  
> going on. There is no one size to fit all, at least for me. Bob did you find  
> any solution so far, as I know you are working on import/export module?

No there is no one size fits all. I agree there will be different  
approaches depending on the size of the data to be imported, the  
nature of the data source and the nature of the job (one-off vs  
routine data interchange). For routine interchange then I think we  
will have a reasonable solution with the dxf-centric approach. For  
bootstrapping of systems and migration from legacy systems my sense is  
that it will almost always be a difficult operation where the more  
skills, tools and experience the implementor has at hand the better  
off he will be - kettle, sql, xslt, awk .. they will all have their  
place.

What is dxp?

> **···**
>
> On 22 April 2010 18:12, Murodullo Latifov \<murodlatifov@yahoo.com\> wrote:
> 
> > regards,  
> > murod
> > 
> > \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_  
> > From: Ola Hodne Titlestad \<olatitle@gmail.com\>  
> > To: DHIS 2 developers \<dhis2-devs@lists.launchpad.net\>  
> > Sent: Thu, April 22, 2010 3:42:09 PM  
> > Subject: [Dhis2-devs] Discussion from OpenMRS list related to data loading,  
> > legacy systems, ETL
> > 
> > This might be useful input to our ongoing data loading work:
> > 
> > [http://openmrs-mailing-list-archives.1560443.n2.nabble.com/Re-Details-on-Data-Migration-ETL-Module-tt4867404.html#a4867404](http://openmrs-mailing-list-archives.1560443.n2.nabble.com/Re-Details-on-Data-Migration-ETL-Module-tt4867404.html#a4867404)
> > 
> > \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_  
> > Mailing list: [https://launchpad.net/~dhis2-devs](https://launchpad.net/~dhis2-devs)  
> > Post to : dhis2-devs@lists.launchpad.net  
> > Unsubscribe : [https://launchpad.net/~dhis2-devs](https://launchpad.net/~dhis2-devs)  
> > More help : [https://help.launchpad.net/ListHelp](https://help.launchpad.net/ListHelp)
