Database package updates

Review the updates in released versions of the Database package such as new and enhanced features as well as fixes and limitations. The page also lists the release dates of each version, and the compatible Control Room and Bot Agent versions.

Versions summary

The following table lists the versions of Database package released either with an Automation 360 release or as a package-only release (in descending order of release dates). Click the version link for information about updates in that package version.

Version Release date Release type Bot Agent version Control Room build
5.5.3 15 July 2025 Package-only; post Automation 360 v.37 release 21.88 or later 10204 or later
5.5.2 4 June 2025

Com o lançamento do Automation 360 v.37 (Sandbox) (suporte relacionado a macOS)

 21.88 or later 10204 or later
5.4.0 17 June 2024 With Automation 360 v.33 (Sandbox) release 21.88 or later 10204 or later
5.3.0 22 March 2024 Package-only; post Automation 360 v.32 (Sandbox) release 21.88 or later 10204 or later
vma1698660419945_00007.html#rxc1682768318574__a360.31-database-ga 6 December 2023 With Automation 360 v.31 (Sandbox) release 21.88 or later 10204 or later
5.1.0 16 August 2023 Package-only; post Automation 360 v.29 release 21.88 or later 10204 or later
4.12.2 6 June 2023 With Automation 360 v.29 (Sandbox) release 21.88 or later 10204 or later
Note:
  • To download an individual package (updated in an Automation 360 release where you want only the package), use this URL:

    https://aai-artifacts.my.automationanywhere.digital/packages/<package-file-name>-<version.number>.jar

  • For Database package, the naming convention is: bot-command-database-<version.number>.jar

    For example, bot-command-database-5.2.1.jar

For detailed steps on downloading a package and manually adding it to the Control Room, see Adicione packages à Control Room.

5.5.3

  • Compatible Bot Agent version: 21.88 or later
  • Compatible Control Room version: 10204 or later Fix
When you run a bot using the Database Connect action and use Excel as a database for a longer period, the bot execution no longer gets stuck.

Previously, in such cases, the bot execution would get stuck, causing the automation to halt until it was terminated manually.

Service Cloud case ID: 02190017

5.5.2

  • Compatible Bot Agent version: 21.88 or later
  • Compatible Control Room version: 10204 or later
What's new

Os desenvolvedores cidadãos e os especialistas profissionais em automação agora podem desenvolver e executar automações em plataformas do macOS em seus dispositivos. Esse package foi aprimorado para oferecer suporte ao macOS, garantindo uma experiência uniforme de desenvolvimento e portabilidade.

5.4.0

  • Compatible Bot Agent version: 21.88 or later
  • Compatible Control Room version: 10204 or later
Fix

You create a bot using the Database Connect action with the ODBC connection string, use Excel as a database, then use the Read from action, using Select * into [sheet2] from [sheet1] statement, the bot no longer stuck and now displays an appropriate error message.

Service Cloud case ID: 02113073

5.3.0

  • Compatible Bot Agent version: 21.88 or later
  • Compatible Control Room version: 10204 or later
Fix
The Database package jar file is installed successfully through Cloud updates.

Previously, the scheduled cloud update of packages failed to install the Database package jar file due to an error.

5.2.1

  • Compatible Bot Agent version: 21.88 or later
  • Compatible Control Room version: 10204 or later
What's changed

Atualização interna em pacotes

Atualização menor para oferecer suporte a tarefas de API.

5.1.0

  • Compatible Bot Agent version: 21.88 or later
  • Compatible Control Room version: 10204 or later
Note: Essa versão do package também está disponível na versão v.30 do Automation 360.
What's new
Database package enhancements (Service Cloud case ID: 01881930, 01981681, 00743352, 01938224, 01946530, 01938224)
The following enhancements have been added to the Database package for Pro and Citizen Developers.
  • Ability to share the Database session across parent and child bots.
    • You can now create a new global session using the Database > Connect action and pass this session from a parent to child bots or reuse this session in other actions of the Database package. This feature ensures data consistency in each bot because you perform the database operations on a standard set of data.
    • You can create a new session variable of the type database session to store the database sessions.
    • The existing session name field has been renamed to Create Database session.
  • In default mode, you can now define connection strings with variables to substitute credentials such as username and password or any other security-related data in the Connect action. You can map these variables with credential vault values to ensure that sensitive information is not exposed in the connection string.
  • You can now connect to any database with the JDBC connection string for the user-defined database option. This helps to significantly reduce development time and maintenance overhead because you are no longer required to automate processes that involve other databases.

Como usar a action Conectar para banco de dados

What's changed
Changes to storing the database schema in Disconnect action (Service Cloud case ID: 00743352, 01938224, 01946530, 01938224)

In the Disconnect action, if you select the Keep database schema in cache until bot finishes running option and then try to create a new database session after the Disconnect action, while keeping the same session name as the previous one, an error occurs, and the new database session is not created. To avoid this, leave the Keep database schema in cache until bot finishes running option unchecked.

Desconectar action

Fixes
For the Insert/Update/Delete action in the Database package, the 'Stream Closed' error is no longer displayed when you run a large SQL query (up to 65K ASCII text) over an ODBC connection.

Service Cloud case ID: 01991720
Fixed the vulnerabilities reported in the security scan.

Service Cloud case ID: 01967285

4.12.2

  • Compatible Bot Agent version: 21.88 or later
  • Compatible Control Room version: 10204 or later
Fix
Fixed the vulnerabilities reported in the security scan.

Service Cloud case ID: 01967285