Data Access Types for Legacy Data Integration
Question
A company has a legacy MS Access invoicing application that runs on Windows Server 2016
For its Power Platform solution, the company stores data in the Dataverse and Azure table.
The company invites you as a Solution Architect to help automate and integrate the legacy data with the current data sources.
What two data access types would you use in your solution design?
Answers
Explanations
Click on the arrows to vote for the correct answer
A. B. C. D. E.Correct Answers: B and D
As a Solution Architect, you need to design automation and integration for the company's data flow.
For the automation of the legacy data, you can use the Desktop flow.
Power Automate Desktop flow automates processes on legacy, modern desktop, and web applications.
There are two types of Desktop flows automation on the windows desktop and the web application.
The Desktop flow runs only on Windows-based machines.
The device needs to run Windows 10, Windows Server 2016, or 2019
You can create a Desktop flow using Power Automate Desktop or alternative solutions involving Windows recorder and Selenium IDE.
When you automate the Desktop flow execution using an instant flow, you need to connect your instant cloud flow with the Power Automate Desktop application running on the Windows-based device.
You must install an on-premises data gateway for this purpose.
Power Automate Desktop flow interacts with the application using its elements, images, and coordinates.
Azure table provides storage for NoSQL data.
For the Azure table, you need to use the Azure Table Storage Connector.
You can use this connector with Power Automate and Logic Apps.
All other options are incorrect.
For more information about Power Platform connectors, please visit the below URLs:
Based on the scenario provided, the company has a legacy MS Access invoicing application running on Windows Server 2016, and it is now storing data in Dataverse and Azure Table. As a solution architect, you need to automate and integrate the legacy data with the current data sources. To do this, you can use the following two data access types in your solution design:
Azure SQL Connector: The Azure SQL Connector can be used to connect to a Microsoft Azure SQL database that stores the legacy data. This connector allows you to read and write data from and to the SQL database. By using this connector, you can easily integrate the legacy data with the new data sources.
Azure Table Storage Connector: The Azure Table Storage Connector can be used to connect to an Azure Table storage account that stores the current data. This connector allows you to read and write data from and to the Table storage account. By using this connector, you can easily integrate the current data with the legacy data.
The other options, Azure Data Explorer, Data Gateway, and SharePoint Connector, are not relevant to this scenario as they do not provide a direct way to integrate the legacy data with the current data sources.
In summary, the two data access types that you would use in your solution design to automate and integrate the legacy data with the current data sources are the Azure SQL Connector and the Azure Table Storage Connector.
