[teiid-issues] [JBoss JIRA] (TEIID-3746) Add ETL functionality to Teiid

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-3746?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13117110#comment-13117110 ] 

Steven Hawkins commented on TEIID-3746:
---------------------------------------

There needs to be a little more here to flesh this out.  You are mentioning both ETL and specifically a database migration scenario.  On the ETL side our basic support is just with standard SQL - insert into target ... select ... What supporting logic / tooling are you thinking about around that to round out an ETL story?  And on database migration there are quite a few open source projects in that space.  Are you proposing developing similar functionality in Teiid or simply offering something like http://flywaydb.org/ in tandem?

> Add ETL functionality to Teiid
> ------------------------------
>
>                 Key: TEIID-3746
>                 URL: https://issues.jboss.org/browse/TEIID-3746
>             Project: Teiid
>          Issue Type: Feature Request
>            Reporter: Jérôme Fenal
>            Assignee: Steven Hawkins
>
> Teeid can offer schema discovery, schema creation, data massaging from one format to another, and handle writes.
> ETL is all about that:
> - Extract
> - Tranform
> - Load
> in batch mode.
> With the dawn of batch mode in JEE7, it could be interesting to add ETL functionality, possibly in the form of a continuous datamover, or a batch datamover, which could also be used in a complete database migration scenario.



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)