Show TOC

Process documentationMDO Setup Locate this document in the navigation structure

 

To use manufacturing data objects (MDO) in SAP MII, you must connect to an external database using an SAP NetWeaver JDBC DataSource. You can use this process to configure the connection.

Note Note

Different SAP MII systems cannot use the same database.

End of the note.

Process

Creating a JDBC DataSource

You must create a JDBC DataSource. To do this, follow the procedure in the SAP NetWeaver CE 7.1 help topic Managing JDBC DataSources on the SAP Help Portal at http://help.sap.com.

You must select Default as the isolation level and Vendor SQL as the SQL engine type.

Note Note

If you are using a database for which there is no JDBC driver on the SAP NetWeaver server, you must upload a driver. To do this, follow the procedure in the SAP NetWeaver CE 7.1 help topic Managing JDBC Drivers on the SAP Help Portal at http://help.sap.com. Once you upload the driver, you can create a JDBC data source that uses it.

End of the note.
Configuring a NetWeaver CE DataSource

The usage of these actions depends on the creation of a NetWeaver DataSource connection to a database that is either local or available remotely on the network. To create a valid DataSource, do the following:

  1. Login to the SAP NetWeaver administrator with a valid user name and password using the URL: http://<server<:port>/nwa.

  2. Choose   Configuration Management   Infrastructure   Application Resources  .

Deploying a JDBC Driver

The JDBC driver has to be deployed initially to create a connection to a database instance.

  1. Choose JDBC Drivers from the Show drop-down list.

  2. Choose   Create New Resource   Deploy New JDBC Driver  .

    The New JDBC Driver Creation screen appears.

  3. Enter the name of the driver in the field JDBC Driver Name.

  4. Choose Add New Driver File.

    The File Upload screen appears.

  5. Browse for the JDBC driver.

  6. Choose Save.

The green square or a gray diamond in the State column indicates that the JDBC driver is deployed successfully.

Creating a DataSource

  1. Choose JDBC Custom DataSources from the Show drop-down list.

  2. Choose   Create New Resource   New JDBC Custom DataSource  .

    The New JDBC Custom DataSource Creation screen appears

  3. Choose the specified driver in the Driver Name field.

  4. Enter the relevant connection properties specific to the database.

  5. Choose Connection Pooling tab.

    You have to configure the pool based on your scenario requirements.

  6. Choose Save .

The green square in the State column indicates that the resource is created successfully.

In SAP MII, you have to include the MDO DataSource name and set the MDO DataSource to your DataSource JNDI name. To do so:

  1. On the SAP MII administration menu, choose   System Management   System Properties  . Enter the DataSource name in the MDO DataSource field.

    Note Note

    You have to prefix the DataSource name with jdbc/.

    End of the note.

  2. On the SAP MII administration menu, choose   System Management   System Properties  . Use the alias name.

    In SAP NetWeaver Administrator, you can find the JNDI name of available system resources. See   http://<server>:<port>/nwa   Problem Management   Java   JNDI Browser  .