Home » ec2

Read Amazon S3 data in Power BI or Call AWS REST API (JSON / XML)

Posted on June 15, 2018November 20, 2019 by ZappySys

Introduction If you are looking around to find connectivity options to get Amazon AWS data in Power BI (e.g. Read from Amazon S3 files (CSV, JSON, XML) or get AWS API data such as Billing Data by calling REST API) then unfortunately as of now Power BI doesn’t support it natively. In this article, you will […]

How to call Amazon AWS API using SSIS (EC2, Lambda, API Gateway, SQS)

Posted on November 3, 2017November 2, 2021 by ZappySys

Introduction In this blog post you will learn how to call Amazon AWS API using SSIS (virtually any API) without a single line of code (No more JAVA, C#, Ruby, Python). Yes you heard it right 🙂 . If you are a SSIS / ETL Developer or even coder everyone loves drag & drop interface. SSIS […]