13 posts tagged with "ETL"

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 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.

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.

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 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.

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.

Adding to the recent release of ETL Post Processing, you can now apply Product Access Layers during ETL migrations, ensuring migrated data aligns with access and security standards.

This capability can be enabled per ETL project using Post Load Actions. Once ETL Load completes, the recalculations run asynchronously and apply to all Products included in the migration.

• Dynamic Product Access Layers: Re-evaluates and applies rule-based access control for Products. Where Products satisfy a Dyanmic Access Layer rule with 'Product' data type, the associated Access Layers will be assigned. If no rules are met by a product or if the toggle is disabled in the ETL project, then default access layers (Enterprise and Global) will be applied.

ETL Post Processing enables automatic recalculation of Dynamic Access Layers (DAL) and Jurisdiction assignments for entities created or updated during ETL migrations, ensuring migrated data aligns with standard platform governance and policy rules.

This capability can be enabled per ETL project using Post Load Actions. Once ETL Load completes, the recalculations run asynchronously and apply to all entities included in the migration.

• Dynamic Access Layers: Re-evaluates and applies rule-based access control for supported entity types.
• Jurisdictions: Recalculates jurisdiction applicability, adds newly applicable jurisdictions, and updates policy versions.

ETL Virtual Documents enables the bulk migration of both Entity and Product virtual documents into Fenergo, allowing document records to be created and linked without requiring a physical file upload. This supports structured document metadata ingestion, validation, and association to the correct legal entity or product with appropriate classification and access controls.

ETL Entity 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 legal entity with the appropriate metadata and access controls.