Skip to main content

17 posts tagged with "ETL"

View All Tags

Delete Associations via ETL

ETL now supports the bulk deletion of existing association records using the new Delete Associations data type. Combined with the existing Associations data type, this also enables a net update to an association's relationship type in a single ETL project — deleting the old relationship and creating the new one in the same load.

ETL Alerts

ETL Alerts enables the bulk migration of historical or externally generated alert records into Fenergo via CSV upload. Institutions transitioning from legacy Transaction Monitoring systems can use this capability to seed pre-existing alert data into the platform, ensuring a complete and uninterrupted alert history from day one.

ETL Financial Crime Reports

ETL Financial Crime Reports (FCR) enables the migration of historical FCR records from legacy compliance systems into Fenergo via the ETL pipeline. Migrated records are created in Closed status with a source value of Migrated, preserving the original submission dates and external identifiers from the source system.

ETL Screening History Beta

Clients migrating to Fenergo from a legacy KYC system arrive with years of historic screening activity, runs conducted against providers such as RDC, WorldCheck One and LexisNexis, with adjudicated match decisions and materiality assessments already captured in their source system. Without migrating this data, analysts would be forced to re-screen every entity from scratch and rebuild years of compliance decisions from Day 1.

ETL Screening addresses this by enabling clients to load their historic screening data directly into the Fenergo Screening domain.ETL Screening is currently available as a Beta feature while we conduct performance testing. It can be enabled on request, clients interested in this feature should contact their Fenergo representative.

Document-Level Traceability in ETL Reconciliation Reports

ETL reconciliation reports now include document-level detail on every row, so any row can be traced back to the specific document it relates to. Each row records the Document Model ID, the unique identifier of the document in Fenergo, alongside the Document Path for uploaded documents or the URL for virtual documents.

The additional columns apply to Entity Documents, Product Documents, Entity Virtual Documents, and Product Virtual Documents reconciliation reports, removing the need to cross-reference the original migration bundle when investigating failed loads or post-migration queries.

ETL Journey Launch

ETL now automatically triggers journeys for migrated Individual and Company entities once a data load completes, allowing migrated entities to resume in-progress activities such as Risk Assessment, Screening, and Due Diligence without manual intervention.

Journey Launch is configured per entity type, with an optional filter to control which entities are in scope. A Journey Launch report is generated for each entity type, detailing the outcome for every evaluated entity to support reconciliation.

Static Access Layer Validation in ETL

ETL now validates static Access Layers referenced in a migration file during the validation stage, before any entities are loaded. Any Access Layer that does not exist in the tenant configuration is flagged as a validation error, so the file can be corrected before the load proceeds.

ETL Entity Groups

This release introduces support for migrating Entity Groups through the ETL process in Fenergo. This enables the transfer of Entity Groups, including their hierarchical Parent–Child relationships and verified data, ensuring accurate reconstruction in the target tenant.

ETL Product Documents

ETL Product Documents enables the bulk migration of regulatory and KYC documents into Fenergo, allowing documents to be securely uploaded, validated, virus-scanned, and linked to the correct product with the appropriate metadata and access controls.

ETL Map Lookups: Support NULL Values for Lookup Fields

This update supports key business scenarios such as data corrections and remediation loads, where existing lookup values must be intentionally removed.

  • ETL Map Lookups step accepts NULL as a valid input for lookup fields.
  • Users can proceed to Preview and Load when NULL is provided.
  • Existing lookup values are cleared in the target record when NULL is processed.
  • Behaviour is now consistent across lookup and non-lookup field types in ETL migrations.