Database handling in WinAutomation

Intermediate
App Maker
Developer
Functional Consultant
Power Platform
Power Automate

Note

Effective November 2020

  • Common Data Service has been renamed to Microsoft Dataverse. Learn more.

  • Some terminology in Microsoft Dataverse has been updated. For example,entity is now table and field is now column. Learn more.

Modules will be updated soon to reflect the latest terminology.

Databases are vital components of every organization, and efficient data handling is necessary for their effective operation. WinAutomation provides organizations with the ability to automate databases through the database actions.

Learning objectives

In this module, you will:

  • Compose a connection string to connect to a database.
  • Use the appropriate action to run queries on a database.

Prerequisites

  • Basic familiarity with WinAutomation
  • An SQL database with at least one table that contains data