Solution Architecture Diagram ( end to end)
On-premises MS-GP ERP platform topology and integration architecture
GP Solution Architecture Diagram
Source: Aidacare_GP_Solution Architecture.png
Deployment Model
On-Premises
Hosting
Aidacare Data Centre (On-premises)
Access Method
Citrix Virtual Apps & Desktops 2203 LTSR → Remote Desktop Connection (RDC)
Environments
Development / Test / Production
Primary App Server
AIDAGPDEV01V (10.26.21.43)
Domain Controller
AIDADC02V (10.26.21.4)
SQL DB Server
AIDASQL01P
OS
Windows Server 2019 Datacenter
Source
Aidacare ERP MS-GP Infrastructure Details.docx (QR-IT-INF-001 V0.1)
Server Topology
Source: Aidacare ERP MS-GP Infrastructure Details.docx| Server Name | IP Address | Role | Key Apps / Components |
|---|---|---|---|
| AIDAGPDEV01V | 10.26.21.43 |
GP Application Server | GP 18.0.1739 SmartConnect 21.1.0.10 Dexterity 18.00.0028 SmartView 2.0.70 WennSoft 14.0.2.0 |
| AIDADC02V | 10.26.21.4 |
Domain Controller / Citrix | Citrix VA&D 2203 LTSR |
| AIDASQL01P | TBD | SQL Database Server | SQL Server 2019 (15.0.4445.1) GP Databases (27 incl. DYNAMICS, HANDR, TWO) |
| AIDABCODE01V | 10.26.21.85 |
Barcode / Label Server | PanatrackerGP 7.11.0.0 NiceLabel |
| AIDASMFR01V | 10.26.21.49 |
FreightMaster Server | FreightMaster 4.0.0 React / NodeJS |
| AIDAPOS01V | TBD | POS / eInvoicing Server | POS Envisage 4.0.2 PostMaster Connect React / NodeJS |
Integration Architecture
SmartConnect Primary MiddlewareSmartConnect (eOne Solutions v21.1.0.10) is the PRIMARY integration middleware, managing 50+ integration jobs across all connected systems.
Sources
ODBC
Excel / CSV
REST APIs
Targets
GP Modules
SQL Databases
Web Portals
Data Flow
Source Systems
ODBC / Excel / REST
ODBC / Excel / REST
SmartConnect
v21.1.0.10 — 50+ jobs
v21.1.0.10 — 50+ jobs
eConnect
Real-time GP posting
Real-time GP posting
Microsoft GP
v18.0.1739.000
v18.0.1739.000
No direct DB writes permitted. All transactional posting to GP must go through eConnect. Direct SQL writes to GP databases are prohibited to preserve data integrity and audit trails.
Dominant Pattern
Batch-based processing
Also Used
Near-real-time, file-triggered
Error Handling
SmartConnect logging mechanisms
| Method | Used For | Direction | Notes |
|---|---|---|---|
| eConnect | Real-time GP transactional posting | Inbound to GP | No direct DB writes allowed. Used by PanatrackerGP, ECHIA, WennSoft |
| SmartConnect Jobs | Batch data sync (50+ jobs) | Bi-directional | Primary middleware. WennSoft, CMP, CRM, OmniPrice integrations |
| ODBC | Direct SQL queries | Outbound from GP | Read-only reporting, SmartList, SmartView |
| REST API | External SaaS platforms | Bi-directional | SmartFreight, Radaro APIs |
| File-based CSV/Excel | Batch file exchange | Inbound to GP | Excel-triggered SmartConnect jobs, WennSoft models |
Application Stack
Source: Aidacare ERP MS-GP Infrastructure Details.docxCore ERP
Microsoft Dynamics GP
SQL Server 2019
Dexterity
Integration / Middleware
SmartConnect (eOne)
eConnect
Custom Applications
POS (Envisage)
FreightMaster
ECHIA
PanatrackerGP
Finance / Document
Docuphase / OnPhase
PostMaster Connect (eInvoicing)
Logistics
SmartFreight
Radaro
Reporting
Management Reporter
SSRS
SmartView
Popdock
Infrastructure
Citrix VA&D
Goliath Monitoring
Unitrend Backup
Metalogix / Quest