Release Notes for Teiid 7.0

Version 1

    Teiid 7.0 is a major redesign of the project containing many new features.

    Overview

    Highlights

    • JBoss AS Integration - Teiid now requires a JBoss AS 5.1 instance.       This change allows Teiid to leverage many AS/MC features, including transaction management, JCA, hot file drop VDB deployment, and the profile service for configuration. 
    • New Admin Console - This      release includes a preview release of our new administration      console. See it's feature      overview.  Once Teiid is installed, the Teiid Admin Console is automatically contributed to the JBoss Admin Console.
    • Translators and JCA components - This release separates the old connector API into light-weight      Translators and JCA components. This greatly simplifies the process      of adding new integration sources to Teiid, since it cleanly separates container provided functionality (JCA) from the Teiid specific       classes knwon as a Translator.  See the Developer's Guide for more information.
    • Text Integration - Structured text file processing is      now handled by the TEXTTABLE table function and the .
    • SQL/XML - Nearly all of SQL/XML 2003 support has been      added, as well as XMLTABLE and XMLQUERY from SQL/XML 2006.
    • Web Services Integration - XML/Relational logic has      been replaced by the SQL/XML XMLTABLE and web services execution is      now done through the WS Translator/WS Resource Adapter.
    • Expanded Dynamic VDB Support - Every source type      except for LDAP can now be integrated in a Dynamic VDB.
    • Other SQL Support - Queries can now contain nested tables      that allow for correlated variables to preceding from clause items.  Expressions are supported in the order by clause.        Double quoted identifiers are allowed by default.  Added the functions to_bytes, to_chars, and querystring.       ResultSet caching can now be utilized with the /* cache */ query hint.   
    • Improved Buffering - Forward only cursors will typically not buffer results on the server.  Algorithms for      storing and retrieving buffers have also been improved.

    Compatibility Issues

    from 6.2

    • The connector API has changed substantially.  Custom connectors need to be retargeted to the new Translator API.  See TEIID-1003 and the Developer's Guide for more information.  
    • Connector bindings are no longer valid.  Use the Designer Tooling or see the AdminShell download for a migration utility.  
    • Calling out to web services and xml processing has been dramatically simplified and improved, but is a breaking change from prior releases.   XML/Relational processing has been replaced by XMLTABLE, retrieving XML from file has been replaced by the File Translator/Resource Adapter, and   web service calls have been replaced by the WS Translator/Resource Adapter.  See TEIID-1118, TEIID-1114, and the Reference guide for more information.  
    • The direct usage of XQuery has been replaced with the XMLQuery function.  
    • The text connector file processing has been replaced with the TEXTTABLE function.  See TEIID-1102 and the Reference guide for more information  
    • Double quoted values are now parsed as identifiers by default.  See TEIID-145 and the Reference guide for more information.  
    • The system information schema has changed from System to SYS.  The tables and table structures have also changed.  See TEIID-871 and the Reference guide for more information.  
    • Client control over query plans has changed.  OPTION PLANONLY, DEBUG, and SHOWPLAN are no longer allowed.  This behavior should not be controlled by the SET statement, SET SHOWPLAN (ON|OFF|DEBUG) and SET NOEXEC (ON|OFF).  Usage of the client PlanNode class will also need to be updated.     
    • Teiid specific JDBC client interfaces and methods have changed.  In general these custom features have mostly been moved to other more standard locations or been removed. See TEIID-1020 and the Client Developers guide for more information.    
    • Teiid's reserved words have changed.  Many of the Teiid specific reseverd words have become non-reserved words.  All of SQL Foundation and SQL/MED 2003, and SQL/XML from SQL 2006 reserved words have been added as reserved words.  It is generally required to double quote all reserved words.  It is advisable to double quote all non-reserved words as well.  
    • The AdminApi has been redesigned for use with the new Translator/JCA split and for deployment in JBoss AS.  
    • The AdminShell is based on Groovy.  Most BeanShell syntax is also valid in Groovy, but there are extensive changes in the AdminAPI that may necessitate rewriting scripts.  
    • OPTION NO CACHE <table list> will now only by-pass cache for the given tables at their immediate view layer.  Previously all caches would have transitively been skipped.  See TEIID-900 for more information.  
    • Nan and +-Infinity are no longer allowed as numerical results by default.  This may be changed via the system property org.teiid.allowNanInfinity.  
    • The scale of BigDecimal values is now adjusted to allow for more intuitive results.  Conversion from floating numeric types will preserve the approximate scale and division results will allow for additional scale.  See TEIID-159 for more information.  
    • The 7.0 client is not compatible with 6.x or vice versa.  It is expected that 7.0 clients will be compatible with 7.x releases for standard JDBC operations.

    Configuration Issues

    See the Admin Guide for more on configuration and installation.

    from 6.2

    • A JBoss AS instance is now required.  Embedded mode is also currently not supported.
    • Engine configuration is now handled through the admin console or deploy/teiid/teiid-jboss-beans.xml   
    • Logging is now done through the container's log4j instance.  Any Teiid specific logging changes, see the conf/jboss-teiid-log4j.xml, need to be incorporated into the master jboss-log4j.xml.

    Other Issues

    From 6.2

    • Start time is now significantly longer due to the container deployment.  However many operations can be performed on configruation files that will trigger a redeployment without the need for a restart.  
    • Parallel execution of source queries within a query plan has been temporarily disabled.  
    • Inversion of parse, format, and convert system functions is not used if it can be narrowing.  In situations where a predicate has the form: parseTime(column, 'format') = {t 'time value'} may lead to reduced performance, since       the parseTime function cannot be pushed down.  This should be addressed in future releases. 

    Salesforce as Source

    Before Salesforce is used in your data integration project, the below issues need to be resolved.

    • Manually copy the following libraries from the JBOSS_HOME/client directory to the JBOSS_HOME/lib/endorsed directory, so that the JAX-WS 2.0 apis supported by JBossWS are used:        
      • jbossws-native-saaj.jar
      • jbossws-native-jaxrpc.jar
      • jbossws-native-jaxws.jar
      • jbossws-native-jaxws-ext.jar
      •    
       
    • There is issue with invoking "https" based URL with out specifying the either a keystore or truststore properties with JBoss remoting 2.5.1. Generally you do not need to specify the truststore as a anonymous truststore will be negotiated, however if you fail to supply the following system properties there will be a error message in the log (query will execute even with out the properties). Add these to JBOSS_INSTALL/bin/run.conf file under JAVA_OPTS        
      • -Djava.net.ssl.keyStore=<path-to-truststore>
      • -Djava.net.ssl.keyStoreType=<certificate-type>
      • -Djava.net.ssl.keyStorePassword=<password>
      •    
               

    Thirdparty Library Updates

    The following components have been updated:

    • Netty was upgraded to 3.1.5
    • Saxon was upgraded to 9.1.0.8
    • A 5.1 container's version of Arjuna is newer than what was previously included in Teiid 6.x.
    • Various other dependencies have been removed as they are no longer needed or now provided by the container.

    Detailed Release Notes

            Detailed Release Notes - Teiid - Version 7.0

            Bug

    • [TEIID-26] -         Need to add logic to determine if a command is deterministic
    • [TEIID-36] -         XAConnection needs to notify when it is no longer valid
    • [TEIID-41] -         Non selectable columns should be omitted from metadata
    • [TEIID-46] -         Fully-qualified names should not be required when referencing virtual procedures that have unique unqualified names
    • [TEIID-93] -         when a fairly complex query is pushed down to the XML-HTTP Connector, it fails
    • [TEIID-409] -         server port number should be checked for availability when creating a second mmprocess
    • [TEIID-430] -         Root access needs enforced for subsystem admin api edits of security properties
    • [TEIID-465] -         Error message in server process log refers to binding by UUID, not name
    • [TEIID-563] -         Exporting the configuration, via console or utility, the configuration system properties now contains everything in the system, not just defined by the Configuration component type
    • [TEIID-608] -         Prevent duplicate hostcontroller launches
    • [TEIID-610] -         Deleted connector bindings remain in the system state
    • [TEIID-704] -         Missing message for key "MembershipServiceImpl.Logon_failed"
    • [TEIID-728] -         Pushing blank-padded literals to source may fail to return correct results
    • [TEIID-792] -         Index connector does not accept certian criteria forms
    • [TEIID-803] -         The AdminAPI connector binding name needs to be assigned the name assigned by the designer
    • [TEIID-830] -         AdminShell row count is not accurate
    • [TEIID-848] -         Insert with out of order variables and query expression is incorrect
    • [TEIID-849] -         subquery as input to procedure fails
    • [TEIID-850] -         Misspellings in Teiid Reference Guide
    • [TEIID-852] -         Oracle timestamp to time conversion null handling
    • [TEIID-858] -         DependentSetCriteria not being replaced
    • [TEIID-865] -         WS-Relational SOAP Connector is sending empty SOAP-ACTION header.
    • [TEIID-866] -         AdminShell is not able to handle SELECT * INTO #TEMP FROM foo; (statement does not return a result set)
    • [TEIID-867] -         Possibly Teiid embedded clients (Designer) not pinging query engine, causing session timeouts
    • [TEIID-875] -         DatabaseMetadata issues
    • [TEIID-876] -         Server Times Out Session Despite Configuration
    • [TEIID-879] -         validate min/max non-comparable
    • [TEIID-890] -         AdminShell issues
    • [TEIID-893] -         XML Formatting error in Dynamic VDB (.def) file presents to user as file not found
    • [TEIID-894] -         Query inexplicably failing Query Testing only with MySQL
    • [TEIID-895] -         Update the SalesForce API to version 17 (winter 10).
    • [TEIID-896] -         INSERT failing with SF connector on types other than a string
    • [TEIID-898] -         Named procedure parameter error message too terse.
    • [TEIID-899] -         Virtual Procedure queries with input variables failing with "No value was available."
    • [TEIID-901] -         NPE encountered when doing an INSERT into SFDC Account table
    • [TEIID-904] -         Error executing the Procedural releational query with out a where clause
    • [TEIID-905] -         block clone method is incorrect
    • [TEIID-909] -         PropertiesUtils.resolveNestedProperties(Properties) goes in a loop
    • [TEIID-911] -         Prepared Batch Update against a view table fails with "Unable to evaluate $param/pos0: No value was available"
    • [TEIID-917] -         xml stream handling is inconsistent
    • [TEIID-919] -         Planner created incomplete identifiers when GROUP BY of inline view with UNION ALL
    • [TEIID-920] -         Dup removal doesn't respect desc ordering if all projected columns are sorted on
    • [TEIID-922] -         Teiid Quick Start Example documentation errors
    • [TEIID-923] -         Oracle queries with a TimeStamp in the WHERE clause are failing if multiple TimeStamps are used in "AND", "OR', and "IN" situations
    • [TEIID-925] -         dup removal results include duplicat rows
    • [TEIID-932] -         Misleading error message when using quotation marks: Parse error... encountered (
    • [TEIID-934] -         MySql Queries - SQL syntax error on pushdown queries when using functions like LPAD, REPLACE, etc
    • [TEIID-936] -         Query never returns from processing
    • [TEIID-939] -         MySQL nested set query pushdown failure
    • [TEIID-941] -         MOD function in Postgres push down is producing connector error
    • [TEIID-945] -         WS security tokens are configured but not provided to the service.
    • [TEIID-947] -         UNION query with different datatypes on each side of UNION is producing inconsistent results
    • [TEIID-948] -         Spurious wake-up error with connector work item
    • [TEIID-949] -         Criteria on constant column with aggregate function doesn't push criteria down correctly
    • [TEIID-969] -         Time, date, and timestamp literals are being sent to Oracle as to_timestamp() regardless of their data type
    • [TEIID-973] -         Quick Start Guide / Examples needs to add derbyclient.jar to UDFs for previewing
    • [TEIID-974] -         XML-Relational connectors have trouble with reponse XMLs that contain DTD reference
    • [TEIID-981] -         Ability to cache XML documents
    • [TEIID-988] -         3 argument locate function on postgres reports the wrong value
    • [TEIID-989] -         Pushdown query ORDER BY  is not always ordering results properly on Sql2000
    • [TEIID-1009] -         BQT Pushdown query "ORDER BY" is not always ordering results properly
    • [TEIID-1025] -         Help incomplete for showPlan
    • [TEIID-1036] -         AdminShell & Migrate shell scripts should be executable
    • [TEIID-1038] -         SF connector fails to connect.
    • [TEIID-1042] -         AdminShell/AdminAPI - deployVDB assumes the -vdb.xml file is in the server's deploy folder
    • [TEIID-1043] -         Invalid serialized attachments should be ingored.
    • [TEIID-1044] -         Export connection factory does not always correct properties
    • [TEIID-1046] -         Component Name of the VDB is null through Profile Service
    • [TEIID-1047] -         Teiid host resolution should match that of the JBoss AS
    • [TEIID-1051] -         Make the Connector (type) and RAR name be the same
    • [TEIID-1053] -         NPE in Teiid JOPR when running control at vdb level - View VDB requests
    • [TEIID-1054] -         When running the control:  View VDB Session, at the vdb level, the actions indicate its disabled
    • [TEIID-1056] -         Required Connector Properties Should Have A Default Value If They Are Marked As An Expert Property
    • [TEIID-1057] -         Calling getRequests() on RuntimeEngineDeployer Results in MethodNotFound
    • [TEIID-1063] -         PropertyDefinition.getPropertyTypeClassName() Should Always Return A Java Class Name
    • [TEIID-1065] -         PropertyDefinition.getDisplayName() Should Agree With The Display Name Shown In JON
    • [TEIID-1067] -         Managed connector  connection factory always closes the physical connection.
    • [TEIID-1072] -         XML-Relational connector sometimes uses same ResponseOut/ResponseIn value for different web service queries
    • [TEIID-1073] -         Logging not working in Teiid Jopr Plugin
    • [TEIID-1076] -         When running BQT tests, an Assertion error is seen when batches are being processed
    • [TEIID-1083] -         When running either control at the vdb level while the vdb is being access produces an exception
    • [TEIID-1084] -         Exception in BatchIterator
    • [TEIID-1085] -         AdminShell (Groovy) shows connectionName even after that connection has been disconnected
    • [TEIID-1086] -         Possible missing I18N bundle for AdminShell
    • [TEIID-1088] -         AdminShell deployVDB method prepends the path to server's deploy directory to VDB location
    • [TEIID-1094] -         XML literal input to HTTP-SOAP connector is being URL encoded
    • [TEIID-1100] -         Teiid Examples run.sh should be executable when extracted from archive
    • [TEIID-1101] -         Teiid Example PortfolioDS specifies a username & password for Derby source where none is required
    • [TEIID-1108] -         Receiving NPE when querying DynamicPortfolio VDB with more complicated query
    • [TEIID-1109] -         NPE Connecting to a Teiid DataSource (XA) Without Setting Expected Properties
    • [TEIID-1110] -         NPE Connecting to a Teiid DataSource (XA) as Anonymous User
    • [TEIID-1115] -         java.lang.IllegalStateException: Failed to find template for: translator-file  while attempting to call Admin.getTemplatePropertyDefinitions("file")
    • [TEIID-1116] -         AdminConsole for DataServices indicates, by default, that SSL Enabled is true, but the teiid-jboss-beans.xml indicates sslEnabled is false
    • [TEIID-1117] -         When VDBis deleted the cached medata files are not cleaned up
    • [TEIID-1119] -         Trying to add new functions to be supported by a new connector and the Connector developers guide refers to the JDBCCapabilities class, which doesn't exist anymore.  Have the steps changed to add a new scalar function?
    • [TEIID-1121] -         Fix the migrate utility for the Translator changes
    • [TEIID-1122] -         attempting to getTemplatePropertyDefinitions() for the DefaultDS or JMSDS are throwing Admin AdminComponentException exceptions. They need to get filtered out on API calls for Data Source info.
    • [TEIID-1125] -         Re-connecting proxy may lead to error in execution
    • [TEIID-1126] -         Web Service VDB Execution Error
    • [TEIID-1127] -         java.lang.ClassCastException Executing Virtual Procedure from Web Service Model
    • [TEIID-1128] -         Invalid Resolver Error
    • [TEIID-1129] -         Unable to execute SQL Queries through VDB's with more than one model in it from Designer/DTP
    • [TEIID-1130] -         NPE when using exportVDB from adminshell
    • [TEIID-1132] -         Teiid Kit missing SalesForce JAR
    • [TEIID-1133] -         Error creating SSL Socket Factory for client invoker: Error initializing socket factory SSL context: Can not find truststore url.
    • [TEIID-1135] -         NPE when getting RowCount for SalesForce (from SQuirreL)
    • [TEIID-1136] -         MySql_5.0 OUTER JOIN - Unexpected Query Results 

     

            Feature Request

    • [TEIID-145] -         Parse double quoted literals as identifiers by default
    • [TEIID-150] -         Improve nested loop (in merge join) matching
    • [TEIID-153] -         Support IS NULL criteria in the xml connector
    • [TEIID-155] -         Revisit TransformationMetadataFacade cache sizes
    • [TEIID-159] -         Modify our handling of BigDecimal division to use MathContext.DECIMAL128 as our rounding mode to improve scale and precision of results
    • [TEIID-162] -         Delete and update support in temp table
    • [TEIID-165] -         Connector support for more converts
    • [TEIID-171] -         Add SQL/XML support
    • [TEIID-173] -         ProductAdmin role can deploy a vdb but cannot create connector bindings
    • [TEIID-180] -         Consider using Salesforce retrieve() rather than generic query() call for queries with IN criteria
    • [TEIID-183] -         user "or" and "in" criteria should generate multiple queries in some situations
    • [TEIID-186] -         Expose catalog information and props in Connector API metadata [PEC]
    • [TEIID-207] -         Forward and Backward Compatibility of MetaMatrix JDBC Driver
    • [TEIID-208] -         LDAP Connector should implement Connection.isAlive(), in order to properly report connection status when monitored
    • [TEIID-216] -         Query timeout should be enforced by the server
    • [TEIID-222] -         Procedural relational execution should support disjunctive criteria
    • [TEIID-236] -         Procedural access pattern
    • [TEIID-249] -         Need well-known multi-payload container
    • [TEIID-251] -         Support SQL 2003 order by with expressions
    • [TEIID-367] -         Add a validation step to security provider definition.
    • [TEIID-371] -         System state should reflect the state and allow start/stop/restart of Membership Domains
    • [TEIID-404] -         1-way and 2-way SSL to MMx must support different keystore file names within a cluster
    • [TEIID-533] -         HostController Process is redundent and should be removed
    • [TEIID-750] -         Add more filtering in the internal processing of queries so that hidden items do not requires fully qualified names to be used
    • [TEIID-807] -         Develop the new Teiid Console using JOPR for its core framework
    • [TEIID-822] -         Add hsql translator
    • [TEIID-833] -         Support tighter integration with container deployments
    • [TEIID-844] -         Implement metadata creation in the SalesForce connector.
    • [TEIID-845] -         AdminShell needs to be able to produce and display a Query Plan
    • [TEIID-851] -         API improvements for custom connector development
    • [TEIID-873] -         Add support for quoted identifier aliases
    • [TEIID-881] -         SOAP Connector should expose property to control HTTP Header Transfer-Encoding: chunked
    • [TEIID-891] -         Add JDBC import logic to correct unsigned types
    • [TEIID-897] -         Create a new autowrap mode to replace pessimistic/optimistic
    • [TEIID-900] -         Refine option no cache behavior
    • [TEIID-906] -         Add support for a set statement
    • [TEIID-943] -         Fully implement client streaming of lobs/readers/streams
    • [TEIID-963] -         Need to add XPath 2.0 support for services in and out of MM
    • [TEIID-966] -         User (principal) name in MetaMatrix should be consistently the same string
    • [TEIID-980] -         Add ability to apply XSLT stylesheets at the datasource level
    • [TEIID-1003] -         Connector api language changes
    • [TEIID-1005] -         Update reserved words
    • [TEIID-1007] -         Remove unnecessary inline views over group bys
    • [TEIID-1019] -         Request ability to turn on/off Auto Staging tables
    • [TEIID-1021] -         Enable better support for mixed database encoding
    • [TEIID-1029] -         Provide sample scripts that show the use of the AdminAPI in an alternative scripting manner
    • [TEIID-1033] -         Add state to request metadata
    • [TEIID-1039] -         Provide a solution to  'merge' two VDBs
    • [TEIID-1040] -         Refine client control of query plans
    • [TEIID-1045] -         Provide a admin method to "export" a Data Source.
    • [TEIID-1052] -         Replace beanshell based adminshell with Groovy
    • [TEIID-1062] -         Expose the Teiid Runtime Version as a ManagedOperation/ManagedProperty
    • [TEIID-1071] -         Modify validation errors element in schema for VDB configuration file to include attribute for location of error
    • [TEIID-1075] -         Separate Connector Binding into Translation Layer and Connection Layer
    • [TEIID-1097] -         Add support for nested table references
    • [TEIID-1102] -         Create a replacement for the text translator
    • [TEIID-1105] -         Add Translator Instance Information from the VDB to the VDB Configuration Tab
    • [TEIID-1112] -         Add getRequestsForVDB() Method on RuntimeEngine
    • [TEIID-1118] -         Provide alternative webservices calling ability

     

            Quality Risk

    • [TEIID-254] -         Metadata query for procedure columns needs work
    • [TEIID-853] -         Dynamic command projection should be positional
    • [TEIID-869] -         Clean up metadata
    • [TEIID-874] -         Wiki documentation on SSL Encryption is misleading
    • [TEIID-880] -         SQL Server uniqueidentifier handling
    • [TEIID-915] -         Error results in illegalstateexception
    • [TEIID-916] -         Initial client socket timeout is too low under load
    • [TEIID-918] -         Change all package names to org.teiid
    • [TEIID-926] -         Reduce use of map look ups for projection
    • [TEIID-1001] -         Source string format for float/double/bigdecimal/timestamp can vary
    • [TEIID-1004] -         Check for common math exceptions
    • [TEIID-1012] -         Update logging contexts
    • [TEIID-1015] -         Move threading concerns to the engine
    • [TEIID-1016] -         Include documentation about system properties in server configuration
    • [TEIID-1018] -         Review all translator properties
    • [TEIID-1020] -         Remove the use of Teiid specific JDBC extensions

     

            Task

    • [TEIID-278] -         Upgrade Axis2 to Axis2 1.4
    • [TEIID-673] -         Need to Document Alternate Means of Achieving Web Services and XML Usage Scenarios for Teiid
    • [TEIID-790] -         Teiid Server uses Sun JDK specific JMX server, thus portability to other JDKs is not possible
    • [TEIID-854] -         Remove the legacy "server" project from the SCM
    • [TEIID-868] -         Simplify handling of parse format date/time functions
    • [TEIID-878] -         Fix capabilities caching
    • [TEIID-902] -         Restructure planning
    • [TEIID-912] -         Add unit test methods from JBEDSP-1137: StackOverflowError when top level query uses the same symbol name and group alias that is in a second level query or sub-query
    • [TEIID-913] -         Refine buffer management
    • [TEIID-927] -         Remove the legacy JDBC Datasource and Driver classes
    • [TEIID-990] -         Remove the Axis library dependency on the XML Connectors
    • [TEIID-995] -         The management console should support deploying VDB to EDS
    • [TEIID-1002] -         Remove unnecessary sandbox connectors
    • [TEIID-1023] -         Chanage "MaxResultRows" Connector Property to default to "unlimited"
    • [TEIID-1026] -         Refine plan/annotation logic
    • [TEIID-1037] -         Document execution properties in the client developers guide.
    • [TEIID-1041] -         Create a CTC kit to be used to deploy Teiid/EDS query testing across all supported platforms in the Hudson QA Lab
    • [TEIID-1050] -         Update the build process to use new Nexus Maven repository
    • [TEIID-1074] -         Make VDB work with Model based index files
    • [TEIID-1098] -         Add Long Running Query Limit Property to Teiid Engine Managed Component
    • [TEIID-1099] -         Update Jopr Plugin to Use Long Running Query Property and Method on Teiid Engine
    • [TEIID-1111] -         Add Teiid Version to Summary Page of Engine Resource in Teiid Jopr Plugin
    • [TEIID-1120] -         Provide single HTML page for all the documents
    • [TEIID-1124] -         Confusion with "java:" prefix in the DataSource from tooling
    • [TEIID-1134] -         For salesforce adapter to work the following JAR need to be added. This needs to be documented

     

            Thirdparty Change

    • [TEIID-938] -         MySql queries pushed down to the source producing error:  Invalid conversion from type class com.metamatrix.common.types.BlobType with value 'javax.sql.rowset.serial.SerialBlob@1b1395dc' to type class java.lang.Character

     

            Sub-task

    • [TEIID-137] -         Remove the HTTPClient Usage from the XML Connector and use the Common XML Connector
    • [TEIID-138] -         Convert Common XML Connector to Axis2
    • [TEIID-143] -         Query should 'find' connector types and jars rather than have them predefined in the config.
    • [TEIID-199] -         Integration with JBoss Identity project
    • [TEIID-218] -         Security URL properties handling
    • [TEIID-315] -         Add JDBC Connector developers guide
    • [TEIID-396] -         Authorization Provider can not deleted using the Admin API
    • [TEIID-429] -         Use DataSources in creating the ConnectorBindings instead of creating one using the Driver
    • [TEIID-441] -         Expand the requires restart property
    • [TEIID-464] -         Shared Installation Option
    • [TEIID-502] -         Allow Multiple UDF Definition Models
    • [TEIID-674] -         Document/test a Means of Top-down WSDL Consumption
    • [TEIID-675] -         Document/test a Means of Bottom-up Web Services in Teiid
    • [TEIID-676] -         Document/test a means of creating service that executes ad-hoc SQL commands inTeiid
    • [TEIID-678] -         Document/test Alternative Means to Achieve Current XML Document Scenarios
    • [TEIID-781] -         Move the CTC testing framework to the teiid community
    • [TEIID-782] -         Add the ability to test transactions to CTC testing client
    • [TEIID-788] -         Change internal handling of insert with query expression
    • [TEIID-789] -         Provide JMX access from remote computers
    • [TEIID-808] -         Revisit the prior issues with extending the JOPR JMX plugin and verify if the problems have been fixed
    • [TEIID-838] -         Runtime discovery of VDBs
    • [TEIID-859] -         Connector API must extend the JCA 1.5 API
    • [TEIID-861] -         All Teiid Connectors  must be modified and packaged as JCA Connectors.
    • [TEIID-862] -         Teiid engine needs to be exposed as a JCA Connector
    • [TEIID-863] -         Remove Trusted payload, credential map for authenticating connector sources
    • [TEIID-864] -         Need new deployment packing that works with JBoss AS or JBoss Embedded
    • [TEIID-870] -         Standardize the JDBC metadata
    • [TEIID-871] -         Refactor system vdb
    • [TEIID-877] -         Membership Domain Documentation is Out of Date
    • [TEIID-883] -         Convert model/group/element to schema/table/column
    • [TEIID-884] -         Calling restart on adminapi throws an exception
    • [TEIID-907] -         Add a sample connector template for starting a new connector development
    • [TEIID-910] -         Convert the Admin API implemention based on Profile Service
    • [TEIID-924] -         Remove metadataobjects
    • [TEIID-944] -         Provide a separate Admin connection
    • [TEIID-997] -         Investigate adding new metrics that added value for the user to monitor their servers
    • [TEIID-998] -         Define a new schema based VDB deployer xml (previously defined by ConfigurationInfo.def)
    • [TEIID-1013] -         Load the UDF based on the information provided in the vdb.xml
    • [TEIID-1017] -         Move defining the Data Roles to VDB deployer XML file. Map the roles to container roles
    • [TEIID-1024] -         Support conversion between clob and sql/xml
    • [TEIID-1032] -         Change nomenclature of "Connector Binding" to "Connection Factory"
    • [TEIID-1068] -         Provide a single Connector, that represents the DS and Teiid Connector for JDBC sources.
    • [TEIID-1069] -         Admin API Data Source method are not needed
    • [TEIID-1077] -         Split all Connector projects to define their "Translator" modules and "Connection" modules
    • [TEIID-1078] -         Build annotation based configuration for the Connector Translation layer
    • [TEIID-1079] -         Provide deployer for the Translation Layer components.
    • [TEIID-1080] -         Change Admin API, to support the Translation Layer and Connection layer concepts.
    • [TEIID-1081] -         Provide pre built "Translator" for all the popular data sources
    • [TEIID-1087] -         Add Function to Extract fragments from XML
    • [TEIID-1089] -         Combine the ExecutionFactory and Capabilities class into single class
    • [TEIID-1113] -         Change Get Request for VDB Operation to Call getRequestsForVDB() on the RuntimeEngine
    • [TEIID-1114] -         Add support for xmltable

     

    Documentation and Help

    The Teiid community project is hosted on jboss.org. Documentation and help may be obtained from the distribution under teiid-docs or the following locations.

     

    Licenses

    Teiid is licensed under the LGPL. The license texts for Teiid and the thirdparty components it uses may be found in the teiid-docs/licenses directory of the distribution.

    About JBoss, a division of Red Hat

    JBoss, a division of Red Hat, is in the business of providing superior technical support to our customers. Our goal is to make Professional Open Source™ the SAFE CHOICEfor you. We accomplish this by backing up our open source Java products with technical support services that are delivered by the core developers themselves. We can help you to train your staff and provide you with support at every stage of the application lifecycle - from development and integration through deployment and maintenance. Visit the JBoss Services page for more information.