Case Study Information
Short Description
Pell Software engineered a high-capacity, multi-tenant integration platform connecting Vista by Viewpoint with FieldFlล. By utilizing a Multi-Instance Architecture powered by Azure Batch, we enable our client to onboard and manage an unlimited number of partners, providing each with a dedicated, isolated sync environment tailored to their specific organizational hierarchy.
The Challenge
Our client needed a solution that could grow as fast as their partner list. Vista by Viewpoint is the “ERP of choice” for high-volume infrastructure and civil contractors, meaning the data loads are massive and the structural needs are highly specific.
The core challenges centered on Massive Scale and Partner Isolation:
- The “One-Size-Fits-None” Problem: Every partner has a different Vista setup. Some need to sync 500 projects; others have 5,000. Traditional shared-resource integrations would slow down or crash under the weight of multiple high-volume clients.
- Onboarding Friction: Manually configuring a new Vista-to-FieldFlล bridge for every new client was a significant bottleneck. Our client needed a way to “spin up” new integrations in minutes, not days.
- Structural Drift: Large-scale contractors often have hundreds of phases and job roles. Without a robust sync, the field data quickly becomes a “mess” of unmapped costs that accounting must manually untangle.
The Solution
Pell Software solved the scaling problem by moving away from “one-off” code and building a Multi-Instance Command Center.
1. Isolated Sync Instances for Every Partner
When a new partner signs on, we don’t just add them to a list. We spawn a dedicated, isolated instance of the sync engine specifically for them. This ensures:
- Absolute Security: Partner A’s data lists never exist in the same execution memory as Partner B’s.
- Dedicated Performance: If a large contractor initiates a massive historical project sync, it has its own dedicated resources and never slows down the sync for other clients on the platform.
2. Visual Settings Portal for Instant Onboarding
Our custom-built portal allows the client to manage these instances through a simple Visual Interface. Instead of writing code, they use toggles to select which Vista entities (Clients, Employees, Projects, etc.) are active for that specific partner. This “No-Code” approach allows the client to onboard a new firm and have them live in FieldFlล within a single coffee break.
3. Enterprise Power via Azure Batch
To handle the heavy data demands of Vista, we utilized Azure Batch. This enterprise-grade compute engine provides resources on-demand to process thousands of records simultaneously. It handles the bulk migrations of Projects, Phases, and Job Roles without execution timeouts, ensuring the 15-minute sync window is always met.
The Outcome
By treating the integration as a scalable service, Pell Software has empowered our client to become an industry-leading service provider.
- Limitless Onboarding: The client can now onboard an unlimited number of partners, as the Azure backend automatically scales to meet the total compute demand.
- Zero-Lag Mobilization: New partners can see their entire Vista project structure inside FieldFlล quickly, allowing field teams to start tracking time and materials against the correct cost codes on day one.
- Structural Integrity: By mirroring Vista’s complex hierarchies (Departments to Offices, Phases to Positions), weโve eliminated the need for manual data “cleanup,” saving accounting teams dozens of hours every month.
- High-Value ROI: The business can grow its user base without needing a large technical support team, as the multi-instance model makes the platform self-scaling and incredibly stable.
Date
March, 2022 – Present
We started work on Phase 1 of the application in March 2022. Our team has been constantly improving and maintaining it ever since including the addition of new features and adjustments of existing features.
Major Features
- Multi-Instance Spawning: Deploy isolated, dedicated sync environments for an unlimited number of regional partners or business units.
- Advanced Hierarchy Mapping: Seamlessly connects Vista Departments, Phases, and Job Roles to their counterparts in FieldFlล.
- Azure Batch Orchestration: High-performance background processing that handles massive enterprise datasets without timeouts.
- Visual Configuration UI: A simple portal for managing client-specific sync settings and credentials.
- Real-Time Resource Sync: Automated synchronization of Clients, Employees, and Projects to ensure total organizational alignment.
- Audit-Ready Logging: Detailed, instance-specific logs for monitoring sync health and structural data movement.
Technologies Used & Keywords
- Programming Language(s): .NET, C#, SQL
- Framework(s): ASP.NET Core, .NET MVC, Razor, Bootstrap
- Infrastructure: Microsoft Azure, Azure SQL Server, Azure App Service, Azure Batch
- Third-party Systems: QuickBooks Online, FieldFlล
Client
Client Industry
Construction Field Management
Client Description
Built by contractors, FieldFlล is a comprehensive platform helping specialty subcontractors run their business from a single interface. This offers peace of mind and the freedom to concentrate on what is most important: Your bids, customers and company success.
Client Review
โWe have been working with Pell Software continuously and can credit the team over there with creating our entire sync capabilities. The team at Pell Software has been a pleasure to work with. They are incredibly professional, talented, responsive and deliver on time. Thank you!โ
- Roni Szigeti, Founder and CEO
