Amazon Marketplace Connector Setup

Version 23.0.8517

Amazon Marketplace Connector Setup

The Amazon Marketplace connector allows you to integrate Amazon Marketplace into your data flow by pushing or pulling data from Amazon Marketplace. Follow the steps below to connect CData Arc to Amazon Marketplace.

Note: Because the Amazon Marketplace connector requires that embedded credentials rotate every six months, make sure your firewall does not block

Establish a Connection

To allow Arc to use data from Amazon Marketplace, you must first establish a connection to Amazon Marketplace. There are two ways to establish this connection:

  • Add a Amazon Marketplace connector to your flow. Then, in the settings pane, click Create next to the Connection drop-down list.
  • Open the Arc Settings page, then open the Connections tab. Click Add, select Amazon Marketplace, and click Next.


  • The login process is only required the first time the connection is created.
  • Connections to Amazon Marketplace can be re-used across multiple Amazon Marketplace connectors.

Enter Connection Settings

After opening a new connection dialogue, follow these steps:

  1. Enter a name for the connection.

  2. Click Connect.

  3. A new window opens for logging into Amazon Marketplace. Enter your credentials and log in.

  4. If prompted, grant permissions for Arc to connect to Amazon Marketplace. You will then return to Arc.

  5. Click Add Connection to finalize the connection.

  6. In the Connection drop-down list of the connector configuration pane, select the newly-created connection.

  7. Click Save Changes.

Select an Action

After establishing a connection to Amazon Marketplace, you must choose the action that the Amazon Marketplace connector will perform. The table below outlines each action and where it belongs in an Arc flow.

Action Description Position in Flow
Upsert Inserts or updates Amazon Marketplace data. By default, if a record already exists in Amazon Marketplace, an update is performed on the existing data in Amazon Marketplace using the values provided from the input. End
Lookup Retrieves a value from Amazon Marketplace and inserts that value into an already-existing Arc message in the flow.
The Lookup Query determines what value the connector will retrieve from Amazon Marketplace. It should be formatted as a SQL query against the Amazon Marketplace tables.
Select Retrieves data from Amazon Marketplace and brings it into Arc.
You can use the Filter panel to add filters to the Select. These filters function similarly to WHERE clauses in SQL.
Execute Stored Procedures Treats data coming into the connector as input for a stored procedure, and then passes the result down the flow.
You can click the Show Sample Data button to provide sample inputs to the selected Stored Procedure and preview the results.
Submit Vendor Order Acknowledgment Submits acknowledgements for one purchase order. End
Submit Vendor Shipment Confirmations Submits shipment confirmations for vendor orders. End
Submit Vendor Payments Submits new invoices to Amazon Marketplace. End
Update Inventory Updates inventory for specified items. End