Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Now i am facing an issue, i need to connect database (ORACLE SQL DEVELOPER).
I never used before, I tried with OLEDB in Qlikview but i am not able to connect.
How can i connect Sql developer with Qlikview
Please help
Thanks
wht is the issue ur getting when ur using OLEDB connection?
Hi,
I selected "Microsoft OLEDB provider for Oracle" under Data link Properties option.
But it is not connecting. "Microsoft OLEDB Provider for SQL Server" which one i need to select.
Please let me know
there is document on this link,u can follow that.
Hi Thank you for your help,
the document is so helpfull. but i installed oracle SQL Developer and i can able to run the queries in SQL Developer.
But in Qlikview Edit Script-->Tools
The options " ODBC Administractor 64-bit and 32 bit both are in disable. Now i am not able to connect.
Pls tell me is there any thing to do to enable the options
Are you able to create DSN in ODBC Data Source Administrator?
if u want to use ODBC connection instituted of OLEDB,then u have to create ODBC connection from control panel first.
u can check for the steps on community for the ssame.
If not, please create User DSN in ODBC Data Source Administrator, which can be accessed from QlikView.
C:\Windows\SysWOW64\odbcad32.exe
Thanks,
Vinod Kumar V
Have you installed the ODAC (Oracle Data Access Components) for your version of Oracle? this should be available to you from the Oracle Metalink website.
Once you have downloaded it you need to install it.
You should then have the option for Oracle Provider for OLE DB in QlikView.
Hope this helps,
Gethyn.
hi,
First install the Oracle driver
>then go to edit script
>tools
> and add the system DSN
>here your new driver should be visible , if not please check the driver installation .
>Once the DSN is added , in the Edit script select the OLEDB connection then provide your credential and test the connection