A leading real estate and financial services asset management company needed assistance migrating their legacy on-premises data environment that had become difficult to manage. Some key parts of the legacy system relied on Microsoft Excel and a web application. Loading data was complex and manual, and a lack of data governance needed to be addressed. The client asked Imaginet to upgrade the application using a more modern development stack to clean up and standardize how data was loaded and processed.
Using Azure Data Factory as the primary method for data integration (ETL) processes, the Imaginet data engineering team moved the data environment into Microsoft Azure cloud services, with a data lake for storage. For the web application, we converted to Angular and a more up-to-date .NET Framework stack.
Imaginet utilized Azure DevOps to put all web and data code assets in source control and built pipelines to automate builds and releases to implement Continuous Integration/Continuous Deployment (CI/CD) processes. Releasing new functionality quickly and consistently ensured that the customer realized the business value early, with much higher quality and lower risk.
The client was providing a daily data feed to a third party to do risk processing. The updated data environment was much more accessible and accurate, improving the experience when working with external sources.
With Imaginet’s help, the client has a new standardized process for loading data. With a more modern platform and strategies around source control, Azure resource uses, CI/CD processes and releases, and data intelligence, they are better equipped for success and proper tracking. They can adequately assess the quality of their data and provide information to decision-makers to make better selections due to their upgraded development stack.
Our team has been working hard these last few months, and we are excited to share our success with you. Don’t forget to subscribe to our newsletter to stay updated on our most recent Microsoft 365 projects. Fill out the form at the bottom of the page if you would like to work with us and someone will be in touch.
discover more
A well-established global charitable organization contacted Imaginet to assist in implementing Microsoft Teams across the organization, as well as creating separate teams for each department. The goal was to have an accessible space for team members to collaborate. The organization…
Last week, we published a blog that provided tips for protecting your Microsoft 365 products against malicious cyber threats. Cybersecurity is not something to take lightly, and with technology constantly evolving, it is important to understand how you can protect…
A provincial agricultural services corporation was experiencing challenges with its reporting solution. They were starting to use Power BI to replace operational reports that had previously used data from a DB/2 operational database. With data often duplicated and limited staff…
Let’s Build Something Amazing Together
From concept to handoff, we’d love to learn more about what you are working on.
Send us a message below or drop us a line at 1-800-989-6022.