topic Convert Excel Connection String to Qlikview Connection String in QlikView

Convert Excel Connection String to Qlikview Connection String

Anonymous — Tue, 13 Jun 2017 13:28:52 GMT

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

Anonymous — Tue, 13 Jun 2017 13:34:47 GMT

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 — Tue, 13 Jun 2017 13:41:32 GMT

see Gysbert's response here