Overview
AGR has a versatile integration framework that enables connection and mapping of data from your ERP system. To build your system, AGR needs to connect to your data source. The instructions below cover supported data platforms.
Note
If your data is privately hosted (on-premise or in a private cloud), AGR requires an Azure Integration Runtime service to be set up. See Get data into AGR via Integration Runtime for details.
Data Transfer using a SQL Server
This is the most basic, best supported option. It's fast, stable and is easy to implement for both AGR and your IT. AGR supports the following SQL types:
Microsoft SQL
MySQL
PostgreSQL
AGR will need the following information:
SQL Server address
Database name
Credentials with read access to tables needed
Definitions of relevant tables (indicators for column data types and size)
If your SQL platform is not your ERPs production database (i.e. a copy or replica), you need to ensure it is refreshed every day before midnight.
Data Transfer using an API
Many ERP systems offer APIs to facilitate integrations. AGR can connect to a variety of web based APIs. For a smooth connection, make sure your API meets the following requirements:
Pagination support
Authentication using OAuth2.0, Bearer Token or Basic Auth
Payloads in either JSON or XML format
Documentation (i.e. swagger or equivalent)
AGR needs a
base URL
suite of endpoints that expose the necessary data and
support for the contents of each endpoint.
from the API.
Data transfer using an SFTP server
AGR's integration framework also supports reading .csv files from an SFTP server.
The SFTP server should contain a suite of .csv files that correspond to tables (i.e. Locations would have one file while an item catalogue would have another). The .csv files need to meet the following requirements:
Column separator as a semicolon (;)
File and column names that are consistent with source data
GB-English/US-English locale for thousands separators
UTF-8 encoding
Data and column integrity. Each column defined in a .csv file must have a corresponding field in all rows, even if empty.
AGR will need the following:
Connection info for the SFTP server
Credentials to access it
Any relevant structural information (i.e. folders to fetch from)
You will need to ensure that the .csv data in the SFTP server is refreshed every day before midnight