
Completed
Posted
Paid on delivery
# [login to view URL] – Real-Time Bidirectional Integration with Cegid Primavera ERP ## Project Overview The objective is to develop a secure, scalable, real-time bidirectional communication system between **[login to view URL]**, an AI-powered platform hosted on an Ubuntu VPS (Hostinger), and **Cegid Primavera ERP V10**, installed on customers' Windows servers. The solution will use **ASP.NET Core SignalR and C#** to establish persistent communication between the cloud platform and locally installed agents. The system must support remote ERP operations, automatic event detection, data synchronization, and real-time notifications. ## 1. System Architecture The solution will consist of three main components. ### A. [login to view URL] – SignalR Server - Developed in C# using ASP.NET Core. - Hosted on an Ubuntu VPS using Docker. - Exposes a secure SignalR Hub over HTTPS/WSS (port 443). - Manages simultaneous connections from multiple customer agents. - Identifies and authenticates each customer and agent. - Routes commands to the correct customer environment. - Receives events and responses from connected agents. - Integrates with the existing [login to view URL] Python/FastAPI backend. ### B. [login to view URL] – Windows Service - Developed in C# using .NET. - Installed as a Windows Service on each customer's server. - Automatically connects to the [login to view URL] SignalR Server. - Maintains a persistent bidirectional connection. - Automatically reconnects after network interruptions. - Integrates with Cegid Primavera ERP V10 through its SDK (BSO/DSO). - Executes authorized commands received from POTE.IA. - Detects and reports relevant ERP changes. - Maintains a local persistent event queue when the cloud server is unavailable. ### C. [login to view URL] – AI Platform - Developed in Python using FastAPI. - Communicates with the SignalR Server through an internal API. - Sends ERP commands to specific customer agents. - Receives structured JSON responses. - Processes ERP events in real time. - Uses AI to interpret user requests and trigger authorized ERP operations. ## 2. Bidirectional Communication ### [login to view URL] → Primavera ERP The AI platform must be able to request operations such as: - Retrieve customer information and account balances. - Retrieve sales invoices and purchase documents. - Check stock availability and warehouse inventory. - Retrieve sales orders and order statuses. - Execute predefined SQL queries and stored procedures. - Create or update ERP records through authorized Primavera SDK operations. - Retrieve accounting and financial information. Each command must include a unique request identifier, customer identification, command type, parameters, and appropriate authorization information. ### Primavera ERP → [login to view URL] The local agent must automatically detect and report events such as: - New sales invoice created. - Sales order created or updated. - Customer information modified. - Stock quantity changed. - Payment or receipt registered. - Purchase document created. - Accounting entry registered or updated. Event detection should use Primavera extensibility mechanisms where available, supplemented by SQL Server Change Data Capture (CDC), an outbox mechanism, or periodic synchronization when appropriate. ## 3. Example Command [login to view URL] sends: ```json { "request_id": "REQ-10001", "organization": "CUSTOMER_A", "command": "GET_CUSTOMER_BALANCE", "parameters": { "customer": "0001" } } ``` The Windows agent executes the authorized operation using the Primavera SDK and returns: ```json { "request_id": "REQ-10001", "success": true, "data": { "customer": "0001", "balance": 12500.75, "currency": "EUR" } } ``` ## 4. Example ERP Event When a new invoice is created, the agent sends: ```json { "event_id": "EVT-10001", "organization": "CUSTOMER_A", "event": "INVOICE_CREATED", "module": "SALES", "document": { "type": "FA", "series": "2026", "number": 1523, "customer": "0001", "total": 1250.00 } } ``` [login to view URL] receives the event and can automatically update dashboards, synchronize external systems, execute business rules, or generate AI-powered notifications. ## 5. Security Requirements The system must implement: - Encrypted communication using TLS. - Authentication for each Windows agent. - Customer-specific authorization and data isolation. - Secure storage of credentials. - Command allowlisting and parameter validation. - Protection against arbitrary SQL execution. - Audit logging of commands and events. - Request timeouts and error handling. - Duplicate event detection and idempotent processing. Each customer agent must only receive commands explicitly authorized for its organization. ## 6. Reliability and Event Management The system must support: - Automatic SignalR reconnection. - Agent online/offline status monitoring. - Persistent local event storage. - Retry mechanisms for failed transmissions. - Server-side acknowledgement of processed events. - Recovery of pending events after reconnection. - Unique event and request identifiers. - Prevention of duplicate processing. Events must not be marked as successfully delivered until the server confirms durable receipt or processing. ## 7. Development Requirements Create a Visual Studio solution containing: **[login to view URL]** - ASP.NET Core SignalR Hub. - Agent authentication and connection management. - Command routing. - Event reception. - Internal API for Python/FastAPI integration. - Docker configuration for Ubuntu deployment. **[login to view URL]** - .NET Windows Worker Service. - SignalR client. - Automatic reconnection. - Primavera ERP V10 integration layer. - Command execution service. - ERP event detection. - Local event queue. - Structured logging. - Configuration file for customer and server settings. The solution must be modular, maintainable, and designed to support multiple customer installations. ## 8. Expected Deliverables 1. Complete C# Visual Studio solution with source code. 2. Functional ASP.NET Core SignalR server. 3. Windows Service agent installer or deployment package. 4. Integration interfaces for Primavera ERP V10. 5. Example commands and ERP event handlers. 6. Python/FastAPI integration examples. 7. Docker deployment configuration. 8. Security and configuration documentation. 9. Installation and deployment instructions. 10. End-to-end communication tests. ## 9. Final Objective Build a reliable, secure, multi-tenant communication infrastructure that allows **[login to view URL] to interact with multiple Cegid Primavera ERP installations in real time**, without requiring inbound firewall ports or direct public access to customer databases. The platform must support both on-demand ERP operations initiated by [login to view URL] and automatic event notifications originating from Primavera ERP. The architecture should be suitable for future expansion into additional ERP modules, automated accounting processes, document processing, and AI-driven business workflows.
Project ID: 40776678
64 proposals
Remote project
Active 4 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

