Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

shree909
Valued Contributor II

what type of connectivity it is.?

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=jdbcSmiley Surprisedracle: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

1 Solution

Accepted Solutions
MVP
MVP

Re: what type of connectivity it is.?

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:

jdbcSmiley Surprisedracle:thin:@nqhau99032:15073/OENKIOW  // hostSmiley Tongueort:sid or hostSmiley Tongueort/service

You can also take a look here: http://www.orafaq.com/wiki/JDBC


- Ralf

4 Replies
vikasgupta
Contributor

Re: what type of connectivity it is.?

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
Valued Contributor II

Re: what type of connectivity it is.?

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

MVP
MVP

Re: what type of connectivity it is.?

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:

jdbcSmiley Surprisedracle:thin:@nqhau99032:15073/OENKIOW  // hostSmiley Tongueort:sid or hostSmiley Tongueort/service

You can also take a look here: http://www.orafaq.com/wiki/JDBC


- Ralf

shree909
Valued Contributor II

Re: what type of connectivity it is.?

hi rafael thaanks for the reply

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

Thank you all for the answers

Community Browser