SSIS Amazon Selling Partner (SP-API) Connector

Read and write Amazon Selling Partner (SP-API) data in SSIS with API Source and API Destination.

Configure Private app OAuth, preview endpoints, and automate listings, orders, reports, and payments without custom API code. This connector runs on the ZappySys API Connector framework and supports low-code extraction and writeback flows in one package.
Part of ZappySys SSIS PowerPack (100+ connectors & tasks).

Recommended starting point

View Setup Guide & Get Started →

See features, auth flow & endpoint examples →

Pro Tip: Use a User DSN-style design-time setup in Visual Studio, then promote secrets to package parameters / environments for SQL Agent deployments.

⚡ Key Benefits

Bidirectional Connector — Pull and push SP-API data with API Source and API Destination in one SSIS pipeline
Private OAuth Setup — Configure ClientId, ClientSecret, TokenUrl, and Refresh Token using built-in auth UI
Endpoint Preview — Pick endpoints and validate payloads before execution with Preview Data
Retry on Throttling — Built-in 429 retry options with RetryCountMax and RetryMultiplyWaitTime
Low-Code Mapping — Visual destination mapping for write operations and upsert-style downstream loads

📸 Visual Overview & Setup

1. Drag API Source 🔍 View Full Size	2. Choose SP-API Connector 🔍 View Full Size	3. Configure Private OAuth 🔍 View Full Size
4. Preview Endpoint Data 🔍 View Full Size	5. Drag API Destination 🔍 View Full Size	6. Map & Execute 🔍 View Full Size

🔧 Key Features

SP-API Data Operations

Read and write listings, orders, report metadata, catalog, and payment-related resources
Use API Source for extraction and API Destination for push/update in the same package
Explore many predefined actions including report retrieval and generic REST request operations

Private App OAuth

Authentication Type: Private app [OAuth]
Configure ClientId, ClientSecret, TokenUrl, and Refresh Token directly in connection manager
Supports API Base URL overrides and version parameters (Orders/Seller/Reports/etc.)

Reliability & ETL Fit

Retry controls for 429 throttling with RetryCountMax and exponential wait strategy
Easy handoff to Upsert Destination for SQL Server, PostgreSQL, and Redshift loads
Ready for SQL Agent and SSIS Catalog deployment patterns

💡 Common Use Cases

Order Ingestion: Pull order and order-item feeds into warehouse staging tables.
Catalog Enrichment: Query catalog/search endpoints and join with internal SKU data.
Report Automation: Trigger report endpoints, download outputs, and load to SQL targets.
Marketplace Monitoring: Track selling performance and reconcile operational metrics.

🎯 Summary

Build reliable SSIS pipelines for Amazon Selling Partner (SP-API) without hand-coding auth flows or REST pagination.
Configure Private OAuth once, preview endpoints quickly, map outputs visually, and run production ETL with built-in retry.

Start Integrating Amazon SP-API with SSIS PowerPack

Includes the SSIS Amazon Selling Partner Connector plus 100+ connectors & tasks for APIs, databases, and cloud apps.

Download SSIS PowerPack (Free Trial)

Full functionality is FREE for development within Visual Studio