Set database access parameters

By creating your data source you have specified the basic settings which can then be used to configure your source system data as required for further analysis in PPM.

Please consult your system administrator for the database access parameters.

Check whether you can establish a connection to your database system. If necessary, check your access parameters again. To do this, click button_test_system Test system access in the toolbar.

Procedure

  1. You can accept the preset Process fragments and Mapping components for your new JDBC data source.
  2. Select a database type, e.g., Oracle.
  3. Select a driver class in the selection box Driver class for DB system, or specify a driver class for your database system, e.g., oracle.jdbc.driver.OracleDriver.
  4. Enter your User name and Password for logging on to your database.
  5. Confirm your password.
  6. Enter the database URL, e.g., jdbc:oracle:thin:@<host>:<port>:<dbname>.
  7. Enter a date and time as the Last extraction time, up to when the data is extracted. The default value is 01 January 1970 00:00. Alternatively, you can also enter a Last value extracted.
  8. Once you have entered all the required settings, click Save in the toolbar.

Your settings are applied.

The database type ADABAS is provided for use with Adabas Process Extractor. For a detailed description of Adabas Process Extractor, please refer to the documentation Process Intelligence for Natural Applications How-To Guide.

Detailed information on configuring an offset for data extraction is available in the technical documentation PPM Process Extractors.