Amazon Selling Partner (SP-API) ODBC Driver

Query Amazon Selling Partner (SP-API) using SQL from any ODBC-compatible tool.

The Amazon Selling Partner (SP-API) ODBC Driver is powered by ZappySys API Driver and lets you configure private app OAuth once, then query Orders, Listings, Reports, and other endpoints with familiar SQL patterns.
Part of ZappySys ODBC PowerPack (30+ drivers).

Recommended starting point

View Setup Guide & Get Started →

See auth setup, query builder & examples →

Pro Tip: Use User DSN for local design-time tools and System DSN for scheduled/background services.

⚡ Key Benefits

Private App OAuth — Configure ClientId, ClientSecret, TokenUrl, and Refresh Token in one DSN wizard
SQL over SP-API — Query endpoint-backed tables like Orders with parameterized WITH (...) options
Server-Side Filtering — Push filters to Amazon APIs via query builder parameters for faster retrieval
ODBC Ecosystem Ready — Works with SQL Server linked servers, Excel, Power BI, Python, and Tableau
Gateway Sharing — Centralize DSN access with Data Gateway for remote/JDBC/non-Windows consumers

📸 Visual Overview & Setup

1. Create API Driver DSN 🔍 View Full Size	2. Configure OAuth 🔍 View Full Size	3. Build SQL Query 🔍 View Full Size
4. Preview SP-API Rows 🔍 View Full Size	5. Use from BI/Apps 🔍 View Full Size	6. Share with Gateway Data Gateway overview

🔗 Seamless SQL Query Integration

Example query generated by Query Builder for SP-API Orders endpoint

SELECT * FROM Orders
WITH(
    CreatedAfter='1900-01-01T00:00:00'
)

✔ Query builder parameters push filtering server-side
✔ Faster than client-side WHERE/LIMIT on full datasets
✔ Reuse same SQL across ODBC clients

🔧 Key Features

Read & Query

Read Orders and other SP-API endpoints using SQL syntax with endpoint-specific parameters
Preview data before production query execution
Use API parameters for server-side filtering and better performance

Authentication

Private app OAuth support with ClientId, ClientSecret, TokenUrl, and Refresh Token
One-click token generation in DSN UI
Configurable API base URL and API version parameters

Reliability & Platform Fit

Retry options for throttling (HTTP 429) via RetryMode, RetryStatusCodeList, and RetryCountMax
Compatible with SQL Server, Excel, Power BI, Python, Tableau, and custom ODBC apps
Optional centralized access with Data Gateway

💡 Common Use Cases

Order Analytics: Pull SP-API orders into BI models for fulfillment and sales reporting.
Listing Monitoring: Query listing data for catalog quality and availability checks.
Report Pipelines: Extract report metadata and content for scheduled ETL loads.
Cross-Tool Access: Reuse one DSN across SQL tools, notebooks, and dashboard platforms.

🎯 Summary

Bring Amazon Selling Partner (SP-API) into your standard ODBC workflow without building custom API clients.
Configure OAuth once, generate SQL with query builder, and deliver governed shared access through Data Gateway when needed.