Connect Qlik with SQL Stored Procedure

Wed, 08 Jul 2015 12:28:45 GMT

Hi,

I have some problem for connect Qlik with SQL Store Procedures. I have developed two SP and Qlik only works with on of this two.

EXECUTE [Demo Database NAV (8-7)].[dbo].NAVConnectorUnshared @TableName = 'Customer', @TableFields = '[No_],[Name]';

EXECUTE [Demo Database NAV (8-7)].[dbo].NAVConnectorShared @TableName = 'Company', @TableFields = '[Name],[XRT]';

In the attached picture you can see the result of the SP, apparently the results are correct. The select that SP genetares are these:

SELECT 'COPIA' AS COMPANY,[No_],[Name] FROM [Demo Database NAV (8-7)].[dbo].[COPIA$Customer] UNION SELECT 'CRONUS España S.A.' AS COMPANY,[No_],[Name] FROM [Demo Database NAV (8-7)].[dbo].[CRONUS España S_A_$Customer]

SELECT [Name],[XRT] FROM [Demo Database NAV (8-7)].[dbo].[Company]

In Qlik View I have writte the next code:

OLEDB CONNECT TO [Provider=SQLOLEDB....-

CLIENTES2:
LOAD *;
SQL EXECUTE [Demo Database NAV (8-7)].[dbo].NAVConnectorUnshared @TableName = 'Customer', @TableFields = '[No_],[Name]';

EMPRESAS2:
LOAD
Name as Nombre,
XRT as Tesorería;
SQL EXECUTE [Demo Database NAV (8-7)].[dbo].NAVConnectorShared @TableName = 'Company', @TableFields = '[Name],[XRT]';

When I run the script no error message appears but when I try to select the table only the table EMPRESA2 appears. Where is the table CLIENTES2?

Thanks for your help.

topic Connect Qlik with SQL Stored Procedure in QlikView

Connect Qlik with SQL Stored Procedure