You can translate the question and the replies:

Custom wrapper development

Hi Team, I am developing a custom wrapper internally it calls sql server database for data and sends this data to rest api and it returns data after some manipulation this data I need in denodo so the custom wrapper is dependent upon sql driver jar and I am using apache http components jar for rest api call and json to covert data to json format. My question is do I need to import all custom wrapper I jar I developed and dependency jars also in denodo through jar managment becuase If I am placing dependency jars in <DENODO_HOME>/extensions/thirdparty/lib it giving me error when executing base view.
custom wrapper
user
28-05-2021 01:56:34 -0400
code

3 Answers

Hi, In Denodo 8, the JDBC driver of MS SQL server is already available in the Denodo installation folder <Denodo_Home>\lib\extensions\jdbc-drivers, hence I would refer to this driver while developing the custom wrapper instead of importing it along with custom wrapper jar file. When You could refer to the section [Required Libraries to Develop Custom Wrappers](https://community.denodo.com/docs/html/browse/8.0/en/vdp/developer/developing_extensions/developing_custom_wrappers/required_libraries_to_develop_custom_wrappers#required-libraries-to-develop-custom-wrappers) of Virtual DataPort Developer Guide and section [Final Steps](https://community.denodo.com/docs/html/browse/8.0/en/denodo4e/reference/deploy/deploy_wizard/deploy_wizard#final-steps) of Denodo4Eclipse Plugin Guide to know more about handling dependent jar files when developing custom wrapper. In any case if you still need help and If you are a valid support user then you can raise a support case on [Denodo Support Site](https://support.denodo.com/) so that our support team can help you. Hope this helps
Denodo Team
28-05-2021 08:14:46 -0400
code
Thank you for your answer. We are using denodo 7.0 and I am using other dependacies also httpcore-4.4.4.jar, json-simple-1.1.1.jar and httpclient-4.5.3.jar is there any other alternative for these jars in denodo lib.
user
29-05-2021 05:54:49 -0400
Hi, When the developed custom wrapper is dependent on third party libraries I would do any one of the following : * Copy the required jars to the directory <DENODO_HOME>/extensions/thirdparty/lib. * Copy the contents of the required jars into the jar that contains the custom wrapper. * Import the third-party jar files into Virtual DataPort ( by clicking on Extension Management available in File menu of Virtual DataPort Administration tool). Then, when creating a new custom data source from the Virtual DataPort Administration tool, I would ensure to choose the jar with the custom wrapper and the imported external jars. You could refer to the section [Final Steps](https://community.denodo.com/docs/html/browse/7.0/denodo4e/reference/deploy/deploy_wizard/deploy_wizard#final-steps) of Denodo4E User Guide and [Importing Extensions](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/importing_extensions/importing_extensions#importing-extensions) of Virtual DataPort Administration Guide for more information. Hope this helps.
Denodo Team
07-06-2021 08:56:43 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here