Connecting to Altibase DBMS

This section describes, in the form of a tutorial, the basic steps that must be taken in order to connect to an Altibase database. The usual workflow when working with Altibase is as follows:

  1. Import a JDBC driver file to be used when connecting to an Altibase database
  2. Add a database connection
  3. Connect to the database
  4. Conduct replication administration tasks as required
  5. Disconnect from the database
  6. Edit DB connection information
  7. Remove the database if it is no longer needed

Each procedure is conducted as described below.

Importing a JDBC Driver File

This section describes the steps involved in importing the appropriate version of the JDBC driver file into Replication Manager. It is assumed that an Altibase database has already been installed on the machine in question. (If an Altibase database has not been installed, it will be necessary to download the appropriate driver from http://atc.altibase.com.) To import the JDBC driver, do the following:

1. Click on the "JDBC Driver Manager" icon in the toolbar to open the "JDBC Driver Manager" dialog box.

2. In this dialog box, click on the "+" icon on the right to open the "Import JDBC driver file" dialog box.

3. Select a JDBC driver file to import and give the file a name to be used in Replication Manager. The source file will be copied into the specified directory and renamed as specified.

4. Close "JDBC Driver Manager" dialog box.

Alternatively, users can import a JDBC driver file when performing the "Adding a Database connection" task.

Adding a Database Connection

Now, it's time to add a database connection for managing replication objects. Follow these steps to add a database:

1. Open the "New DB Connection" dialog by clicking on the "New DB Connection" icon in the main toolbar, or by right-clicking on the DB Connections icon in the DB Connections panel and then left-clicking on the "New DB Connection" item in the context menu that appears.

2. The "New DB Connection" dialog box shown below will appear. Fill in the input fields as described below.



Basic information Options

3. Click on the "Test Connection" button to ensure that the connection works as expected.

4. Finally, click on the "Save" button.

Connecting to the Database

Once Altibase has been installed and the first two tasks have been completed, you are ready to connect to a database. To connect to a database, complete the following steps:

1. Select the newly added database connection. In this example, the newly added database has the name "MyAlti" and is accessed through port number 24439. Right-click on the newly added database to display the context menu, and then left-click on "Connect". This may take some time, depending on your environment.

2. When you are successfully connected, you will see the replication objects in the target database.

3. If the connection fails, a warning dialog appears, displaying some information that will be of help in successfully establishing a connection.

Working with the Connected Database

If you have followed the preceding steps successfully, you are ready to manage replication on the connected database.

Disconnecting from the Database

After finishing your work, it will be necessary to close the connection with the database. To close a connection with a database, select the target database connection. To open the context menu, right-click on the target database, and then choose "Disconnect" from the context menu.

Editing DB Connection Information

It will sometimes be necessary to edit database connection information. For example, it may be necessary to change the account that is used to establish the database connection. This is possible only when not connected to the database in question. There are six steps involved in editing database connection information.

1. Select the database for which it is desired to change connection information. To open the context menu, right-click on the database, and then choose "Edit" from the context menu.

2. Make the required changes to the connection information.

Click on the "Test Connection" button to ensure that the connection works as expected.

3. The dialog box shown below will appear if the Test Connection is successful. Click on the "OK" button to close this information box.

4. Finally, click on the "Save" button in the Edit dialog box.

Removing a Database Connection

When a registered database is no longer in use, you will probably want to remove it from the DB Connections panel.

To remove a database, select the target database connection. To open the context menu, right-click on the database connection to be removed, and then left-click on "Remove" in the context menu.