- Updated: 2020/09/28
Use the Database command to convert, export, import, or transfer data between a database and other applications.
- Connects to a database.
- 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.
- 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
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.
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).