Automation Anywhere/Testing Anywhere Fans

02/08/2013

For CONNECTING TO MYSQL DATABASES USING AUTOMATION ANYWHERE

Initial Steps

• As far as the MySQL database is concerned, download the MySQL ODBC Connector 5.1 from the below link:-
http://dev.mysql.com/downloads/connector/odbc/3.51.html
• Once you download it, you can go to Control Panel> Administrative Tools>Data Sources
• In that, open the System DSN Tab, from the Drivers select the above mentioned driver.
You will see the window shown below:- add the details there.

• Once you do that, you can use the same data source name in your task.

Automation Anywhere Steps

• Go to Database Command in a new Task opened by the Task Editor.
• Select Connect from the options
• Use the same DSN created in the process above(Data Link Properties to generate the connection string) and click on Test Connection to check the connectivity.
• And you are good to go! … You can now fire queries on the database to get the desired output.

Note: - The procedures mentioned above are independent of type of the OS, but Automation Anywhere is only compatible with Windows.

02/08/2013

For sample solutions visit our page http://www.automationanywhere.com/support/examples.htm

Automation Anywhere Examples - The Automation Software. Automate Business Processes and IT task easily. Automation Anywhere is a complete automation solutions. It offers web data extraction, data transfer and many more features.

02/08/2013

Task Storyboard !

Automation Anywhere's Visualize Technology features pictorial views of tasks in a storyboard view. The pictorial view of respective actions makes it easier t...