4 Replies Latest reply on Dec 8, 2015 12:34 PM by davidsrz

Create conexion from any db to teiid (JDV)

lvsmix Jul 31, 2015 1:53 PM

Hi Everody:

I would like to ask you if I can create any conexion from any database for example Oracle (db link) to Teiid Server.

Thanks you so much for your answer...

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