Charlie Mac and Associates

  1. Newsletters

Hassle Free Data Migration ๐Ÿ“‚โ†—๏ธโ˜๏ธ

Whilst working at a Water Corporation a while back, I had to migrate 250k records from Records Manager toย Content Manager 9. The documents themselves were straightforward, but the transformations of the related metadata were extreme (including nested lists). I used Power Query for this and although good for understanding data quality, it was very manual and would hang on large datasets.

Finding a good and cost effectiveย ETL (Extract, Transform and Load)ย platform is difficult, particularly something that is corporate grade. You maybe familiar withย FME Workbenchย – particularly those of you that look after GIS. Itโ€™s a great tool but expensive. Youโ€™ll be pleased to know that there is a cloud based Microsoft equivalent –ย Azure Data Factory.

We are using Data Factory to pull data from a data warehouse (containing legacy ERP data), perform some minor transformations, and then push it into theย Dataverse. The data is then made available to staff using a model driven PowerApp. It gives staff ready access to the data in a secure way. In addition, they get theย power of AI assisted searchingย (like recognizing common abbreviations and acronyms), and this old data can be combined with new data in the Dataverse.

Old and new worlds collide with Data Factory and the Dataverse to create the one thing we all are searching for – one complete view of corporate data.

Across the Industry

Recent Government Tenders

Microsoft News

Comments to: Hassle Free Data Migration ๐Ÿ“‚โ†—๏ธโ˜๏ธ

Your email address will not be published.

Attach images - Only PNG, JPG, JPEG and GIF are supported.

Login

Welcome to Typer

Brief and amiable onboarding is the first thing a new user sees in the theme.
Join Typer
Registration is closed.