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.