Using Power FX for Collaboration Platforms

Voronkov I. A., Saradgishvili S. E.

This article is devoted to an example of organizing work on building ETL processes in an enterprise contour. This technique can serve as an illustration of the idea of two key trends in the development of IT technologies: the simultaneous growth of opportunities that are provided by certain software products in conjunction with a decrease in the entry threshold. The review is carried out on the Microsoft 365 platform. Separately, we note that this language is part of the Power Platform. This is a relatively new vision of Microsoft corporation about the business data warehouse as a single point of connection and storage of data, tools. Together with the Power platform authors researched the Power automate product - a workflow designer, partly the successor to SSIS, SharePoint workflow engine. These tools can automate enterprise activities. To enhance the ability to develop with third-party technologies and programming languages, Microsoft has introduced the Microsoft Graph API.

Keywords:ETL, Collaboration Platforms