Using JBoss technologies for ETL

Solution Verified - Updated -

Environment

  • Red Hat JBoss Data Services (EDS) 5.3.1

Issue

  • Can JBoss technologies be used for Extract/Transform/Load (ETL) applications?
  • For example,
    • Extract data from a relational database like Oracle
    • Transform it into XML as defined by various XSDs
    • Load to a data warehouse using web services
  • I am looking for an ETL file processing feature. Is anything that Data service can provide?

Resolution

  • JBoss Data Services [1], using Teiid technology, has powerful capabilities that may be applicable to ETL

    • It is capable of:

      • generating XML documents from relational database data

      • generating webservices to access that XML

[1]  http://www.jboss.com/products/platforms/dataservices/

This solution is part of Red Hat’s fast-track publication program, providing a huge library of solutions that Red Hat engineers have created while supporting our customers. To give you the knowledge you need the instant it becomes available, these articles may be presented in a raw and unedited form.