With teiid can we integrate a product on cloud and a product on premise?I know with web services its possible .But webservice would run slow to extract data and Teiid is a VDB where during the run time it hits the underlying queries which makes it slow .Does cache mechanism in this scenerio would support ?
Do we have any other option that can be leveraged in case of performance.
Thanks in advance.
You have multiple caching options. Out of the box we have result set caching for user query and internal/external materialization for views. You can also use a customization at the translator level to control source query result caching. Start with the Caching Guide - https://docs.jboss.org/author/display/TEIID/Caching+Guide