Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi
how to connect oracle database in qlikview .
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)
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.
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)