My requirement is to provide JDBC access to a proprietary mainframe data
source. Very similar to JDBC access to an EIS system except that the
large number of tables available would require that a data subset be
defined at run-time via a "schema" qualifier. It also requires that
access be restricted by a mainframe userid/password which needs to get
passed on the JDBC connection through to my connector.
My initial plan was to distribute Teiid and my connector as a JDBC
driver that could be embedded (1 or more JAR files) in a client
application. The Teiid+connector would accept JDBC connections and my
connector would expose the data source as a subset of the available
tables and support simple table queries against those tables. The meta
data would be retrieved from the mainframe data source and queries would
be translated into queries that the mainframe data source understands.
The data returned would be presented as a set of table rows with
accompanying meta data.
I hope you understand my dilemma with the JBoss AS requirement.
Ramesh Reddy wrote:
Charles,
What is the real requirement you are working for?
1) Does Teiid need to be embedded in your own Java app (in same JVM) and
work from there?
2) Teiid can be standalone (separate VM), to which your Java application
connects to?
If (2), you can do that with current Teiid profile. You can bundle your
"connector" (note: from 7.0 these are called "translators") along
with
Teiid and JBoss AS in a single ZIP file and deploy on Windows, Linux
etc.
If (1), what you are looking for is embeddable Teiid. It is possible to
create "embedded" Teiid, however currently we do not offer this. We were
planning to do this 7.1 or 7.2. If you are interested in this feature
you can log a JIRA at
https://jira.jboss.org/browse/TEIID
If there is enough interest from community, we can bump the priority of
the feature.
On Thu, 2010-06-03 at 12:37 -0400, Charles Simon wrote:
> I have been looking at the new Teiid requirement that it must be
> deployed into JBoss AS. I was expecting to be able to package Teiid and
> my connector in a single "easily" installable package on Windows. With
> the JBoss AS requirement that appears to no longer be possible.
>
> I have 2 questions.
>
> 1) What is the minimalist profile that is required for Teiid to work?
>
"default" works fine. If you do not care about admin functionality, with
some tweaks "web" profile may work too.
> 2) Can I install and configure JBoss AS plus Teiid plus my connector and
> distribute that as a single package, or is that no allowed by the licenses?
>
>
Teiid is LGPL2.
Thanks.
Ramesh..
--
Charles Simon
Principal Software Engineer
Select Business Solutions, Inc.
35 Nutmeg Drive
Trumbull, CT 06611
http://www.selectbs.com
mailto:charles.simon@selectbs.com