I am trying to use Stored Procedure from SQL Server in Qlik View. Went through different Links in the Qlik Community, but wasn't much helpful.
Tried using the below code but Db was not getting connected:
OLEDB CONNECT TO [Provider=SQLOLEDB.1; Persist Security Info=True; User ID=sa; Initial Catalog=DB_9B08BD_automobile; Data Source=localhost; Use Procedure for Prepare=1; Auto Translate=True; Packet Size=4096; Workstation ID=DEVELOPER-PC; Use Encryption for Data=False; Tag with column collation when possible=False] (XPassword is EOIeQYIGTBNKDbEF);
As I am new to QlikView can someone help me with this.