|
Databases |
Databases |
Connection to Oracle Databases |
|
One of AE's components is an agent that can be used to establish connections to databases. It facilitates the execution of SQL statements in these databases without an external command line tool being required. In doing so, security is increased and databaseA database is an organized collection of data including relevant data structures. 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.
The Job object includes an editor that makes it easy 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 an error occurs during job execution or if the job aborts, the agent cancels all SQL statements until the last COMMIT. The Job object provides many possible ways to configure the execution of SQL statements.
The AE agent for databases currently supports Oracle, MSSQL, DB2 and MySQL.
See also: