Optim™ provides a sample Derby database that contains replacement data as well as predefined source and target data sources.
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:
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.