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.
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.