I want to design a small windows application that will allow us to synchronize data from a local ODBC database to an online CRM system using an XML-RPC API (please see attached info, and below link for info about API).
The software should allow us to enter in a SQL statement that would be used to query the local database, then give a list of the returned fields - which we can map to the online fields (which we will manually enter). The software would automatically run based on the Windows Scheduler. ?
I will give you access to our server so you can extract the data and also test your software.
[[url removed, login to view]]
Software you create should allow us to identify the fields from the database with the correspondings fields in the software.