Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Stored Procedure in Qlik View

Hi All,

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.

Regards and Thank you in Advance,

im_ps 🙂

 

 

1 Solution

Accepted Solutions
Highlighted
Creator III
Creator III

Re: Stored Procedure in Qlik View

try to create a connection from create connection button in load script, click on test connection and see what the error is.

Can be anything from server not in domain, wrong authentication, db doesn't exist etc etc

View solution in original post

2 Replies
Highlighted
Creator III
Creator III

Re: Stored Procedure in Qlik View

The code you posted is a connection string to a db.

Is this the db you want to work with?

Have you ever worked with a relational db and SQL?

Father/Husband/BI Developer
Highlighted
Creator III
Creator III

Re: Stored Procedure in Qlik View

try to create a connection from create connection button in load script, click on test connection and see what the error is.

Can be anything from server not in domain, wrong authentication, db doesn't exist etc etc

View solution in original post