I understand that you created a base view using GET_JDBC_DATASOURCE_TABLES successfully but could not pick up your custom stored procedures. The SQL Server stored procedures work but the Denodo Stored procedures are returning incomplete results.
The way that the stored procedure pulls the information is through introspecting the metadata of the source. Some of that metadata seems to be unavailable for the stored procedures you developed in SQL Server, and so the Denodo stored procedures aren't detecting them.
Since you have a valid support user account, please open a new support case at [Denodo Support Site](https://support.denodo.com) so that the support team can review the issue in detail.
Hope this helps!