Schemas on Oracle and MySQL

The Oracle database can be used for all applications except for Emptoris® Spend Analysis. Emptoris Spend Analysis requires the MySQL database server.

The following image shows the schema for each application on the Oracle and MySQL databases.

All schemas can be co-located on the same database. However, it is a good practice to separate the transactional database from the reporting data warehouse, which is the Emptoris Contract Management reporting schema.

Parent topic: Schemas for Emptoris Applications