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.
You need to ensure that your data is refreshed every day before midnight.
Extract data from your SQL Database
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
Oracle SQL
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 system is on premise check our On Premise Systems section at the bottom of the page.
Extract data from your 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.
If your system is on premise check our On Premise Systems section at the bottom of the page.
Extract data from your SFTP
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).
Check the bottom of this page for CSV Files requirements.
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)
If your system is on premise check our On Premise Systems section at the bottom of the page.
Load data into AGR SFTP Server
AGR's integration framework also supports loading data into AGR SFTP Server. This allows you to upload files directly into AGR which will then be used during the daily job process to populate your AGR system with your data.
AGR will share the SFTP credentials with you to allow you to establish a connection:
Server
Port
Login Credentials
If you are using .csv files check the bottom of this page for CSV Files requirements
Load data into AGR via REST API
AGR's integration framework also supports loading data into AGR Azure Blob Container using our Azure REST API.
This also allows you to upload files directly into AGR which will then be used during the daily job process to populate your system with your data.
AGR will share the REST endpoint with you and the authentication details. You can then test uploading files using a REST call with the following details:
PUT [api url]/[file_name.extension]?[authentication_details]
[api url] - will be shared with you and defines the container in Azure to which you will upload the files.
[file_name.extension] - defined by you. This will define the name and extension of the file that will be created on our Blob container. This needs to have the same name as the data source.
[authentication_details] - managed by AGR and shared with you also.
The body of the message needs to be defined as the content of the file.
If you are using .csv files check the bottom of this page for CSV Files requirements
CSV Files Requirements
The .csv files need to meet the following requirements:
File name - same as the data source and .csv as the extension.
First row as Header with column names.
UTF-8 encoding.
Needs to have the following File structure defined:
Column Delimiter - usually semicolon (;).
Row Delimiter - usually new line (\n or \r).
Quote Character - usually double quotes (").
Escape Character - usually backslash (\).
Data and column integrity. Each column defined in a .csv file must have a corresponding field in all rows, even if empty.
On Premise Systems
If your data is privately hosted (on-premise or in a private cloud). AGR requires Azure Integration Runtime service to be set up, this will allow Azure to connect directly into your server.
See our article about Microsoft Integration Runtime for more details.