Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
shoaib986
Contributor

Convert Excel Connection String to Qlikview Connection String

Hi All,

This is the oracle connection string in excel pivot table. How can i convert it to Qlikview?

CONNECTION STRING:

DRIVER={Oracle in OraClient11g_home1};

SERVER=XXX;UID=XXX;PWD=XXX;DBQ=XXX;

DBA=W;APA=T;EXC=F;XSM=Default;FEN=T;QTO=T;FRC=10;FDL=10;LOB=T;RST=T;

BTD=F;BNF=F;BAM=IfAllSuccessful;NUM=NLS;DPM=F;MTS=T;MDI=Me;CSR=F;FWC=F;FBS=60000;TLO=O;MLD=0;ODA=F;

COMMAND TEXT:

SELECT *

FROM "TABLE1" 

UNION ALL   SELECT * FROM "TABLE2"

Thanks

Shoaib

2 Replies
shoaib986
Contributor

Re: Convert Excel Connection String to Qlikview Connection String

I can connect directly thru Excel Power Query or Power BI by just providing three credentials that is Server Name, User ID and password.

vinieme12
Esteemed Contributor II

Re: Convert Excel Connection String to Qlikview Connection String

see Gysbert's response here

How to create ODBC connection to Oracle