There are two sides to an importer:
1. UI stuff specific to the source type for configuring source specific import settings
(type mappings, delimiters, ...), the source connection, etc.
2. UI stuff to determine what to import
It doesn't matter if everything looks like "JDBC" for step 2, since
you've already determined what are tables/relationships, procedures, etc. It
doesn't have to be exposed to the user as JDBC DatabaseMetaData per se, but would lend
itself to a consistent UI.
But we can't forget that step 1 is actually the more complicated part. Especially as
John was mentioning with things like text files.
----- Original Message -----
From: "Ramesh Reddy" <rareddy(a)redhat.com>
To: "John Doyle" <jdoyle(a)redhat.com>
Cc: "teiid-dev" <teiid-dev(a)lists.jboss.org>, "Van Halbert"
Sent: Friday, April 23, 2010 11:32:56 AM GMT -06:00 US/Canada Central
Subject: Re: [teiid-dev] Exposing connector defined metadata to tooling.
Using JDBC is good idea. This all comes down to how you want to expose
the metadata. Do you want build another layer/API in the Admin API
and/or using the system tables to slurp the metadata or you would like
to use the JDBC database metadata retrieval. JDBC is readily available,
other one is little more work.
On Fri, 2010-04-23 at 12:22 -0400, John Doyle wrote:
I see how this makes sense in terms of reusing the current
capabilities, but from a user interface design perspective I don't like the idea of
fronting different sources with the JDBC importer. Doing it this way put a bunch of JDBC
specific concerns/metadata into the import process that probably don't apply. I think
it's a better UI approach to have a simpler generic importer that doesn't expose
the JDBC metadata to the user, but exposes more simple relational concepts.
----- "Van Halbert" <vhalbert(a)redhat.com> wrote:
> In regards to building an importer, for a client we built a jdbc
> driver that provided the metadata from a spread sheet to build the
> models. I think that approach could very easily be used for a text
teiid-dev mailing list