-
1. Re: How to connect to Teiid VDB through Linux server ?
rareddy Feb 29, 2016 9:03 AM (in response to ravindra_singh)Please let me know if we have any better way of connecting and pulling data from Teiid.
Teiid supports
- JDBC
- ODBC
- OData
as standard ways to connect, just like any other database. There are tools like SquirreL that let you use JDBC protocol to connect.
If you are looking for command line based tool, Teiid has "AdminShell", which uses Groovy based scripts to connect and access the VDB. Checkout https://teiid.gitbooks.io/documents/content/admin/AdminShell.html
-
2. Re: How to connect to Teiid VDB through Linux server ?
ravindra_singh Mar 1, 2016 12:32 AM (in response to rareddy)Hi Ramesh,
Thanks for your reply. Actually i am looking for process setup which can be accessed from my existing Linux server as my other connection and data resides there.
I found below link which i am trying and see if it works.
-
3. Re: How to connect to Teiid VDB through Linux server ?
ravindra_singh Mar 1, 2016 7:59 AM (in response to rareddy) -
4. Re: How to connect to Teiid VDB through Linux server ?
shawkins Mar 1, 2016 11:58 AM (in response to ravindra_singh)This doesn't seem to be hitting Teiid at all. Do you have another odbc data source, such as a local postgresql that you can test with to first ensure that the unixODBC and the odbc driver are installed correctly?
-
5. Re: How to connect to Teiid VDB through Linux server ?
ravindra_singh Mar 2, 2016 6:44 AM (in response to shawkins)I tried with other driver and now getting below error
cdtscmn100d:cmndusr:/development/cmn/exe> isql -v ConnTeiid soamgr SOAP@55w0rd
[28000][unixODBC]Unexpected protocol character='
[ISQL]ERROR: Could not SQLConnect
-
6. Re: How to connect to Teiid VDB through Linux server ?
shawkins Mar 2, 2016 2:17 PM (in response to ravindra_singh)> I tried with other driver and now getting below error
What other driver?
Also it looks like in your config that you are trying to hit the JDBC port. Our pg/odbc port it 35432 by default.
-
7. Re: How to connect to Teiid VDB through Linux server ?
ravindra_singh Mar 3, 2016 5:12 AM (in response to shawkins)I have been provided with below JDBC connection string only to connect with source VDB. Requirement is to connect and pull the data from VDB.
"jdbc:teiid:ImputationV1_DEV@mm://cdtXXXXX.rxcorp.com:31000"
Do i need to do anything else to connect to that?
-
8. Re: How to connect to Teiid VDB through Linux server ?
rareddy Mar 3, 2016 5:18 AM (in response to ravindra_singh)As Steve mentioned you need to use 35432 as port number in your ODBC configuration.
-
9. Re: How to connect to Teiid VDB through Linux server ?
ravindra_singh Mar 3, 2016 6:39 AM (in response to rareddy)I tried with below Port change, but the command execution just hang.. No response
[ConnTeiid]
Driver = /usr/lib64/psqlodbc.so
Description = PostgreSQL Data Source
Servername = 162.44.115.213
Port = 35432
UserName = soamgr
Password = SOAP
Database = ImputationV1_DEV
ReadOnly = no
ServerType = Postgres
ConnSettings =
UseServerSidePrepare=1
ByteaAsLongVarBinary=1
Optimizer=0
Ksqo=0
Trace = No
TraceFile = /var/log/trace.log
Debug = No
DebugFile = /var/log/debug.log
-
10. Re: How to connect to Teiid VDB through Linux server ?
rareddy Mar 3, 2016 6:48 AM (in response to ravindra_singh)Did you start the server with
standalone.sh -b 162.44.115.213 -c standalone-teiid.xml
-
11. Re: How to connect to Teiid VDB through Linux server ?
ravindra_singh Mar 3, 2016 7:15 AM (in response to rareddy)Checked from Teiid side. and it is working
-
12. Re: How to connect to Teiid VDB through Linux server ?
m.ardito Mar 18, 2016 9:31 AM (in response to ravindra_singh)Hi,
if this can help I use this setup from linux (mint 32bit) and it works.
=====================================
$ cat ./.odbc.ini
[teiid_db]
Description = PostgreSQL Unicode
Driver = /usr/lib/i386-linux-gnu/odbc/psqlodbcw.so
Trace = No
TraceFile =
Database = databasename
Servername = 192.168.x.y
Username = username
Password = password
Port = 35432
Protocol = 7.4-1
ServerType = Postgres
ReadOnly = No
ShowSystemTables = No
ShowOidColumn = No
FakeOidIndex = No
UseServerSidePrepare =1
ByteaAsLongVarBinary =1
UpdatableCursors =0
ConnSettings =
Optimizer =0
Ksqo =0
Debug =0
Fetch = 10000
UseDeclareFetch =1
=====================================
Marco
-
13. Re: How to connect to Teiid VDB through Linux server ?
ravindra_singh May 3, 2016 3:28 AM (in response to m.ardito)Hi Marco,
I am still not able to connect.
Not sure what is wrong.
Do we have any other way apart from this?
-
14. Re: How to connect to Teiid VDB through Linux server ?
rareddy May 3, 2016 3:57 AM (in response to ravindra_singh)What is the error you are seeing? Try iSQL with -v option. Are there any errors on server log.