You can translate the question and the replies:

Issues connecting Amazon S3 bucket with Denodo VDP

Hi team, I'm trying to connect Denodo and retrieve CSV files from a S3 Bucket. I have followed all the steps provided in this article: https://community.denodo.com/kb/view/document/How%20to%20integrate%20Amazon%20S3%20with%20Denodo%20Distributed%20File%20System%20Custom%20Wrapper?category=Data+Sources I can configure the new custom wrapper, and also create the corresponding data source but, when I try to create a Base View, I'm receiving the following error: There was an error while creating this base view: Error while executing custom wrapper method 'getSchemaParameters': Error accessing HDFS file: s3bucketseat: org.apache.hadoop.fs.s3a.auth.NoAuthWithAWSException: No AWS Credentials provided by SimpleAWSCredentialsProvider EnvironmentVariableCredentialsProvider InstanceProfileCredentialsProvider : com.amazonaws.SdkClientException: Unable to load credentials from service endpoint Could you please help with this? Thanks in advance!
user
10-07-2020 07:29:07 -0400
code

3 Answers

Hi, I've seen this error when connecting to my S3 buckets when my authentication to AWS needs to be configured. You'll need to use the AWS Console to get your Access KeyID and Secret Access Key and configure them in the /conf/core-site.xml file included in the HDFS custom wrapper. There is a helpful video [How to connect to AWS S3 from Denodo Platform](https://community.denodo.com/videos/details/Cloud/Denodo%207.0/How%20to%20connect%20to%20AWS%20S3%20from%20Denodo%20Platform) on our Community Site that shows how to set this up. More details are in the [Denodo Distributed File System Custom Wrapper - User Manual](https://community.denodo.com/docs/html/document/denodoconnects/7.0/Denodo%20Distributed%20File%20System%20Custom%20Wrapper%20-%20User%20Manual). Also, when configuring S3 buckets, I've also found using the [S3 browser tool](https://s3browser.com/) useful. Hope this helps!
Denodo Team
10-07-2020 13:15:02 -0400
code
Thanks for your answer. After configure the core-site.xml file, included on the package downloaded (I was using a different one), with both acces key and secret access key, I'm getting a new error. Denodo tries to create the base view during 1 min and after that, it triggers the following error message: There was an error while creating this base view: Error while executing custom wrapper method 'getSchemaParameters': Error accessing HDFS file: doesBucketExist on s3bucketseat: com.amazonaws.SdkClientException: Unable to execute HTTP request: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target: Unable to execute HTTP request: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target Could you please help with this? Thanks in advance!
user
13-07-2020 03:22:15 -0400
Hi, When I've seen this error, it usually means you need to import a SSL certificate into the Denodo truststore. You can also use a third party tool like [S3 browser tool](https://s3browser.com/) to verify your connection to rule out other possible issues. Steps to follow to add the certificate can be found in the Knowledge Base article [Adding client certificate to connect to remote server](https://community.denodo.com/kb/view/document/Adding%20client%20certificate%20to%20connect%20to%20remote%20server?category=Security) and Importing the Certificates of Data Sources (SSL/TLS Connections) section of the Denodo Platform Installation Guide. Hope this helps!
Denodo Team
21-07-2020 18:06:42 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here