Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
In server Name Use
(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST ="Server Address")(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SID = test)))
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.
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