You can translate the question and the replies:

Connect to Denodo from Lambda

Hello, I need to get the view and its information in one of the Lambda function built on AWS Lambda. I tried the below link but it says about the ODBC and JDBC connections but since the Lambda is serverless, can we have a connection to Denodo from Lambda in any other way? https://community.denodo.com/kb/view/document/How%20to%20connect%20to%20Denodo%20from%20Python%20-%20a%20starter%20for%20Data%20Scientists?tag=Northbound+Connections
user
11-02-2021 09:32:49 -0500

5 Answers

Hi, Denodo provides a way to access the view as “**REST**” or “**RESTful**” API from an end consuming application. To access the views of Denodo from AWS Lambda other than “**JDBC**” or “**ODBC**” connections, I would make a call to the [**RESTful web service**](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/restful_architecture/restful_web_service/restful_web_service) which is an HTTP service auto-deployed in Denodo that publishes the contents of the entire Virtual DataPort server or access the views published as the [**REST web service**](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/publication_of_web_services/publishing_rest_web_services/publishing_rest_web_services) of Denodo from AWS Lambda. For instance, to get the view using the web services I would provide “**HTTP method**” as “**GET**” and “**URI**” as mentioned below in the lambda function built on AWS Lambda: For "**RESTful**" web service, the “**URI**” to access the view is http://localhost:9090/denodo-restfulws/<database_name>/<view_name>. whereas for "**REST**" web service, the “URI” to access the view is http://localhost:9090/server/<database_name>/<webservice_name>/views/<view_name>. Hope this helps!
Denodo Team
12-02-2021 07:13:43 -0500
Hello Team, Sorry if I have not put my sentence right. We need to create a connection to denodo from Lambda to create a view, Assign userroles etc. While trying to do that, we are having troubles making the connection to Denodo
user
19-02-2021 10:13:47 -0500
Hi, AWS Lambda provides various runtimes and among which the Java is also available as a execution engine. I would create a Lambda Function with JDBC to connect to the Virtual DataPort Server, once done, its only a matter of executing the right VQL Statements like [CREATE USER](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/creating_databases_users_roles_and_access_privileges/managing_users/managing_users), [GRANT/REVOKE](https://community.denodo.com/docs/html/browse/latest/en/vdp/vql/creating_databases_users_roles_and_access_privileges/managing_users/modifying_the_privileges_of_a_user#modifying-the-privileges-of-a-user) and [CREATE VIEW](https://community.denodo.com/docs/html/browse/latest/en/vdp/vql/defining_a_derived_view/defining_a_derived_view#defining-a-derived-view) to create and assign privileges to the users and views. Hope this helps!
Denodo Team
04-03-2021 06:28:01 -0500
Thanks for your response. "I would create a Lambda Function with JDBC to connect to the Virtual DataPort Server" This exactly is what I am seeking your help here. How do we create a Function with JDBC.
user
04-03-2021 07:50:00 -0500
Hi, Currently, there’s an enhancement request to have the Denodo JDBC driver support for connecting from the AWS Lambda which is in the roadmap. In case, 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
29-03-2021 06:44:00 -0400
You must sign in to add an answer. If you do not have an account, you can register here