topic Re: Oracle SQL Developer Connection in QlikView

Oracle SQL Developer Connection

Wed, 24 Jun 2015 11:53:57 GMT

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

Re: Oracle SQL Developer Connection

buzzy996 — Wed, 24 Jun 2015 12:46:09 GMT

wht is the issue ur getting when ur using OLEDB connection?

Re: Oracle SQL Developer Connection

Tue, 30 Jun 2015 10:46:20 GMT

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

Re: Oracle SQL Developer Connection

buzzy996 — Tue, 30 Jun 2015 10:52:29 GMT

there is document on this link,u can follow that.

OLEDB Connection

Re: Oracle SQL Developer Connection

Tue, 30 Jun 2015 11:34:49 GMT

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

Re: Oracle SQL Developer Connection

Tue, 30 Jun 2015 11:38:56 GMT

Are you able to create DSN in ODBC Data Source Administrator?

Re: Oracle SQL Developer Connection

buzzy996 — Tue, 30 Jun 2015 11:42:29 GMT

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.

Re: Oracle SQL Developer Connection

Tue, 30 Jun 2015 11:43:07 GMT

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

Re: Oracle SQL Developer Connection

Gethyn — Tue, 30 Jun 2015 11:54:28 GMT

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.

Re: Oracle SQL Developer Connection

avinashelite — Tue, 30 Jun 2015 12:03:31 GMT

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

Re: Oracle SQL Developer Connection

maxgro — Tue, 30 Jun 2015 12:55:20 GMT

maybe Oracle sql developer doesn't use OLEDB or ODBC

Qlikview uses OLEDB or ODB to connect to Oracle database

Re: how to connect in oracle database?

Re: Oracle SQL Developer Connection

Gethyn — Tue, 30 Jun 2015 13:05:50 GMT

Oracle SQL Developer is the Oracle equivalent to Microsoft SQL Management Studio, so I doubt that he wants to connect QlikView to that.

I have assumed that he wants to connect QlikView to the same Oracle database that he has connected to with Oracle SQL Developer.

Re: Oracle SQL Developer Connection

ger_alegria — Tue, 30 Jun 2015 13:31:43 GMT

You need to install the oracle client or ODAC (Oracle Data Access Componet), with this you will have able the option of Oracle Provider for OLE DB in Qlikview.