The 6.2 is shaping up to be a feature packed release, and M1 is now available to try them out. While still supporting embedded mode as before, the Teiid kit can also be run in server mode with support for SSL connections. Either mode now supports encrypted passwords, pluggable authentication/authorization, and greater configurability of logging. The kit also includes an example integrating the portfolio example without the Designer. See http://www.jboss.org/community/wiki/TeiidConnectorSuppliedMetadata for more of direct usage of the JDBC and Text connectors.
Stay tuned for the next milestone with more features, documentation, and of course fixes.
The Teiid Team