Data Store

Description

Specifies the location in which Enterprise's repository of data is stored. Automate Enterprise data consists of workflow objects such as agents, users, tasks and conditions. It also consists of data with respect to all aspects of client/server operations, including log information, client/server properties, user and group preferences, and much more. Enterprise 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.

To access Data Store settings, from Server Management Console (SMC), select Options > Server Settings > Data Store.

Related Topics

Parameters

The following table displays available preferences as they appear in the SMC's Data Store settings.

Database	Description
OLEDB	Specifies standard OLEDB connection to the database. This option requires configuration to be performed by way of 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 a 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 Automate Enterprise component.