You can translate the question and the replies:

Interface and source mapping for NON-JDBC data source.

Need to get the mapping between interface and source views and respective columns. Able to achieve this for the JDBC source using the metadata procedure - GET_SOURCE_TABLE(). Unable to achieve this for the SAP BAPI source. Need to flatten the BAPI after the base view created to see all the columns. Is there anyway I can get this info ? Kindly suggest. Thanks !
user
09-06-2021 03:36:52 -0400
code

1 Answer

Hi, As mentioned in the[ GET_SOURCE_TABLE](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/stored_procedures/predefined_stored_procedures/get_source_table) section of the Virtual DataPort VQL Guide, the GET_SOURCE_TABLE() stored procedure returns information only about the source of a JDBC base view. However, you can develop a [Custom Stored Procedure](https://community.denodo.com/docs/html/browse/8.0/en//vdp/developer/developing_extensions/developing_stored_procedures/developing_stored_procedures) in Java using the Denodo4E Plugin such that it returns information about the source of non JDBC base view.. Once the stored procedure is created, you can import the jar file into the Virtual DataPort Server using the ‘File -> Extensions Management’ option available in the Virtual DataPort Administration Tool. You could refer to the Custom Stored Procedure samples available under the directory “<DENODO_HOME>\samples\vdp\storedProcedures’’ and take a look at the README file for testing it. In case, if you still need help and if you are a valid Support User, you may open a Support Case at the Denodo Support Site and the Support Team will help you. Hope this helps!
Denodo Team
09-06-2021 08:08:46 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here