Skip to main content

14 posts tagged with "Etl Extract Transform Load"

View All Tags

ETL - Date Parse enchancement

Increased the ability to transform 12 different date formats in datasources to dates in ISO 8601 so they can be loaded correctly to Fenergo.

Three additional formats are now supported:

  • yyyy/MM/dd (e.g., 2024/03/15)
  • yyyy.MM.dd (e.g., 2024.03.15)
  • yyyy-MM-dd (e.g., 2024-03-15)

Static Access Layer Assignment During ETL Migration

This enhancement introduces the ability to assign static access layers during data migration by utilising the BusinessAccessLayer and GeographicAccessLayer fields. These fields can now be included in the data source and mapped in the system fields section, allowing for manual assignment of access layers across supported data types. Static access layers are not supported for Product and Associations data types.

ETL Investment and Bank Accounts

This enhancement introduces ETL support for the creation and management of investment and bank account data, enabling seamless migration into Fenergo. Users can now create and update account records while establishing relationships between investment accounts, bank accounts, funds, and investors.