PostgreSQL, MSQL, SYSPRO BUSINESS OBJECTS INTEGRATION
This project was awarded to mabdelmonem for $22 AUD / hour.Get free quotes for a project like this
Project Budget$15 - $25 AUD / hour
- 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
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online