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

[Ramesh Reddy]

+1 for #2

Option #2 makes more sense with the current road map for Teiid and also
gives clean way to define the tables for the Dynamic VDB scenario.

Only observation is that, the users who used Designer to manually build
the Text based "physical" models before, can not do that any more. The
new recommended way would be, build a virtual model and use the "table"
command in the "transformation" of your "virtual table" to define the
table. So, there is no need for the "physical" model.

So, what I am confused about is, how the "connection factory" is
assigned to this model, as currently the primary way Teiid binds this
information through "physical" models?

we certainly do not want to hard code the "absolute" file paths in the
transformation.

Thanks

Ramesh..

On Thu, 2010-05-20 at 16:47 -0400, Steven Hawkins 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