ActiveBatch Database Creation

As you can imagine, the various objects and properties that make up ActiveBatch need to be stored somewhere. Objects and properties are stored in a database. ActiveBatch supports several popular database products. See Databases for more details.

 

A database is made up of many things, but among the most important are a series of tables and columns (fields) that allow for persistent access to the data. The ActiveBatch configuration procedure will take care of creating those tables and other objects. Typically, you will also have the ActiveBatch configuration option create the database at the same time.

 

Oracle Database Definition

 

To install the ActiveBatch Job Scheduler for Oracle database support, the Job Scheduler/installation machine must have Oracle for OLE/DB and Oracle ODBC for Oracle installed.

 

\

 

The figure above is taken from an Oracle 18c Client Installation kit. You would select Oracle ODBC Driver, Oracle Provider for OLE DB and then Oracle Data Provider for .NET. Starting with Oracle 12c, a Pluggable Database (PDB) must already be in place prior to the Job Scheduler configuration. If one has not been created, follow Oracle's instructions for PDB creation. In addition, the SYSTEM user account is needed as the installation will create the tablespace file for the schema user during the installation. The SYSTEM account credentials are not saved or used once the installation has completed.