CommerceShip Logo

Export supply chain data to Amazon Redshift

Send orders, shipments, invoices, and carrier costs to Amazon Redshift for reporting alongside the rest of the business.

Reports
Pending
TypeFormatRowsStatus
Invoice Auditcsv1,284Pending
Finance Invoicescsv312Pending
Invoice Auditcsv5,902Pending

Amazon Redshift Integration Capabilities

Cloud data warehouse for analytics with fast query performance at scale.

Tables on a schedule
Orders, inventory, shipments, invoices, returns, and carrier costs sync into Amazon Redshift on your cadence
Cost records
Carrier charges are broken out by base rate, surcharge, and accessorial, with the audit result on each invoice line
Joins to business data
Keys match orders and customers, and freight joins to revenue and margin in Amazon Redshift
Incremental updates
Only new and changed records are written. No full reloads.

How the Amazon Redshift integration works

  1. Connect Amazon Redshift

    Add the credentials for your Amazon Redshift destination from your CommerceShip account. Access is scoped to writing where you point it and can be revoked from either side.

  2. Choose fields and cadence

    Pick which order, inventory, shipment, invoice, return, and carrier cost tables go to Amazon Redshift, map them to your tables, and set the schedule.

  3. Keep Amazon Redshift current

    Exports run on a schedule, new records are added as they are created, and each run is logged.

Amazon Redshift Integration FAQs

Still have questions?

Export supply chain data to Amazon Redshift

Orders, shipments, invoices, and carrier costs export to Amazon Redshift on a schedule, mapped to your tables.