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?
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**]( 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**]( 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
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](, [GRANT/REVOKE]( and [CREATE 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.
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