Integration of Denodo with AWS S3 bucket

Question

Have a requirement to read data from Denodo (Data virtualization) tool to AWS S3 bucket. Has anyone done such integration. If so, what is the best practice/process to integrate Denodo with AWS S3 bucket. Any insight is appreciated.

Thanks.

Answer 1

If you really want to read from denodo and write to S3, you need another tool to run this task. Denodo is "just" a database. You can query denodo via JDBC or ODBC like any other database.

For example use python + sqlalchemy (https://community.denodo.com/docs/html/document/denodoconnects/8.0/en/Denodo%20Dialect%20for%20SQLAlchemy%20-%20User%20Manual) to query data from denodo. Your python program has to write the data to AWS S3 afterwards. You could use boto3 python-package to write to S3.

Answer 2

It's my understanding that you're looking to integrate Denodo with AWS S3.

You can achieve this by using the Denodo Distributed File System Custom Wrapper.

For detailed steps, please refer to the official documentation on connecting to an AWS S3 bucket from the Denodo Platform here.

Hope this helps!