Database synchronization

Budget: 6000 UAH Deadline: 6 days

Good day, Yulia! I was doing integrations with SalesDrive through their API — both the outgoing webhooks for status changes and the reverse data entry via the API key. On the Access side, I'm connecting through ODBC (pyodbc), so I will set up a two-way exchange of funnel statuses. Right away, the main question: is Access on a single PC or on a shared server/network folder? This will determine whether to run the synchronization on that machine directly or through an intermediary layer. As for the timeline — about 5-6 days.

Budget: 6000 UAH Deadline: 4 days

Good day!
We have done integrations between CRM and external systems via API - two-way synchronization of statuses is implemented through SalesDrive API and ODBC/VBA from the Access side.

Please let me know how often synchronization is needed - in real-time via webhook or on a schedule (once every N minutes)?

Budget: 6000 UAH Deadline: 2 days

Hello!
I have worked many times with SalesDrive and integrated with them.
Feel free to reach out, I will be happy to help!

Budget: 6000 UAH Deadline: 5 days

Доброго дня! Так, можу реалізувати двосторонню синхронізацію Microsoft Access із CRM SalesDrive.
На першому етапі зміна статусу заявки в SalesDrive автоматично передаватиметься в Access. На другому — зміна статусу в Access оновлюватиме відповідну заявку в SalesDrive через API.
Також передбачу зіставлення статусів, журнал операцій, обробку помилок і захист від дублювання.

Budget: 6000 UAH Deadline: 2 days

I can set up synchronization, I have experience in administering MS Azure and commercial DevOps.

Budget: 12000 UAH Deadline: 5 days

We already have an almost ready solution for synchronizing CRM with local databases, which can be quickly adapted for SalesDrive and Microsoft Access - I'm available here, we can discuss it now ))

I would preliminarily estimate the first working stage at 12,000 UAH and 5 working days, provided that access to the SalesDrive API and Access structure is unrestricted. We can implement status exchange in both directions, an error log, duplication protection, manual retries of failed operations, and a simple control panel. If needed, we can add AI anomaly detection - for example, when the status in CRM and Microsoft Access diverges without a logical reason.

We would start with a status map and a test exchange on 2-3 statuses, and then connect full synchronization. It needs to be clarified - is the Microsoft Access file located on one computer, in a network folder, or on a server? Another question - do statuses in SalesDrive change via API or is an intermediate webhook needed?

Similar tasks in logic.
https://business.ingello.com/forma-crm - CRM and business processes with roles, statuses, and accounting.
https://business.ingello.com/platforma - corporate system with integrations and complex data logic.
About us for freelancehunt - https://systems-fl.ingello.com/ua

Budget: 6000 UAH Deadline: 4 days

I will create a two-way synchronization between SalesDrive and Microsoft Access: changes in the pipeline status in the CRM will be sent to Access, and changes in Access will update the status in SalesDrive. I will connect the CRM through their API (webhooks for changes + write back), and Access through ODBC.

Budget: 6000 UAH Deadline: 7 days

It is necessary to connect SalesDrive and Microsoft Access in a bidirectional synchronization: statuses from the CRM are pulled into Access, and changes in Access go back to the CRM.

I will implement this through a Python script: SalesDrive has a REST API, and Access connects via pyodbc. The first direction: polling or webhook from SalesDrive, parsing status changes in the funnel, writing to the Access table. The second direction: tracking changes in Access (timestamp or trigger via VBA), PUT request to the SalesDrive API. The key risk: conflict during simultaneous changes from both sides, so I will establish priority logic and a synchronization log.

Which field in Access corresponds to the funnel status in SalesDrive, and is there already a mapping table of values between the two systems?