what type of connectivity it is.?

[shree909]

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

[vikasgupta]

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

[shree909]

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

[rbecher · Accepted solution]

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

[shree909]

hi rafael thaanks for the reply

i configured in the TNS names.ora  and it works ..

Thank you all for the answers