🌿
Mother Earth CryingClimate Awareness · OECS
System Architecture

Technical Integration Architecture

Four-layer architecture connecting the G &C Finance Platform to Infor CloudSuite and international climate finance reporting frameworks. Click any layer to explore its components.

Portal: Online
API: Healthy
DB: Connected
Sync: Active

System Layers

Click a layer to inspect its components

External Systems

International reporting frameworks and climate finance bodies that consume GCFT data.

🌿

Green Climate Fund

GCF Readiness

🌍

UNFCCC BTR

Biennial Transparency

📊

SDG VNR

SDG 13 Reporting

🌊

CARIFORUM

Regional Reporting

MRV Reports → GCF / UNFCCC / SDG

GCFT Web Portal

The React-based tagging portal deployed on Global Platform infrastructure. All user interactions occur here.

📈

MRV Dashboard

KPIs & Charts

🏷️

Tagging Wizard

4-Step Flow

📋

Report Engine

6 Report Types

🔒

Audit Trail

Immutable Log

REST API calls (JSON / JWT)

RESTful API Layer

The integration middleware that translates between the GCFT portal and Infor CloudSuite's database.

🔐

Auth / SSO

Active Directory

🔄

Sync Engine

Offline Queue

Tag Validator

Business Rules

📤

Export API

CSV / JSON / PDF

SQL queries / stored procedures

Infor CloudSuite / PFM Database

The Global Platform's core financial management system. GCFT tags are stored as extended attributes.

💰

Budget Lines

Core Table

🏷️

GCFT Tags Table

Extended Attributes

📝

Audit Log Table

Immutable Records

👥

Users & Roles

RBAC Store

GCFT Web Portal

The React-based tagging portal deployed on Global Platform infrastructure. All user interactions occur here.

📈

MRV Dashboard

KPIs & Charts

🏷️

Tagging Wizard

4-Step Flow

📋

Report Engine

6 Report Types

🔒

Audit Trail

Immutable Log

Database Integration Pathways

Pathway A — Native Extension

Recommended

Direct SQL extension of the Infor CloudSuite database schema. Adds GCFT columns to existing budget_lines table via ALTER TABLE. Lowest latency, tightest integration.

Advantages

  • Real-time data consistency
  • No ETL overhead
  • Single source of truth
  • Native transaction support

Considerations

  • Requires DBA access to production schema
  • Upgrade risk on CloudSuite updates

Technologies

PostgreSQL / MS SQLStored proceduresDB triggersRow-level security

Technology Stack

Frontend

React 19TypeScriptTailwind CSS 4RechartsWouter

API Layer

REST / JSONJWT AuthActive Directory SSORate Limiting

Offline

IndexedDBService WorkerBackground SyncConflict Resolution

Database

Infor CloudSuitePostgreSQL / MS SQLRow-Level SecurityAudit Triggers

Reporting

PDF ExportCSV / XLSXGCF TemplateUNFCCC BTR Format

Security

RBACTLS 1.3Audit LoggingSession Management

SIDS Resilience: Offline-First Design

Addressing the platform member state's bandwidth and connectivity constraints

💾

IndexedDB Queue

Tags created offline are stored locally in the browser's IndexedDB and queued for sync.

🔄

Background Sync

Service Worker monitors connectivity and automatically syncs queued tags when online.

Conflict Resolution

Server-side timestamp comparison resolves any conflicts between offline and online edits.

Security & Compliance Architecture

GCF accountability and Global Platform data governance requirements

TLS 1.3

All data in transit encrypted

RBAC

Role-based access control with 5 permission levels

Audit Logs

Immutable, timestamped record of every action

SSO / AD

Single Sign-On via Active Directory