A wizard to create a project would be helpful and a nice addition, but I think
enhancements in testing would prove extremely valuable.
I think it would be valuable to enable a developer to test a connector directly, like
ConnectorHost in the existing CDK does, but also to easily test a connector executing in
Teiid. My personal experience is that when I started developing connectors, I was
surprised by the SQL that the engine would pass down to my connector, and often found
defects in the connector this way, after I had completed my direct testing of the
connector. In addition, joins cannot be tested with the existing CDK for connectors that
do not support joins, putting Teiid or some parts of Teiid in to execute the test seems
the right solution.
An idea that MWalker and I had discussed some time ago, based upon a tool he had seen at a
client site, was a test driver that generated a bunch of SQL based upon JDBC metadata.
Client use of this tool improved the SF connector while it was undergoing BETA testing at
the client. A capability like that would alleviate the some of the testing burden on the
developer, and also be helpful in exposing gaps in the developer's understanding of
the SQL that they will receive based upon the capabilities they select.
----- "Ramesh Reddy" <rareddy(a)redhat.com> wrote:
This email solicitation for contributors and to discuss about
requirement for developing custom/user developed Connectors in Teiid.
This is email contains contents from email that Van sent out
Teiid currently provides command line tool called CDK, which can be
to test Custom connectors, however this tool is inadequate, does not
provide development time support, it only helps during testing. It
be ideal if there was a UI tool that quickly helped with setting up a
java project for Connector development and helped with testing.
Some basic requirements are
- eclipse based plug-in, and support java development
- using connector api as the template to stub out the classes
to start writing the custom connector
- provide the ability to test the connector by executing a query.
like SQL Explorer functionality Teiid Designer has
- Manage the connector type properties
- Provide ability to package the connector
Since Connectors may be the very first extensions to Teiid system that
user might extend/contribute to integrate data from custom data
making that experience less painful would be IMO a good goal.
Please comment if you think this tool is
1) valuable to pursue,
2) what other features you would wish to see in this this tool to do
terms of connector development
teiid-dev mailing list