Sample Data

Optim™ provides a sample Derby database that contains replacement data as well as predefined source and target data sources.

Optim Sample Database

By default, Optim Designer will automatically run the Derby database that manages the sample data. In the Data Source Explorer, the sample database has the connection name Optim Sample Database.

The sample database is located in the \.metadata\.plugins\com.ibm.nex.designer.ui\database\optim directory of the Optim workspace. The database includes the following schemas:

Optim Replacement Data

The Optim Replacement Data profile in the Data Source Explorer includes a default connection to the EXTENDED_LOOKUP schema in a local management server installation. A management server installation includes an instance of a database that includes the EXTENDED_LOOKUP schema with the default lookup tables. The default connection for the executor lookup data source is the Optim Replacement Data connection profile.