how to connect in oracle database?

[gkcchowdary]

hi

how to connect oracle database in qlikview .

[MK_QSL]

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.

[maxgro · Accepted solution]

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)