Data Integration Utility for Sage 300 ERP

By | September 25, 2013

In this blog, we will discuss about one of our new developments i.e. Data Integration utility [DIU].

Data Integration here simply means combining data from several disparate sources, which are stored using various technologies and provide a unified view of the data. DIU reads data from two different files from FTP and helps in creating Sales Order Entry in Sage 300 ERP.

Files are normally generated from an external source. Say in a multi user environment, where users at front end use some web application and need data sharing and integration with Sage 300 ERP.

How DIU works:
Here users can generate data in Excel or CSV format from web portal and then can keep files on an ftp path. Greytrix Data Integration Utility program will then read the data files from FTP and load it onto a local path on Server which will be used for creating order entry in Sage 300 ERP.

The custom routine will read files in a specific date format in order to carry out integration on daily basis. Once, files are loaded locally they can be used in DIU program to import.

Both, CSV files (generated from web portal) contain different information required for creating Order Entry like (Customer No, Item No, Quantity required, Optional field data etc.)  DIU Integration routine will read both the files, Validate the data present in file, integrate them and create Sales orders efficiently in OE Module.

New Stuff: POS Sage 300 ERP Integration

In case files contain any incorrect data or there is duplication of data such as transaction number, some optional fields or any required value that are not available then routine will provide an error log with clear information about the error. This way, you do not need to run the routine manually on daily basis; you can simply add the program to window scheduler and assign a specific time and assign a user to audit the error log on regular basis so that program will get the corrected data from assigned path and will create the transaction in sage 300 ERP.

Suppose, users add this routine to window scheduler to run daily at 9pm; then, Data Integration Utility program will read the files from FTP server daily at 9 pm , load these files on to a local drive and will then create sales order entries as desired.

Data integration becomes increasingly important in cases of merging systems of two companies or consolidating applications within one company to provide a unified view of the company’s data assets.

Your web site portal and ERP software have all of your inventory, pricing and sales information, but unfortunately, the way this information is stored in your system doesn’t translate well to business on the web. Our DIU allows you to merchandise products on your website how you want to rather than how it’s entered into your system. At Modern business case, we know what it takes for retailers to succeed online and we’ve designed our Integrator to help you do just that by providing Data integration utility with Sage 300 ERP.