You can translate the question and the replies:

Access to data sources on S3

Hi. Several days ago I started to test Denodo Standard 8.0 (free trial) for learning yours platform on AWS. And now when I try to connect S3 file system for my test cluster I have such problems (https://community.denodo.com/kb/view/document/How%20to%20integrate%20Amazon%20S3%20with%20the%20Denodo%20Platform?category=Data+Sources): 1. Approach with REST AIP is not ok for me, because of requirements to refres signature and timestamp periodicaly (each 15 minutes). 2. Approach "with Denodo Distributed File System Custom Wrapper" also can not be ussed because I can not login to "https://support.denodo.com/" for loading of wrapper for s3. If I try to get data without such wrapper I recive error "Error while executing custom wrapper method 'getSchemaParameters': No FileSystem for scheme "s3"" Could yo please to provide information how I can connect to S3 bucket for reciveing source data in Denodo. (WIthiout requirement to update connection setings each 15 minutes.) Thanks in advance.
user
14-04-2021 09:34:00 -0400
code

1 Answer

Hi, As mentioned in the [How to integrate Amazon S3 with the Denodo Platform](https://community.denodo.com/kb/view/document/How%20to%20integrate%20Amazon%20S3%20with%20the%20Denodo%20Platform?category=Data+Sources) knowledge base article, I was able to access Amazon S3 from Denodo using both the options i.e Denodo Distributed File System Custom Wrapper available at the Denodo Support Site and Rest API options. For your scenario, you can try accessing/configure the S3 from Amazon Athena. Once you are able to establish connection successfully and query data from S3 files using Amazon Athena, you can connect to Athena datasource using the native Amazon Athena database adapter (JDBC data source) available in Virtual DataPort server. You can refer to [Supported JDBC Data Sources](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/appendix/supported_jdbc_data_sources/supported_jdbc_data_sources#supported-jdbc-data-sources) section of the Virtual DataPort Administration Guide which provide details about lists of databases for which Virtual DataPort provides a specific JDBC adapter. Hope this helps!
Denodo Team
21-04-2021 23:41:07 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here