You can translate the question and the replies:

OData connect --- works with Tableau

I can connect successfully to a SAAS app using the following end point via Tableau https://jnj.leanix.net/services/import-export/v1/odata/BookmarkService.svc/ this only requires user name as apitoken and then the Api key as the password. Is there a way to replicate this call via Denodo so I can ingest the data as a view? I have tried to do this unsucessfully using the OData2 and OData4 connectors that are availalbe on our platform.
user
10-04-2022 16:37:34 -0400
code

1 Answer

Hi, In order to connect to the API call from Denodo with the authentication based on Access key and Secret Key parameters.You could follow the below mentioned steps: * Create a new JSON source by navigating to File > New > Data source > JSON * Select HTTP Client as a Data route and click on configure. * In the configuration tab, click on HTTP headers and add the necessary headers along with below headers: * X-APIKeys: accessKey=<ACCESS_KEY_VALUE>; secretKey=<SECRET_KEY_VALUE> * content-type: application/json * accept: application/json * Click on the test connection * Click Ok and save the data source. * After saving the datasource you can create a new base view over that JSON data source * Now, you should be able to see the data as a view as you expected For more information, you can refer to the section [JSON](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/creating_data_sources_and_base_views/json_sources/json_sources) sources under the Denodo Virtual DataPort Administration Guide. In case you need any further assistance and if you have a valid Support Account then you can reach out to Denodo Support by raising a support case on Denodo Support Site and the Support Team will assist you. Hope this helps!
Denodo Team
12-04-2022 10:01:17 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here