This content originally appeared on DEV Community and was authored by Daniel ZS
If you need to access AWS REST API data in tools like Power BI, Excel, Informatica, or MS Access but don't want to dive into coding, this guide is for you.
We'll show you how to use the ZappySys ODBC JSON Driver to capture AWS CLI output and feed it into your ODBC-enabled apps - quickly and easily.
✅ Bonus: If you prefer a low-level method without AWS CLI, we've covered that too in the full version of this guide.
Requirements
Before you begin, make sure you have:
✔️ Installed the AWS CLI
✔️ Downloaded ZappySys ODBC PowerPack
[✔️ Set up a new ODBC DSN with ZappySys JSON Driver]
Step-by-Step Setup
- Open the ODBC Data Source Admin Open the Start menu, search for "ODBC", and launch ODBC Data Source (64-bit).
- Add a New DSN In the System DSN tab: Click Add Select ZappySys JSON Driver Click Finish
🎯 Need screenshots and DSN examples? View the full guide here
🔍 Query AWS API Data Without Writing Code
Here's a sample query to preview patch data from AWS SSM:
SELECT * FROM "$"
WITH(
Src='cmd:>aws ssm describe-available-patches --no-verify-ssl',
"Filter"='$.Patches[*]'
)
You can apply similar logic to retrieve EC2 instance data, CloudWatch metrics, or anything else supported by AWS CLI.
Want to load this data into Power BI or Excel? We've got the exact steps for that too.
👉 Continue to the full tutorial with screenshots and query examples
🎥 Bonus: Video Tutorial
Prefer watching over reading?
🎬 Check out our video: How to read and write AWS REST API data using the ZappySys ODBC Driver.
👉 Watch the video and get started
✅ Conclusion
The ZappySys JSON Driver makes it incredibly easy to query AWS REST APIs from any app that supports ODBC. From Power BI dashboards to Excel spreadsheets - your data is just one query away.
💡 For more examples, advanced filter logic, and update support -
👉 Read the complete article here
Need help? Our support team is always here for you via chat on our website.
This content originally appeared on DEV Community and was authored by Daniel ZS
Daniel ZS | Sciencx (2025-04-10T23:53:06+00:00) Reading AWS REST API in ODBC Apps (Power BI, Excel, Informatica, MS Access). Retrieved from https://www.scien.cx/2025/04/10/reading-aws-rest-api-in-odbc-apps-power-bi-excel-informatica-ms-access/
Please log in to upload a file.
There are no updates yet.
Click the Upload button above to add an update.