Home » ODBC PowerPack » ODBC App Integration » Reporting - Tableau

Tableau Parameters – Fix Metadata / Dynamic SQL Columns Issue

Posted on November 5, 2018November 7, 2018 by ZappySys

Introduction Many time you have to use Dynamic SQL in your Stored Procedure but some tools (e.g. Tableau) may reject it because metadata is not returned when sp_describe_first_result_set is called in SQL Prepare phase. You may see error like below in that case. Metadata Prepare Call

exec sp_describe_first_result_set N'EXEC [dbo].[usp_GetInvoicesByCountry] @country=''Germany'''

1	exec sp_describe_first_result_set N'EXEC [dbo].[usp_GetInvoicesByCountry] @country=''Germany'''

Error due to Dynamic SQL Msg […]

Import REST API in Tableau – Read JSON, SOAP XML, CSV

Posted on November 4, 2018June 4, 2019 by ZappySys

Introduction Tableau is one of the most popular Reporting / Visualization tool for BI / Data analytics. It comes with many out-of the box connectors to pull data from some popular data sources but still it seriously lakes capability to consume data from millions of other REST / SOAP data sources out there for which […]