Integration with EcoVadis
Introduction
Parakeet Risk ingests EcoVadis sustainability ratings to strengthen third‑party and supply chain risk programs in manufacturing, pharmaceuticals, and consumer goods. This page documents supported onboarding options, sync cadence, field mappings, normalization rules, automation hooks, and governance. Customer‑licensed; no sponsorship implied.
-
Audience: Compliance Officers, Supply Chain Risk, EHS, and Operations.
-
Prerequisites: An active EcoVadis subscription with export/API access held by the customer; supplier master data available in your ERP/TPRM (e.g., NetSuite or Sage).
-
Purpose: Centralize ratings, trigger corrective actions, and maintain audit‑ready evidence across Parakeet workflows, dashboards, and Rosella AI analyses (Rosella AI Agent).
Data onboarding and cadence
Parakeet supports multiple ingestion paths to accommodate customer licensing and IT constraints:
-
Secure file drops: Customer‑provided CSV/XLSX/PDF rating exports ingested via scheduled jobs in Parakeet.
-
API sync: Customer‑provisioned credentials to EcoVadis endpoints (where licensed) configured in Parakeet’s integration hub (Integrations).
-
Manual upload: One‑off or backfill uploads for historical baselining.
Cadence (configurable per workspace):
-
Default daily sync (nightly, customer time zone).
-
Optional hourly syncs for high‑change vendor cohorts; weekly/biweekly for low‑criticality suppliers.
-
Backfill: Rolling 24‑36 months of history when available to enable trend and seasonality analysis.
Data handling:
-
Change detection: Only deltas are processed to minimize noise and preserve lineage.
-
Idempotency: Replays result in deterministic state; duplicates are deduped during identity resolution.
Field mapping summary
Typical fields customers map from EcoVadis into Parakeet. Exact names vary by export/API; mappings are configurable.
| Source field (EcoVadis example) | Parakeet entity | Parakeet field | Type | Notes |
|---|---|---|---|---|
| Supplier unique ID (e.g., D‑U‑N‑S, vendor code) | Third‑party > Supplier | identifiers[] | string | Used for entity resolution and deduplication. |
| Legal/business name | Third‑party > Supplier | name | string | Canonical supplier name. |
| Country/region | Third‑party > Supplier | country_code | string | Normalized to ISO 3166‑1 alpha‑2. |
| Industry/NACE/NAICS | Third‑party > Supplier | industry_code | string | Harmonized to customer’s taxonomy. |
| Overall EcoVadis score (0–100) | Risk metric | sustainability_score.raw | number | Stored verbatim; see normalization. |
| Medal level (Platinum/Gold/Silver/Bronze/None) | Risk metric | sustainability_score.medal | enum | Canonicalized to finite set. |
| Theme scores (Environment, Labor & HR, Ethics, Sustainable Procurement) | Risk metric | theme_scores{} | object | Per‑theme 0–100 scores. |
| Assessment date | Evidence | assessed_at | datetime | Converted to ISO 8601 UTC. |
| Next reassessment due | Control task | next_assessment_due | date | Drives reminders and calendar events. |
| Corrective Action Plan (CAP) status | Workflow | cap.status | enum | Triggers tasks and alerts. |
| CAP due date(s) | Workflow | cap.due_at | datetime | SLA monitoring. |
| Issue flags/observations | Evidence | findings[] | array | Linked to supplier record. |
| Document/report link or attachment | Evidence | artifacts[] | file/url | Stored with checksum and audit trail. |
Normalization and identity resolution
Parakeet preserves source values and derives standardized, analytics‑ready metrics:
-
Score normalization: sustainability_score.raw retained; sustainability_risk_index derived by inversion or client‑defined weighting. Default: risk_index = 100 − raw (bounded 0–100). Weighted blends with theme_scores supported to emphasize critical domains.
-
Medal canonicalization: Platinum/Gold/Silver/Bronze/None mapped to enum; unexpected values flagged for review.
-
Industry mapping: Source NACE/NAICS harmonized to customer’s vendor taxonomy; fallbacks logged as “Unmapped.”
-
Geography: Country normalized to ISO 3166‑1 alpha‑2; region/state to ISO 3166‑2 where available.
-
Dates/times: Converted to ISO 8601 UTC; source time zone retained in metadata.
-
Identity resolution: Supplier entities unified using prioritized keys (D‑U‑N‑S > tax ID > ERP vendor ID > name+country); fuzzy name matching requires at least one hard identifier; merges are fully auditable.
-
Data quality guards: Completeness thresholds enforce required fields (identifier, name, score, assessed_at). Records missing critical attributes are quarantined for remediation with Rosella suggestions.
Automation, alerts, and downstream workflows
Normalized data powers cross‑tool automations and collaboration:
-
Degradation alert: If sustainability_score.raw drops ≥ X points or medal tier declines, Parakeet issues an alert to Slack or Microsoft Teams and opens a remediation card in Trello.
-
CAP governance: CAP overdue items auto‑escalate to risk owners; evidence requests generated as Google Docs with versioned audit trail (Google Docs).
-
Calendar hygiene: Next reassessment windows automatically populate team calendars to prevent lapse (Google Calendar).
-
Supplier segmentation: Theme_scores support targeted EHS or sustainability audits in plants using Parakeet’s EHS Control Center (EHS).
Setup steps
1) Provide licensing confirmation and data access method (file exports or API credentials). Customer retains all EcoVadis licensing. 2) Upload a supplier ID crosswalk (ERP vendor ID, D‑U‑N‑S, tax ID) to maximize match rates. 3) Configure mapping in Parakeet: fields, enum harmonization, and score weighting policy. 4) Choose cadence and backfill window. Enable delta processing and quality gates. 5) Activate automations: alerts, task creation, calendar sync, and evidence templates. 6) Validate in a staging workspace; promote to production with monitoring enabled.
Governance, auditability, and evidence
-
Lineage: Every record retains source, import job ID, checksum, first‑seen/last‑seen timestamps.
-
Least privilege: API keys and files stored under workspace‑scoped secrets; access logged.
-
Evidence trails: Attach EcoVadis reports to controls, link findings to corrective actions, and surface them in audit‑ready ISO workflows (Certification Automation).
FAQs
-
Do we need an EcoVadis partnership? No. Customers bring their own licenses and data exports/API access. Customer‑licensed; no sponsorship implied.
-
Can we blend ratings with financial or insurance risk? Yes—combine with QuickBooks, Sage, or Canopy Connect to correlate sustainability changes with spend, exposure, or insurance posture.
-
How do we avoid false positives on name variations? Use D‑U‑N‑S or ERP vendor IDs in the crosswalk; Parakeet uses deterministic precedence before any fuzzy heuristics.
Disclaimer
Customer‑licensed; no sponsorship implied. EcoVadis is a third‑party system owned by its respective rights holders. This page describes a customer‑configured integration within Parakeet.