I am trying to create a base view from a stored procedure in a data source that is a SQL Server 2014 database. However, when I browse to the stored procedure from the data source in the Denodo client (6.x), the stored procedures show a return value of:
@RETURN_VALUE (NOT NULL) : int
@TABLE_RETURN_VALUE (NOT NULL) : table
This is causing the view schema to get generated with just a single column (int) instead of the columns returned by the stored procedure result set.
What am I doing wrong?