Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I can connect directly thru Excel Power Query or Power BI by just providing three credentials that is Server Name, User ID and password.
see Gysbert's response here
How to create ODBC connection to Oracle