Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Anonymous
Not applicable
Author

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
Champion III
Champion III

see Gysbert's response here

How to create ODBC connection to Oracle

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.