[teiid-issues] [JBoss JIRA] Closed: (TEIID-684) Dynamic data integration feature (Integrate data with out a VDB)

Dynamic data integration feature (Integrate data with out a VDB) ---------------------------------------------------------------- Key: TEIID-684 URL: https://jira.jboss.org/browse/TEIID-684 Project: Teiid Issue Type: Feature Request Components: Connector API, Query Engine Reporter: Ramesh Reddy Assignee: Steven Hawkins Priority: Critical Fix For: 6.2.0 This is feature request for dynamically integrating the data with out any modelling exercise, so that any tooling is not required before you can start integrating data. Using this feature, the user would create/define a Connectors (data sources) in the Teiid runtime engine, and then user connects to runtime engine using the JDBC driver provided, then he/she can start writing SQL queries that spans multiple data sources in a single statement as if they are single source. For example: Data Source: A has TableA1 TableA2 DataSource: B has TableB1 TableB2 user can write SQL queries such as SELECT A.TableA1.e1, A.TableA1.e2, B.TableB1.e1, B.TableB1.e2 FROM A.TableA1, B.TableB1 WHERE A.TableA1.e1 = B.TableB1.e1 They can much more complex join queries than above too.