Hello, I can build the bidirectional SignalR infrastructure that connects [login to view URL] to multiple Primavera ERP instances without exposing customer databases to the internet. I developed a similar multi-tenant agent system for a SaaS logistics platform using SignalR and persistent Windows services, though that one integrated with a different ERP—the architecture taught me how to handle reconnection logic and local event queuing when cloud connectivity drops. I'd structure this using ASP.NET Core SignalR for the server hub with customer-specific channel routing, a .NET Windows Service agent that maintains persistent connection state and manages Primavera SDK calls, and a local outbox pattern for event storage during disconnections. The critical piece is separating command execution from event detection so one doesn't block the other. Real-time synchronization reduces manual data entry errors and keeps your AI platform working with current ERP state, which means faster decision-making and fewer support requests about stale information. I'll provide a modular solution where each component can be tested independently, and I'll document the Primavera integration points clearly so future changes don't require rewriting the core communication layer. If you want to move forward, I can start by reviewing your Primavera SDK documentation and mapping out the specific event detection strategy that works best for your customer base. Thanks, Lazar.
€250 EUR in 2 days
3.8
3.8
64 freelancers are bidding on average €449 EUR for this job

Hi , Good afternoon! I’ve carefully checked your requirements and really interested in this job. I’m full stack node.js developer working at large-scale apps as a lead developer with U.S. and European teams. I’m offering best quality and highest performance at lowest price. I can complete your project on time and your will experience great satisfaction with me. I’m well versed in React/Redux, Angular JS, Node JS, Ruby on Rails, html/css as well as javascript and jquery. I have rich experienced in ASP.NET, Signal Processing, C# Programming and RESTful. For more information about me, please refer to my portfolios. I’m ready to discuss your project and start immediately. "total" Looking forward to hearing you back and discussing all details.. Thanks & Regards
€555 EUR in 5 days
3.1
3.1

Hi, I'll architect this using ASP.NET Core SignalR for the Ubuntu VPS hub and a .NET Windows Service agent, ensuring secure, persistent bidirectional sync with Cegid Primavera via its BSO/DSO SDK without opening inbound firewall ports. Your challenge is reliable real-time communication behind customer firewalls. I’ll implement a robust reconnection strategy with local SQLite queuing in the Agent to handle network drops, ensuring zero data loss. Using SignalR over WSS provides low-latency updates compared to REST polling, while the Python FastAPI backend communicates via internal gRPC or HTTP, keeping the architecture modular and scalable for multi-tenant isolation. Previously, I built a similar IoT bridge for an ERP system, reducing sync latency from 5 minutes to sub-second. We handled 50+ concurrent agents with 99.9% uptime by implementing exponential backoff retries and idempotent event processing, which prevented duplicate invoice creation during network flaps. Quick question: Do you have specific Primavera V10 SDK documentation access for the agent? Also, should the Agent use SQL CDC or Primavera's native extensibility hooks for event detection?
€500 EUR in 7 days
0.0
0.0

Hi, Your architecture is right, so let me go straight to the two things that actually sink this build, not the plumbing. First, the Primavera V10 SDK. BSO/DSO run through PriEngine, which expects a licensed platform context and the correct bitness, and it does not initialise cleanly inside a non-interactive Windows Service by default. That is where most of these integrations stall. I handle the engine lifecycle and licensing context explicitly in the agent, so the service starts the SDK reliably on boot and after reconnects, not only when a user is logged in. Second, delivery guarantees. You wrote that events must not be acked until durable receipt, which tells me you have lost or doubled events before. The fix is a transactional outbox on the agent: the ERP change and its outbox row commit in one SQL transaction, the agent streams from the outbox, and the server acks only after durable persistence, keyed on event_id so a replay after reconnect never double-processes. Same idempotency on request_id for commands. Your no-inbound-ports goal is already solved by the design: the agent is the SignalR client dialling out on 443/WSS, so nothing opens on the customer side. Allowlisted commands and per-organization routing keep tenants isolated. One question: can each customer's SQL Server edition and access support CDC for change detection, or should I default to a trigger-fed outbox?
€500 EUR in 3 days
0.0
0.0

Thanks for detail. I built multi tenant ERP integration system from start to end. I understand this workflow well and can get you strong result quickly. I hope to discuss about specific approach on detail chat. Thanks Fu
€390 EUR in 12 days
0.0
0.0

Espinho, Portugal
Payment method verified
Member since Oct 19, 2026
€250-750 EUR
£10-20 GBP
₹12500-37500 INR
$10-30 USD
$250-1000 USD
$250-750 USD
₹1500-12500 INR
€750-1500 EUR
£10-15 GBP / hour
₹12500-37500 INR
€30-250 EUR
€8-30 EUR
$30-250 USD
$10-30 USD
$15-25 USD / hour
$30-250 USD
₹12500-37500 INR
$10-30 USD
₹12500-37500 INR
$8-15 USD / hour
₹400-750 INR / hour