Teiid

Teiid 8.5 Alpha1 for EAP 6.1.Alpha (which is basically the same as AS 7.2) is now available in our downloads .  The feature highlights are: TEIID-2528 Encrypted Buffer Files - the buffer manager now supports an option to encrypt Teiid temp data files using 128-bit AES. TEIID-2249 TEIID-2559 TEIID-2555 Dependent Join Enhancements - greater control over full depdendent join pushdown has been added including make dep hint options max and min to control the extent of depdendent join pushdown. The join hint is also available to pushdown the entire dependent join when supported by the source. TEIID-2527 Configurable Runtime Multisource - the server will now allow multisource models to have sources added and removed at runtime. See the admin addSource and removeSource methods. It is still early in the release cycle, so there will be more refinements, documentation, and enhancements for dependent joins coming.    And of course there is still plenty of time to log enh...

In case you haven't heard, networking  giant CISCO systems on Thursday June 20th, 2013 announced that it is buying Composite Software http://www.zdnet.com/cisco-to-acquire-composite-software-for-180m-7000017085/ for $180 Million This acquisition highlights the growing interest in the Data  Virtualization market by customers that vendors are trying to fill. The phrase Enterprise Information Integration ( EII ) was first introduced by MetaMatrix (which is predecessor for Teiid http://teiid.org ) back in 2000 and was first entrant into the market. Composite Software soon joined ranks of EII vendors and quickly established itself as a fierce competitor. MetaMatrix was acquired by Red Hat in 2007.  Red Hat initiated the process to open source the MetaMatrix software as it does with all acquired code that's not yet open. The Teiid community project was born out of these effort in January 2009.  On the path to open source, we took the opportunity to step back, re-ev...

Do need to access a web-service from Teiid, that implements WS-Security? Please check out this blog for an example by  David Hauser http://davidatbig.blogspot.ca/2013/06/creating-jboss-enterprise-data-services.html Ramesh..

Are you planning on migrating your relational database data in Oracle, MS-SQL, MySQL, DB2, PostgreSQL etc., into MongoDB for scalability and performance reasons? Or you want to use MongoDB for your new project, but not do not want to spend too much time learning MongoDB APIs? However, you are a seasoned SQL developer? Or you have data in databases, CSV files and other applications that you need to integrate together and store in MongoDB and do further analysis? If "Yes", please keep reading... If you have previously attempted at migration of data yourself, I am sure you may have come across these below links before. http://docs.mongodb.org/manual/reference/sql-comparison/ http://docs.mongodb.org/manual/reference/sql-aggregation-comparison/ http://docs.mongodb.org/manual/tutorial/model-embedded-one-to-one-relationships-between-documents/ http://docs.mongodb.org/manual/tutorial/model-referenced-one-to-many-relationships-between-documents/ http://docs.mongodb.org/...

In keeping with our 3 month release window we are proud to announce our next time boxed release - Teiid 8.4.Final . Here are top three (3) features: The deployment platform is upgraded to EAP 6.1 Alpha . You can also use  EAP 6.1 Final , but you need a developer subscription from Redhat. For the difference between community and subscription version see  http://www.redhat.com/products/jbossenterprisemiddleware/community-enterprise/ . If you have concerns about switching from JBoss AS 7.1.1 to EAP please read http://www.jboss.org/jbossas/faq Pluggable row and column based security. Read more about it:  https://docs.jboss.org/author/display/teiid84final/Data+Roles Support for MongoDB . Use Teiid and its SQL language to access the data from MongoDB. This release includes a new MongoDB translator and resource adapter. Read more about it: https://docs.jboss.org/author/display/teiid84final/MongoDB+Translator .  More blogs coming on this soon. Here is complete...

For that matter you can expose any data source that is supported by Teiid through its translators as OData service. You can convert Relational databases XML, JSON, CSV files Web Services  Sales Force Excel documents sources, or write your on top of your specific source. Teiid added support for exposing its virtual database (VDB) as OData service without any additional work. Create a virtual database with your required sources and create any additional views and deploy in the the JBoss EAP 6.1 server, that has Teiid 8.3 or greater installed.  See https://docs.jboss.org/author/display/teiid84final/OData+Support  for more information. So, lets build a simple example of exposing the Excel Sheet. Teiid accesses Excel sheets via JDBC-ODBC bridge, and Windows OS provides a ODBC driver for Excel documents.  Edit the standalone-teiid.xml, and create Connection Factory jdbc:odbc:Driver={Microsoft Excel Driver (*.xls)};Dbq=c:\ODBC\ExcelDat...

Teiid 8.4 CR1 for EAP 6.1.Alpha* is now available in our downloads .  The new features Beta2: TEIID-2504 Improved socket results processing large results processing over a socket transport have been significantly improved for forward only results. Scrollable results will have only a marginal improvement. TEIID-2427 TEIID-2311 Column Masking added column masking and refined row-based security. Also allow for permissions to be granted via the MetadataFactory methods addPermission and addColumnPermisison to enable adding roles via a MetadataRepository. Additional web service security features and mongo connectivity have made it into 8.4 and will be fully doc'ed and in the release notes by the next CR/Final. If needed we will produce a CR2 in approximately 10 days and will generally be selective about what issues get released before the Final.  Beyond the 8.4 Final we now have the 8.4.1 and 8.5 release version targets active to take additional issues. *And now mo...