You can translate the question and the replies:

Getting the Source Tables and columns for non-JDBC datasources

Hi Denodo Team, For the views created from JDBC datasource in denodo I am able to get the source tables by using the default procedure GET_SOURCE_TABLES(). But when I use the same procedure to get the underlying source table information for the datasources like DF(ex: csv) or SAPBWBAPI, Denodo is throwing error. So I want to know is there any other function or procedure to get the source tables and columns for the above mentioned datasource types in denodo. If there are no predefined function/procedure please let me know how to query them. I am even curious to know how and where denodo is persisting the metadata of datasources in denodo. Your help is highly appreciated. Thanks, Kranthi kiran.

1 Answer

Hi, If you want to use GET_SOURCE_TABLE, the base view has to be a JDBC base view, which I found the description in the link below . [GET_SOURCE_TABLE](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/stored_procedures/predefined_stored_procedures/get_source_table) I went through the user manual and figured that those data-source-related stored procedures are only for JDBC sources. Hope this helps!
Denodo Team
08-06-2021 09:36:53 -0400
You must sign in to add an answer. If you do not have an account, you can register here