Read and write Amazon Ads data in SSIS with API Source and API Destination components.

The SSIS Amazon Ads Connector helps ETL teams configure OAuth authentication, preview endpoints, and move campaign, ad group, report, and performance metric data without custom scripts. Use predefined connector templates, map fields visually, and run both export and import flows in one package.
Part of ZappySys SSIS PowerPack (100+ connectors & tasks).

Recommended starting point

View Setup Guide & Get Started →

See features, UI & examples →

Pro Tip: Install the full SSIS PowerPack to access API Source, API Destination, Upsert Destination, and related connectors in one setup.

⚡ Key Benefits

Bidirectional Flow — Read and write Amazon Ads data with Source and Destination in one package
OAuth Configuration — Set ClientId, ClientSecret, AuthorizationUrl, ReturnUrl, Scope, and Profile in UI
Endpoint Preview — Select endpoints and validate output using Preview Data before execution
Retry Control — Handle throttling with RetryMode, RetryStatusCodeList, RetryCountMax, and wait strategy
Low-Code Mapping — Map columns visually for insert, update, and API write operations

📸 Visual Overview & Setup

1. Drag API Source onto Data Flow 🔍 View Full Size	2. Drag API Destination onto Data Flow 🔍 View Full Size	3. Pick or Download Amazon Ads Connector 🔍 View Full Size
4. Configure OAuth Parameters 🔍 View Full Size	5. Source Endpoint Preview 🔍 View Full Size	6. Destination Mapping & Execute 🔍 View Full Size

🔧 Key Features

Amazon Ads Source and Destination

Read and write Amazon Ads data in SSIS with predefined connector templates
Support common operations across campaigns, ad groups, reports, and performance metrics
Use API Source for export and API Destination for import in the same workflow

Authentication and API Control

OAuth Authentication with ClientId, ClientSecret, AuthorizationUrl, ReturnUrl, Scope, and Profile
Configurable API Base URL when endpoint targeting needs adjustment
Generate token flow directly from API Connection Manager UI

Reliability and Mapping

RetryMode with RetryStatusCodeList and RetryCountMax for API throttling scenarios
RetryMultiplyWaitTime option for progressive wait strategy
Visual column mapping in Destination flow for insert/update operations

💡 Common Use Cases

Campaign Performance Loads: Extract report and metric data into SQL staging tables for dashboards.
Bidirectional Sync: Read source records and push approved changes back through API Destination.
Scheduled API Pipelines: Automate daily and hourly Amazon Ads sync jobs in SQL Agent.
Retry-Aware ETL: Keep data movement stable during throttling windows with built-in retry controls.

🎯 Summary

Deploy SSIS packages that both read and write Amazon Ads data without custom API coding.
Configure OAuth, preview endpoints, map columns, and run reliable ETL flows from one visual toolset.

Trusted by Developers & IT Teams Worldwide

Built for SSIS Workflows: Purpose-built for high-performance ETL and complex integration scenarios.
Expert Technical Support: Direct access to engineers via email and remote screen-share sessions.
Proven Enterprise Scale: Trusted by 3000+ teams across 90+ countries, including Fortune 500.

SSIS PowerPack

Includes SSIS Amazon Ads Connector