- We have software operating off a PostgreSQL back end. This operates on a PC on Windows OS.
- We also have separate accounting software "SYSPRO" operating on a Microsoft SQL backend. This operates on a PC on Windows OS.
- We require an application that:
A) Pulls data (Account Header Information only, Clients and Suppliers) from the SYSPRO MSQL database and pushes it to our PostgreSQL database by means of an action. Eg. Double click a desktop icon and a dialogue box appears "SYNC Syspro & PostgreSQL". With simple yes/no and finally completed popup when done. All logging to be saved as file with details of the transactions. All errors displayed and logged.
B) Pushes data from PostgreSQL to SYSPRO via their Business Objects Manager. We have a simple table of invoice records that once flagged as 'ready to export' we require the application to poll this table every 10 minutes and then extract that data as per the XML standard and push it into SYSPRO. Logging to be done via files. Any Errors need to be reported back to PostgreSQL against that row in the "Status" Varchar field.
We have a test PostgreSQL database and SYSPRO system deployed and can provide RDC access.
Syspro Documentation Attached