CommerceShip Logo
Log inGet access

Export supply chain data to Azure Synapse Analytics

Send orders, shipments, invoices, and carrier costs to Azure Synapse Analytics for reporting alongside the rest of the business.

Get startedLearn how it works
Reports
Pending
TypeFormatRowsStatus
Invoice Auditcsv1,284Pending
Finance Invoicescsv312Pending
Invoice Auditcsv5,902Pending

Azure Synapse Analytics Integration Capabilities

Unified analytics platform combining data warehousing and big data analytics.

Tables on a schedule
Orders, inventory, shipments, invoices, returns, and carrier costs sync into Azure Synapse Analytics 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 Azure Synapse Analytics
Incremental updates
Only new and changed records are written. No full reloads.

How the Azure Synapse Analytics integration works

  1. Connect Azure Synapse Analytics

    Add the credentials for your Azure Synapse Analytics 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 Azure Synapse Analytics, map them to your tables, and set the schedule.

  3. Keep Azure Synapse Analytics current

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

Azure Synapse Analytics Integration FAQs

Still have questions?

Export supply chain data to Azure Synapse Analytics

Orders, shipments, invoices, and carrier costs export to Azure Synapse Analytics on a schedule, mapped to your tables.

Get started

Other Data Destinations

Warehouses, databases, spreadsheets, and file storage you can send the same shipping data to