topic Connect to Oracle database in QlikView

Connect to Oracle database

Tue, 17 Nov 2009 19:34:05 GMT

Hello,

my first step to connect QV to an oracle database.

The database is an tdb on a server, using oracle 10g.

What is the right way to connect:

OLE DB or ODBC.

By using OLE DB there is the Microsoft OLE DB Provider for Oracle and the Oracle Provider for OLE DB.

in both I can define the database but not the server-field is unelectable.

By using the ODBC I can't see any tables or views, so I think I did something wrong by define server and database.

Is there an example?

Regards

Martin

Connect to Oracle database

Tue, 17 Nov 2009 20:10:48 GMT

To be honest, I don't know exactly, what is the best choice.

OLEDB is supposed to be more recent than ODBC.
Personaly I used to create an Oracle connexion a few weeks ago, I used the Microsoft OLE DB Provider for Oracle.
But I could change the server name on the first configuration windows

Hopes it helps

Regards

Connect to Oracle database

Bill_Britt — Tue, 17 Nov 2009 21:02:08 GMT

You will need to install the Orcale client from Orcale.

AW:Re: Connect to Oracle database

Tue, 17 Nov 2009 21:08:16 GMT

I've got it.

The important thing is to configure the database as server/database.location

AW:Re: Connect to Oracle database

Tue, 17 Nov 2009 22:24:26 GMT

Dear Martin

I did it without any problem but as metionned, you need to install the client and be sure the TNSName.ora is properly configured.

To test, just create an ODBC and test with user and password the connection with the Test button. If this is working, then use the odbc ( I don't have any preference, but I used ODBC as it was working at first shot)

Rgds,

AW:Re: Connect to Oracle database

Tue, 24 Nov 2009 20:31:35 GMT

Hi,

I´m using an ODBC as connector to an Oracle database.

We are running the jobs via QMC but now and then the jobs doesn´t run. The same job works fine one night but stops another.

If I reload the job manually I´m asked to verify the Userid & passw and then the job is running.

Any idea anybody?

Thanks!

Johan

AW:Re: Connect to Oracle database

Tue, 24 Nov 2009 20:58:43 GMT

Are you sure the password you used in your qvw is correct ?

Did you try to rewrite the connection string with the correct password ? (using the wizard) ?

Usually login windo appear when Qlikview is not able to connect correctly.

Rgds,

Sébastien

AW:Re: Connect to Oracle database

Tue, 24 Nov 2009 21:07:01 GMT

I guess that the password is correct since I only confirm it with the OK button when it pops up.

To be honest I copy / past the syntax for the ODBC connections (with the auto generated parameters for user id and pw) between my applications.

I´ll try manually add it application by application.

Thanks!

Johan

AW:Re: Connect to Oracle database

Tue, 24 Nov 2009 21:16:03 GMT

You're welcome, but normally just copying the CONNECT string between application works...

Keep us informed on your results.