Overview
The standard OrderWise integration gets you up and running with AGR quickly, powered by your OrderWise data. Two deployment modes are supported:
OrderWise Cloud — via the OrderWise REST API
OrderWise On-Premise — via direct read access to the OrderWise SQL Server database
Data mapping
See the AGR Data Interface for the standard mapping of OrderWise data into AGR or our mapping document:
The standard connector covers items, vendors, customers, locations, item-locations (SKU), sales history, stock levels, stock history, open sales orders, undelivered purchase orders, purchase order receipts, transfers, BOM components and consumption, committed demand, promotions and customer groups.
Customizations to the mapping can often be accommodated at a cost.
Instructions
Follow the steps for your deployment:
OrderWise Cloud
AGR reads your data through the OrderWise REST API, using OrderWise Export Definitions (SQL-backed endpoints that return data in bulk).
Provide REST API credentials (domain, username and password) for an OrderWise user with API and read access.
AGR will share the Export Defintions code for you to create.
Share the endpoint ID of each Export Definition with AGR so the connector can call them.
OrderWise On-Premise
Because the database is privately hosted, install an Integration Runtime service — see Microsoft Integration Runtime.
Provide read access to the OrderWise live SQL database.