Configuring New Database Installations

SMS Builder installs with an embedded Apache Derby database that you can use for development and testing. For production, use either an IBM DB2 or an Oracle database.

Prerequisites
Install a DB2 or an Oracle database. SAP Product Availability Matrix (PAM) http://service.sap.com/pam. Click the Mobile link at the top of the page. Scroll to find the appropriate product and version in the product list.
Task

A database administrator (DBA) should install, configure, and support a production database. Installation procedures vary by database platform; review them with your DBA. Run database scripts to create a tablespace, database objects, and the initial data.

  1. Review the database scripts that are included with the product for compliance with corporate policies.
  2. Perform the appropriate tasks for your database:
    Database Perform These Tasks
    IBM DB2
    1. Configure the DB2 Database.
    2. Enable the DB2 JDBC Driver.
    Oracle
    1. Configure the Oracle Database.
    2. Install the Oracle JDBC Driver.
    3. Enable the Oracle JDBC Driver.
    Note: Derby scripts are provided for a standalone Derby installation, also known as a network server. Test and certify a Derby network server installation before deploying it to a production environment.
Related tasks
Configuring DB2 Databases
Enabling the DB2 JDBC Driver
Configuring Oracle Databases
Installing Oracle JDBC Drivers
Enabling the Oracle JDBC Driver