Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

sindhu_ibizcs
Contributor

MySQL Connection to Qlik sense (call Store Procedure)

Hi All,

We were trying to Connect the MySQL in Qliksense. I couldn't able to connect .I want to call the store procedure through MySQL database.

When i using MySQL enterprise it shows some "General ERROR".

By using ODBC , i Can connect "LIB CONNECT TO 'Test,;" But couldn't able to call Store Procedure.


Thanks in advance. can anyone know the script to call the SP.

5 Replies
thakkarrahul01
Contributor

Re: MySQL Connection to Qlik sense (call Store Procedure)

Hi Sindhu,

Can you try this -

LIB CONNECT TO 'Your_Connection';

Load

          *;

SQL EXEC test_proc ;

Please share details, if this doesn't help.

Regards,

Rahul

sindhu_ibizcs
Contributor

Re: MySQL Connection to Qlik sense (call Store Procedure)

Hi Rahul,

I have already tried this one.

MySql.PNG

I am facing this error , When i use MySQL Enterprise.

So I have Connected through ODBC Connection.I am getting below error.

ODBC MySQL.PNG

Thanks.

thakkarrahul01
Contributor

Re: MySQL Connection to Qlik sense (call Store Procedure)

Can you try like -

LIB CONNECT TO 'Your_Connection';

Load

          *;

SQL CALL test_proc ;

sindhu_ibizcs
Contributor

Re: MySQL Connection to Qlik sense (call Store Procedure)

I have tried your script.

I am getting this error .MySQL 2.PNG

Can you help me to resolve. I have searched lots of things but couldn't help.

thakkarrahul01
Contributor

Re: MySQL Connection to Qlik sense (call Store Procedure)

So we are now able to call SP although arguments are missing, Please refer below links to pass arguments as per your need. To start with you can pass hardcoded values to test.

QlikView integration with Oracle Stored procedure FAILS in fetching data and inserting data to oracl...

Calling Stored Procedure in Qlikview

Stored Procedure | Qlik Community

Hope this helps.

Regards,

Rahul

Community Browser