Database command

Use the Database command to convert, export, import, or transfer data between a database and other applications.

Microsoft Access 2007 and Access 2010 users must use Microsoft Office 12.0 Access Database Engine OLE DB Provider.
Connect
Connects to a database.
Disconnect
Disconnects from a database.
SQL Query
Issues SQL queries.
Tip: If using wild cards when executing SQL queries, insert * if using MSAccess or % in MSSQL.
Optional:
  • Specify the number of records to fetch.
  • Specify a time-out value for the query.
  • Export the data file as a CSV (comma-separated) file in a specific location. Exporting data to CSV files supports ANSI, Unicode, and UTF-8 encoding.
Insert/Update/Delete
Specifies an Insert, Update, or Delete operation.
Run Stored Procedure
Runs an existing procedure that is stored in the database.
Add Parameters: Mark the check box to add or update a procedure.

From the drop-down menu, select Input, Output, or InputOutput type.

Export Data to CSV: Mark the check box to save a file in a specified location.
Tip: In the above mentioned commands, press the F2 key to insert a Credential Variable for enhanced security. Read more about Assigning credential variables from credential lockers.

Resources

To learn more, search for the Integrating Database and Applications Using the Database Commands course in Automation Anywhere University: RPA Training and Certification (A-People login required).