Skip to main content
Announcements
Get Ready. A New Qlik Learning Experience is Coming February 17! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
sravan_v007
Partner - Contributor III
Partner - Contributor III

How to Connect Oracle 12c to QvScriptor..

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.

2 Replies
Not applicable

1.jpg2.jpg3.jpg

In server Name Use

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

jpk
Partner - Creator II
Partner - Creator II

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