You can translate the question and the replies:

Custom Driver stored procedure's not listed

Hi, I am writing a Generic JDBC driver to load inside denodo. The driver loads fine but I dont see my stored procedures returned by DatabaseMetaData. They do show up in my other DB tools like dbever. Any insight is really appreciated. Thanks Anish
user
21-04-2020 15:54:58 -0400

1 Answer

Hi, I have found it is best to try to use one of our non-generic drivers first if possible. You can import stored procedures graphically if you are using IBM DB2, Microsoft SQL Server, or Oracle data sources. These procedures are documented in the [Importing Graphically Stored Procedures from a Database](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_data_sources_and_base_views/jdbc_sources/jdbc_sources#importing-graphically-stored-procedures-from-a-database) section in the Virtual DataPort Administration Guide. You can also create a [JDBC Base Views from a SQL query](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_data_sources_and_base_views/jdbc_sources/jdbc_sources#creating-base-views-from-a-query-to-a-stored-procedure) to invoke a stored procedure. Hope this helps!
Denodo Team
22-04-2020 17:30:01 -0400
You must sign in to add an answer. If you do not have an account, you can register here