Amazon Ads ODBC Driver

⚡ Key Benefits

• SQL over Amazon Ads — Query profiles, campaigns, ad groups, and reports with SELECT and generic REST actions
• OAuth Authentication — Use Amazon Developer Security Profile (Client ID, Client Secret, Return URL) with one-click Generate Token
• Query Builder UI — Pick a table or endpoint, set parameters like ReportType / TimeUnit / Metrics, preview rows, and copy the generated SQL
• Server-Side Report Parameters — Pass report grouping, metrics, and date ranges through the Query Builder so filtering runs in Amazon Ads, not the client
• Built-In Retry for Throttling — Default RetryMode RetryWhenStatusCodeMatch handles HTTP 429 with configurable retry count and exponential backoff
• Centralized Access — Share the DSN via ZappySys Data Gateway so JDBC, Linux, or remote apps can read Amazon Ads without installing the driver locally

📸 Visual Overview & Setup

1. Pick Amazon Ads Connector 🔍 View Full Size	2. Search Online if Not Listed Amazon Ads connector page	3. Build & Preview SQL Query 🔍 View Full Size
4. Load Amazon Ads Rows into Excel 🔍 View Full Size	5. Connect from Power BI 🔍 View Full Size	6. Share via Data Gateway Data Gateway overview

🔗 Seamless SQL Query Integration

-- Get Sponsored Products report via SQL (Amazon Ads)
SELECT *
FROM get_beta_report
WITH (
    ReportName                = 'Test Name'
    , ReportType              = 'spCampaigns'
    , TimeUnit                = 'SUMMARY'
    , GroupByCampaignReportType = 'campaign'
    , GroupByCampaignMetrics  = 'impressions,clicks,cost'
)

🔧 Key Features

Read & Query

• SELECT with WHERE, ORDER BY, and parameterised Query Builder for server-side filtering
• Read Profiles to list advertising accounts and profile IDs across marketplaces
• Run Get Beta Report or Get Report actions to retrieve Sponsored Products / Sponsored Brands metrics
• Configure ReportType, TimeUnit, GroupBy, Metrics, and date ranges directly from the Query Builder

Write & Generic Operations

• Make Generic REST API Request action for any Amazon Ads endpoint not yet wrapped by a named action
• Make Generic REST API Request (Bulk Write) for large payloads where a single bulk call is preferable
• Test Connection action to validate your OAuth token and API base URL before running jobs

Authentication

• OAuth Authentication — Use an Amazon Developer Security Profile with Client ID, Client Secret, Authorization URL, Return URL, and Scope
• One-click Generate Token in the DSN wizard to obtain and refresh the OAuth token
• Profile picker to select the advertising Profile that subsequent queries should run under
• Works with https://zappysys.com/oauth as a default Return URL or any Allowed Return URL you configure in Amazon Developer

Reliability & Platform Fit

• Built-in retry with RetryMode = RetryWhenStatusCodeMatch, RetryStatusCodeList = 429, RetryCountMax = 5, and RetryMultiplyWaitTime = True
• Standard ODBC 3.x for Power BI, Tableau, Excel, SQL Server linked servers, SSIS, and custom apps
• Centralised access via ZappySys Data Gateway for JDBC, Linux, and remote clients without installing the driver locally

💡 Common Use Cases

Typical scenarios for the Amazon Ads ODBC Driver in reporting, ETL, and app development:

• Campaign performance reporting in Power BI or Excel: Pull Sponsored Products metrics (impressions, clicks, cost) straight into models without writing API code.
  Example: SELECT * FROM get_beta_report WITH (ReportType='spCampaigns', TimeUnit='SUMMARY', GroupByCampaignMetrics='impressions,clicks,cost')
• Warehouse loads of Amazon Ads data: Schedule nightly extracts into SQL Server or a data warehouse via SSIS or ODBC jobs.
  Example: load Profiles and daily Sponsored Products reports into staging tables for downstream modelling.
• Cross-marketplace profile enumeration: List every advertising profile the account has access to before running targeted report queries.
  Example: SELECT * FROM Profiles
• Throttling-aware pipelines: Lean on the built-in retry for HTTP 429 so long-running report jobs don't fail when Amazon Ads rate-limits.
  Example: override RetryCountMax and RetryMultiplyWaitTime per DSN for heavy extraction windows.
• Ad hoc REST calls from SQL: Use Make Generic REST API Request to hit newer Amazon Ads endpoints before a named action exists.
  Example: call a new reporting endpoint with a JSON body straight from an ODBC WITH clause.
• Centralised access from JDBC or Linux: Route queries through ZappySys Data Gateway so non-Windows clients can read Amazon Ads without installing ODBC locally.
  Example: a Java service queries Amazon Ads via a SQL Server JDBC URL pointing at the gateway.

🎯 Summary

Bring Amazon Ads into the ODBC ecosystem your team already uses.
Query profiles, campaigns, and Sponsored Products reports with SQL, authenticate through Amazon OAuth, survive throttling with built-in retry, and connect from Visual Studio, BI stacks, or SQL Server — without maintaining one-off Advertising API integrations.

Trusted by Developers & IT Teams Worldwide Built for ODBC Workloads: One driver model across BI, ETL, databases, and custom code. Expert Technical Support: Engineers help with OAuth setup, Amazon Ads profiles, and report tuning. Proven Enterprise Scale: Thousands of teams worldwide rely on ZappySys for API and cloud connectivity.

ODBC PowerPack Includes Amazon Ads ODBC Driver Read reviews on Capterra →