Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
what type of connectivity it is.
if it is jdbc then hown can i import to qv with the below credintials
site.db.url=jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=nqhau99032(PORT=15073))(CONNECT_DATA=(SERVICE_NAME=OENKIOW)))
site.db.user=xyz
site.db.password=12345
can somebody help me how to retrive this data into qv
Hi,
usually you can configure this connection in the file tnsnames.ora. If you have installed Oracle ODBC driver you can use this connection as datasource then.
If you like to use the JDBC driver the connect string would be like this:
jdbc:oracle:thin:@nqhau99032:15073/OENKIOW // host:port:sid or host:port/service
You can also take a look here: http://www.orafaq.com/wiki/JDBC
- Ralf
Hi Shree
Yes this is JDBC Oracle Thin URL connection for making a connectity with this data base please refer following link
http://community.qlik.com/docs/DOC-2438
Thanks
Vikas
Hi vikas i referred the link and downloaded the connectivity but when i am passing the values its not taking .
can u help me how to set the values with the above values..
Hi,
usually you can configure this connection in the file tnsnames.ora. If you have installed Oracle ODBC driver you can use this connection as datasource then.
If you like to use the JDBC driver the connect string would be like this:
jdbc:oracle:thin:@nqhau99032:15073/OENKIOW // host:port:sid or host:port/service
You can also take a look here: http://www.orafaq.com/wiki/JDBC
- Ralf
hi rafael thaanks for the reply
i configured in the TNS names.ora and it works ..
Thank you all for the answers