Connecting to, and disconnecting from, databases
When working with databases, the first thing you would do with most development platforms is to establish a connection with the database. There are many types of databases that are used, the most widely used being the following:
- SQL or Oracle
- SQLite
- MS Access
A connection to all of these database types can be established using a connection string, which is also quite often used for bespoke or propriety databases. Automation Anywhere is designed to connect to the most common database types by just providing the key connection details, such as the server/database name and user credentials. It also provides the means to connect via a connection string. This removes any restrictions, allowing you to connect to any type of database for your automation needs.
As with most connections in Automation Anywhere, it uses a session to identify each connection. The Database: Connect action is used to create a database session...
