MySQL Connection to Qlik sense (call Store Procedure)

[Anonymous]

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.

[thakkarrahul01]

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

[Anonymous]

Hi Rahul,

I have already tried this one.

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

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

Thanks.

[thakkarrahul01]

Can you try like -

LIB CONNECT TO 'Your_Connection';

Load

          *;

SQL CALL test_proc ;

[Anonymous]

I have tried your script.

I am getting this error .

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

[thakkarrahul01]

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