You can translate the question and the replies:

account rules

We're going to make a release, but found that it cannot chose stored procedure publishing, Is this a account permission problem? How can I set it?
user
14-04-2022 02:47:24 -0400
code

1 Answer

Hi, In general, Virtual DataPort allows users to create base views over stored procedures using the **Create Selected** option only for databases such as **IBM DB2, Microsoft SQL Server and Oracle**. For creating base views over stored procedures in **other databases**, you could use the **Create from query** option. After a base view is created over a stored procedure, you could **[publish](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/publication_of_web_services/publication_of_web_services#publication-of-web-services)** that base view as a **web service** to the end users. You could take a look at the [Importing Graphically Stored Procedures from a Database](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/creating_data_sources_and_base_views/jdbc_sources/jdbc_sources#importing-graphically-stored-procedures-from-a-database) and [Creating Base Views from SQL Queries](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/creating_data_sources_and_base_views/jdbc_sources/jdbc_sources#creating-base-views-from-sql-queries) sections of the Virtual DataPort Administration Guide for more information. Hope this helps!
Denodo Team
19-04-2022 08:23:21 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here