This content has been marked as final.
Show 4 replies
-
1. Re: Create conexion from any db to teiid (JDV)
rareddy Jul 31, 2015 3:07 PM (in response to lvsmix)You can create a connection from Teiid Server to Oracle. Not from Oracle to Teiid Server.
-
2. Re: Create conexion from any db to teiid (JDV)
lvsmix Jul 31, 2015 4:29 PM (in response to rareddy)Ok, in fact (I'm using SQL SERVER, Oracle was just an example) I would like to know if it's posible to have a linked server in SQL SERVER to teiid server/JDV.
So I can make a query in sql server that calls both tables from the database and view models from teiid. Can you show me any example?
-
3. Re: Create conexion from any db to teiid (JDV)
rareddy Jul 31, 2015 5:53 PM (in response to lvsmix)No, SQL Server ----> Teiid not supported.
Yes, Teiid ---> SQL Server
Examples: Data Federation Example - Teiid Examples - Project Documentation Editor
-
4. Re: Create conexion from any db to teiid (JDV)
davidsrz Dec 8, 2015 12:34 PM (in response to lvsmix)Hi I created a dblink in Oracle and I can do queries from toad to teiid I used ODBC connection with postgrest driver for making the dblink, you can to try it.
Have a nice day.