Wesley Backelant on 24 Apr 2015 20:45:13
Since more and more customers are probably going to have hybrid environments with on-premises, Azure and AWS combined I think S3 connectivity would make sense too
- Comments (5)
RE: Allow connection to AWS S3
I'm surprised actually that no connector exists to get data directly from an AWS S3 Bucket. Was a little dumbfounded that it does not exist. My guess is Microsoft does not play well with Amazon.
RE: Allow connection to AWS S3
ZappySys has ODBC Driver for XML/JSON API which can be used to pull data directly from AWS S3 or other AWS API (e.g. Athena, EC2, Billing API). See below Post
https://zappysys.com/blog/read-amazon-s3-data-power-bi-aws-json-xml-api/
RE: Allow connection to AWS S3
https://aws.amazon.com/about-aws/whats-new/2017/11/amazon-athena-adds-support-for-querying-data-using-an-odbc-driver/?nc1=h_ls
RE: Allow connection to AWS S3
This is do-able today with AWS API Gateway and a Lambda function.
1. Create a new Lambda Function ... it can be empty for now
2. Set up a new API in API Gateway
3. Create a new GET method
3.1 Select Lambda Function for the integration type
3.2 Select the Use Lambda Proxy integration option
3.3 Select the region and type in the name of the lambda function you created in step 1
4. Edit your lambda function.
4.1 Using the AWS SDK, generate a url w/ pre-signed key for your file
4.2 Return a 303 redirect to the url from step 4.1
Here is a sample of a lambda function in python 2.7:
bucket = 'bucket-name'
key = 'path-to-file'
client = boto3.client('s3')
link = client.generate_presigned_url(
'get_object',
{'Bucket': bucket, 'Key': path},
7200, 'GET')
return {
"statusCode": 303,
"headers": {'Location': link}
}
RE: Allow connection to AWS S3
We need this desperately at our client right now.