topic Re: How to Connect Oracle 12c to QvScriptor.. in QlikView

How to Connect Oracle 12c to QvScriptor..

sravan_v007 — Thu, 27 Feb 2014 07:10:29 GMT

Hi All,

if any one can provide a document on How to Connect Oracle 12c to QvScriptor..

actually i tried connecting but i am not able to see the data. Please find the attached document from QvScriptor.

Re: How to Connect Oracle 12c to QvScriptor..

Thu, 27 Feb 2014 07:18:08 GMT

In server Name Use

(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST ="Server Address")(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SID = test)))

Re: How to Connect Oracle 12c to QvScriptor..

jpk — Thu, 27 Feb 2014 13:54:52 GMT

Hi Sravan

If you are using QVScriptor then below is you answer.

You use the normal connections wizard but you put the Schema information for you Oracle DB ODBC in the field – without owner you won’t see anything.

Database File Connections

With DB’s like Oracle you generally have a file (TSnames.ora) with all connection information so you set up the standard ODBC connection once this file has been configured, you then connect to the ODBC connection via QVSClient.

Once you create the connection you can go to Schema field and add the owner there, QVSClient will then connect to the Oracle source and show all tables and views – without owner you won’t see anything.

PS: you can find the UserGuide from FILE - Support tabs