Articles → AUTOMATION ANYWHERE → ‘Database’ Command In Automation Anywhere 10.5

‘Database’ Command In Automation Anywhere 10.5

In this article, we will use ‘Database’ command to connect to SQL server database and export the data from database table to CSV file.

Database Command

‘Database’ command is used to perform operations with data source (SQL server, MS Access etc.). If we expand the command, we will see following actions

Connect – to establish a connection with data source.
Disconnect – to disconnect the established connection with data source
SQL Query – to execute any SQL query
Insert/Update/Delete – To execute insert/update/delete query.
Run stored procedure – to execute stored procedure.

Picture showing the database commands in automation anywhere

Click to Enlarge

Database Table

For this article, we will be using a table with the following data

Picture showing the sample table with records

Click to Enlarge

Working With Database

We will follow these steps

Connect to the database
Execute SQL query and export data to CSV file.
Disconnect.
Open the CSV file.

Connect To The Database

For connecting to the database, we have drag and drop the ‘Connect’ action. Once you do that, following window will come

Picture showing the Connect command for connecting to the database in automation anywhere

Click to Enlarge

Here you must select the button with ellipses (…)

In the next window, you must select the data source. For this article, we are using SQL server.

Picture showing selecting the database engine

Click to Enlarge

Once you click on ‘Next’, you can enter the credentials like server name, user name, password and database name

Picture showing entering the database credentails

Click to Enlarge

Once click ok, connection string will get added.

Picture showing setting up the connection string in the connect command of the Database

Click to Enlarge

Execute SQL Query And Export Data To CSV File.

Next step is to execute the query. For that, you can drag and drop ‘SQL Query’ action. In this window, you can mention the select query and the full path of CSV file where data needs to be exported.

Picture showing writing the select query in the SQL query command

Click to Enlarge

Disconnect

To disconnect the established connection, you can drag and drop ‘Disconnect’

Click to Enlarge

Open The CSV File

Finally open the CSV file.

Picture showing the open csv command for opening the CSV file

Click to Enlarge

Output

Picture showing the values of database tables inside the CSV file

Click to Enlarge

Posted By -	Karan Gupta

Posted On -	Sunday, September 30, 2018

Query/Feedback

Your Email Id		**

Subject		*

Query/Feedback	Characters remaining 250	**