You can translate the question and the replies:

Example Denodo Stored Procedure to interact with SQL Server Stored Procedure

Hi, Denodo Where can I find some example denodo stored procedures to takes some input parameters to feed into an MS SQL server stored procedure(not regular SQL scripts) that does some analysis and returns a table, for joining with other denodo base views? Also do you have training materials for the Java developer training if you're not doing the training anymore? Please also suggest any other relavant training. https://www.denodo.com/en/services/education/course/den60edud04/data-virtualization-java-developer Thanks, Renhai
user
12-12-2018 09:51:52 -0500

3 Answers

Hi, You can[ Execute a SQL server stored procedure using Denodo](https://community.denodo.com/kb/view/document/Creating%20views%20on%20SQL%20Server%20Functions%20and%20Stored%20Procedures?category=Data+Sources). The link mentioned before will let you pass the required parameters and get the resultant table from the stored procedure and create a base view which can be used for further processing. With Denodo you can also create stored procedures which is mentioned in [this post](https://community.denodo.com/answers/question/details?questionId=9060g000000fz3NAAQ&title=Store+procedure). Note: Sample Java Programs for Denodo Stored Procedures are available under <DENODO_HOME>\samples\vdp\storedProcedures of your installation. About the training materials, I think you can utilize our Online documentation: [Virtual DataPort Developer Guide](https://community.denodo.com/docs/html/browse/7.0/vdp/developer/index#virtual-dataport-developer-guide) and the[ Virtual DataPort API](https://community.denodo.com/docs/html/browse/7.0/vdp/javadoc/index) Java documentation, which will provide you with more knowledge on Java which includes custom functions, developing stored procedures and custom wrappers. We are also progressing towards preparing new free tutorials for creating custom components and it will be available in our Denodo Community Site. Hope this helps
Denodo Team
17-12-2018 09:28:24 -0500
Hi, Sorry, it doesn't help. Basically execution status interger is what a stored procedure returns in MS SQL Server. Unless you show me the tricks to tweak it in SQL Server, I see no way denodo can show the stored procedure return type as a table. https://community.denodo.com/answers/question/details?questionId=9060g000000L7E3AAK&title=Unable%20to%20create%20base%20view%20from%20stored%20procedure%20-%20SQL%20Server
user
17-12-2018 16:18:15 -0500
Hi, I have successfully imported a stored procedure using the links mentioned above along with a small modification: when creating a base view, I checked the 'Steam output at result set' checbox and input the index as 1. This resulted in the completed table to be imported in Denodo. Please refer to the **Importing Stored Procedures from Microsoft SQL Server** section on this Link [link.](https://community.denodo.com/docs/html/browse/6.0/vdp/administration/creating_views/importing_data_sources_and_creating_base_views/jdbc_sources#importing-stored-procedures-from-microsoft-sql-server) Hope this helps
Denodo Team
27-12-2018 16:37:43 -0500
You must sign in to add an answer. If you do not have an account, you can register here