[teiid-dev] alternative to the text connector / translator

[John Doyle]

Do you consider this (2) a long term solution?  I know there has been talk for longer than I have been here about a better text connector.

~jd
----- "Steven Hawkins" <shawkins at redhat.com> wrote:

> Hello all,
> 
> In working through the kinks of the example with Paul in the latest
> milestone, it's clear that the text translator / file resource adapter
> functionality is as confusing as ever for a user.  To simplify our
> approach to text we should at least remove the use of a separate
> descriptor file.  There are two logical successors to that approach:
> 
> 1. move the additional metadata onto the model as extension properties
> (HEADER_ROW, DELIMITER, etc.)
> 2. introduce a system function similar to Postgres' copy from
> (http://www.postgresql.org/docs/8.1/static/sql-copy.html) that would
> essentially reuse the connector logic, but not require a table based
> physical model of the files.
> 
> Assuming the use of a simple file translator/ resource adapter
> procedure to get files, the downside to either approach is that
> relative file names would now be stored on either the model or in a
> function.
> 
> I support the second, since it completely removes the need for a
> heavy-weight text translator and is feasible before RC1.
> 
> Steve
> 
> 
> _______________________________________________
> teiid-dev mailing list
> teiid-dev at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/teiid-dev