[teiid-dev] Connector Development Tooling (CDK)

[John Doyle]

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.

~jd

----- "Ramesh Reddy" <rareddy at redhat.com> wrote:

> This email solicitation for contributors and to discuss about tooling
> requirement for developing custom/user developed Connectors in Teiid.
> This is email contains contents from email that Van sent out
> internally
> last week.
> 
> Teiid currently provides command line tool called CDK, which can be
> used
> to test Custom connectors, however this tool is inadequate, does not
> provide development time support, it only helps during testing. It
> would
> 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
> required
> to start writing the custom connector
> - provide the ability to test the connector by executing a query.
> Much
> 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
> a
> user might extend/contribute to integrate data from custom data
> sources
> 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
> in
> terms of connector development 
> 
> Thanks
> 
> Ramesh..
> 
> _______________________________________________
> teiid-dev mailing list
> teiid-dev at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/teiid-dev