topic Re: how to connect in oracle database? in QlikView

how to connect in oracle database?

gkcchowdary — Sun, 29 Mar 2015 07:57:10 GMT

how to connect oracle database in qlikview .

Re: how to connect in oracle database?

MK_QSL — Sun, 29 Mar 2015 07:59:55 GMT

You can connect to oracle database through ODBC or OLEDB connectivity.

For ODBC Connectivity

Create the DSN.

In the File---Edit Script ----choose the ODBC option and select the DSN u have created.

For OLE DB Connectivity you can

In the File---Edit Script ----choose the OLEDB option and choose the Oracle driver (Oracle provider for OLE DB) and provide the Source details and credentials.

Before proceeding this ensure that necessary drivers are installed.

Re: how to connect in oracle database?

maxgro — Sun, 29 Mar 2015 09:42:32 GMT

usually

oracle

install oracle client (32 or 64, depends on your hardware)

setup oracle client (tnsnames)

test connection to oracle database

qlikview

open qlikview script editor

if you want to use odbc (other way is oledb)

setup odbc (32 or 64, depends on your oracle client) in script editor, rmenù, tools --> odbc administrator

add system dsn

this can help: The Great ODBC Confusion

choose oledb or odbc, choose 32 or 64 (depending on oracle client)