Create JDBC database definitions

Extesion: Web Service Wizards
Since version: 8.0

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:

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:

database server name

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:

database server IP or host name

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:

database 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:

Credentials 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:

confirmation

Click on Continue to generate the required database definitions.