24.1 Preparations for using an external database
This section describes the preparations necessary to use an external database.
To use a JP1/AJS3 system with an external database, before setting up JP1/AJS3, make the following preparations:
-
Create instances of the external database to be used in JP1/AJS3
-
Create databases of the external database used in JP1/AJS3
Create a database or databases for managing the execution agent information and the scheduler service. The execution agent information and scheduler service can be managed by using the same database or by using separate databases.
However, to set up multiple scheduler services, you must create a separate database for each scheduler service.
-
Install the ODBC driver
Install the ODBC driver on the manager host. For details about the version of the ODBC driver to be installed, see the Release Notes.
-
Prepare the ODBC file data source
The following table shows the items to be specified in the ODBC file data source to be used in JP1/AJS3.
Table 24‒1: Information to be specified for ODBC file data source items No.
Specification item
ODBC file data source item
1
Connection-destination server address#1 and port number
SERVER
2
User name
UID
3
Password
PWD
4
ODBC driver
DRIVER
5
Description#2
DESCRIPTION
- #1
-
Connection between JP1/AJS3 and the external database does not depend on the JP1/Base communication settings. Therefore, make sure that the IP address can be resolved by using the OS functions such as the hosts file and the DNS.
- #2
-
You can omit specifying this parameter.
The following shows an example of specifying ODBC file data source items:
-
Connection-destination server address: sqlsvr.example.com
-
Connection-destination server port number: 1433
-
User name: user1
-
Password: pass1
-
ODBC Driver: ODBC Driver 17 for SQL Server
[ODBC] SERVER=sqlsvr.example.com,1433 UID=user1 PWD=pass1 DRIVER=ODBC Driver 17 for SQL Server
Note that a single ODBC file data source can be shared with the agent management database and scheduler database. For details about how to set up the external database, including how to create instances and databases, see the documentation for the cloud environment and DBMS that you are using.
After preparations for using the external database are complete, set up JP1/AJS3. If you have just installed JP1/AJS3 as a new installation, you do not need to export data from the embedded database to the external database. In such a case, see 24.2 Setting up JP1/AJS3 to use an external database. To export data from the embedded database that is currently in use to the external database, see 24.3 Exporting data from the embedded database currently in use to the external database.