How to access data from Teiid virtual table from SQL BI / SQL Server Management Studio

gvarghese1993 Aug 21, 2016 10:01 AM

We have few Oracle clinical data repository - once I virtualize the data from these three different application data system to the Data Virtualization platform.

Is it possible that I can consume the virtual tables in my BI platform which is based on MS SQL 2016 platform.

Also our users will like to run queries from the SQL Management studio adhoc queries.

1. Re: How to access data from Teiid virtual table from SQL BI / SQL Server Management Studio

rareddy Aug 21, 2016 10:57 AM (in response to gvarghese1993)

Once you build the virtual database that contains three different data systems in Teiid (note: there is no copying of the data, data stays still in your original data sources) then you can access the Virtual Database in Teiid from your BI tool using the JDBC/ODBC protocol. Teiid provides drivers for both.
Actions