Need help setting up Jitterbit to Sync 2 tables in MS Access with SugarCRM
$100-150 USD
Cerrado
Publicado hace más de 15 años
$100-150 USD
Pagado a la entrega
We have an Access database, and we need to export several fields into a new SugarCRM database.
JitterBit is installed and seems like a good tool for this, but I need someone with JitterBit and SugarCRM experience to help me out on this. I don't think it's a very big project though.
## Deliverables
We will need JitterBit to perform a sync every 30 minutes or so, or as necessary.
We're mainly looking to synchronise the Client and Contacts tables, and make sure they sync up with each other, and if one database changes, the other is updated.
IE, There is an entry in the Access Database - a contact called Bob Barker. He changes companies and email addresses - when JitterBit is run, the Bob Barker in SugarCRM should be updated with these details as well. He should be working for the new working, and removed from the old company.
The main information that needs to be exported is Clients and Contacts. I have a list of the tables that need to be exported.
Please contact me and I will send you a copy of the Access tables I need to export/sync with SugarCRM. The Access database is the "Source".
I should be able to provide direct access to the server via SSH, MySQL and HTTP. If you have previous experience in SugarCRM, it is advantageous.
Please let me know if you know the best way to undertake this.