Data Store

Description

Specifies the location in which AutoMate BPA Server 9's repository of data is stored. BPA data consists of agents, users, repository objects (e.g., workflows, tasks, agents, conditions), log information, server properties and all aspects of client/server operations. BPA Server 9 uses  Microsoft SQL Express as its default data store. However, data can electively be written to another external data source such as Oracle or mySQL. When selecting OLEDB as the database type, the data source can be configured using a standard OLEDB connection string dialog. The table below lists the database options that are available.

Parameters

 The available preferences as they appear in the SMC's Data Store settings are shown below.  

Database

Description/Options

OLEDB

Specifies standard OLEDB connection to the database. This option requires configuration to be performed via a standard Windows Data Link Properties dialog.

SQL Server

Specifies connection to Microsoft SQL Server. Requires the following information to be entered:

  • Server - The machine name or IP address on which the database runs.

  • Database - Select a database to use. Leave blank to use the default database.

  • Username - Enter the username used to connect to the server (if required).

  • Password - Enter the password associated with the username entered above (if required).

Click the Test Connection button to test the database connection.

Click OK to save changes or Cancel to discard changes.

MySQL

Specifies connection to MySQL database. Requires the following information to be entered:

  • Server - The machine name or IP address on which the database runs.

  • Database - Select a database to use. Leave blank to use the default database.

  • Username - Enter the username used to connect to the server (if required).

  • Password - Enter the password associated with the username entered above (if required).

Click the Test Connection button to test the database connection.

Click OK to save changes or Cancel to discard changes.

Oracle

Specifies connection to an Oracle database.  Requires the following information:

  • Server - Use the database alias as setup in your Oracle Network configuration (tnsnames.ora) setup.

  • Username - Enter the username used to connect to the server.

  • Password - Enter the password associated with the username entered above.

Click the Test Connection button to test the database connection.

Click OK to save changes or Cancel to discard changes.

NOTE: An Oracle client must be installed on the same machine as the BPA Server 9 component.

See Also


Constants Settings | IP Blocking Settings | Load Management Settings | Log Management Settings | SMTP Settings | SQL Connections Settings | SSL Settings | System Security Settings