You can translate the question and the replies:

GET_JDBC_DATASOURCE_TABLES equivalent to get Stored Procedures

We automated our base view creation from a SQL Server using Denodo GET_JDBC_DATASOURCETABLES stored procedure. Unfortunatly, this process ignores the few SQL Server custom stored procedures that we would also like to import in Denodo. Is there a way around this? Another predefined stored procedure that would allow us to get the SQL Server stored procedure. Thank you
user
09-06-2022 16:23:15 -0400

1 Answer

Hello, 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!
Denodo Team
10-06-2022 16:57:56 -0400
You must sign in to add an answer. If you do not have an account, you can register here