Create JDBC database definitions
Last updated
Last updated
This wizard allows you to create administrative definitions for JDBC connections to a number of common databases.
This wizard does NOT install the requisite driver classes and does not configure the relevant class path to include those same driver classes.
The starting point is the selection of a database provider:
If your database is not found in the list, you must refer to the documentation library for information on how to install the definitions manually.
The next step is to select a database server to connect to:
You will have the option of creating a new database server or using an existing one.
Note: For connectivity purposes, and defined server other than template servers can act as a database server.
If you choose to create a new database server, you must supply a server name and the IP address or host name for the server:
The name must be at least 2 characters and may not contain spaces or characters invalid for a URI (such as “:”, “/”, “?”, “&” etc.).
This name is only relevant within the Octopus console, it does not have any network level significance. If you have a physical server that is running multiple instances of the same database on different ports, you will need to provide a unique name for each instance.
The next step is the port number:
The wizard already knows the default port number for each of the databases it can create definitions for. If no port number has been given to you, we suggest you try the default provided by the wizard.
The final step before completion is to provide a User ID and Password for the service account you will use to connect to the database:
This account must have the requisite credentials to perform any type of procedure or query that you wish to execute against the database.
The last step is a confirmation that you have completed your choices:
Click on Continue to generate the required database definitions.
