Configure Database Connections

MDB Admin Console CLI › Configure Database Connections

Configure Database Connections

MDB Admin Console uses connection names to reference the MDB databases for its operations. Therefore, before using the MDB Admin Console, you need to define the connection names for the MDBs involved in the export and import operation. You supply these connection names as an argument to the MDB Admin Console command line interface.

Follow these steps:

Open the mdbac.properties file located in the .\cfg folder. The .\cfg folder is available in the MDB Admin Console installation folder.
Search for "Define the Connections" and either modify the existing database connection entries or add new entries for new database connections. Define the new database connection strings in the following format:
Oracle MDB
```
connection.connection_name=jdbc:oracle:thin:@Host:Port:SID
```
SQL Server MDB
```
connection.connection_name=jdbc:sqlserver://Host\[Instance_name]:Port;DatabaseName=database_name 
```
To configure a trusted connection to the SQL Server MDB, use the following format:
```
connection.mssql-test =jdbc:sqlserver://Host\[instance_name]:Port;DatabaseName=database_name;integratedSecurity=true
```
Connection_name

Defines the connection name. You specify this connection name as a parameter to the MDB Admin Console CLI to refer to the MDB.

Host

Defines the name of the computer that hosts the MDB.

Instance_name
(Optional) Defines the instance name to connect to.

Default: Default instance

Note: If your instance name starts with 'n', 'r', or 't', you must add the escape sign '\' before the character because these characters act as terminators when prefixed with a '\'. For example, if the instance name is nonname, the connection string must be as follows:
```
MyMachine\\nonname:1488
```
Note: The instance_name parameter is mandatory for the adjustmdbcfg method even if you are using the default instance. The default instance name must be provided as "MSQLSERVER".
Port

Defines the port number of the MDB.

Database_name

Defines the database name of the MDB.

SID

Defines the SID of the MDB.

IntegratedSecurity=true

Indicates that trusted connection to the SQL Server MDB is required. You need a trusted connection to the SQL Server MDB for running the adjustmdbcfg method.
Examples:
```
connection.mssql-test =jdbc:sqlserver://lab_test:1433;DatabaseName=mdb
```
```
connection.mssql-test =jdbc:sqlserver://lab_test\\MSQLSERVER:1433;DatabaseName=mdb;integratedSecurity=true
Connection.oracle-test=jdbc:oracle:thin:@lab-test:1521:orcl
```
Verify that the database connection to the MDB Admin Console is working. To do this, follow these steps:
1. Open the command prompt and navigate to the MDB Admin Console installation directory using the following command:
```
cd MDBAC_Installation_Directory
```
2. Execute the following command:
```
mdbac -testcon -target Connection_name -user username -pwd password
```
  Verifies the database connection and returns the result.
  
  Examples:
```
mdbac -testcon -target mssql-test -user ca_itrm -pwd password123
```
```
mdbac -testcon -target oracle-test -user mdbadmin -pwd password123
```
You can now use the connection names in your MDB Admin Console CLI.

More information:

MDB Admin Console CLI