The SQL Database Agent
One of AE's components is an agent that can be used to establish connections to databases.
Advantages of using the SQL Database Agent are as follows:
- SQL statements can be executed in a database without the need of an external command line tool.
- Security is increased and database administration simplified.
- In addition to typical SQL statements such as SELECT or UPDATE, the agent can process database-specific commands and stored procedures in the database.
Note: The Job object includes an editor to specify SQL statements. Additionally, it displays database tables and columns.
The result of the SQL statements are stored in a job report, which can be read using the script statement PREP_PROCESS_REPORT.
If a job execution error occurs or a job aborts, the agent cancels all SQL statements since the last COMMIT. The Job object provides many ways to configure the execution of SQL statements.
The AE agent for databases supports the following databases:
- ORACLE
- MSSQL
- DB2
- MySQL
- HANA
- PostgreSQL
- EXASOL
- GENERICJDBC
Note: This integration capability, like all integrations of the Automic system, can support service orchestration workflows. Such workflows orchestrate automated processes that run across multiple platforms, domains, and applications to deliver a specific IT service.