This is the latest release in the 6.x.x family. For EI 7.0.0, click here.

All docs This doc

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

All WSO2 products are Enterprise Integration is shipped with an embedded H2 databases database for storing data. These This default databases are database is located in the <PRODUCT_HOME>/repository/the /database directory of the product packEI profile.

Default databases

Explained below are the default databases that you will find in the database directory.

  • Carbon database: WSO2CARBON_DB.h2.db is the main Carbon database in a WSO2 productof the profile. This stores registry and user management data by default. In addition, if the product uses features of WSO2 Identity Server or WSO2 Enterprise Store (ES), data that are specific to those will by default reside in the embedded Carbon databaseHowever, for production environments, we recommend separate RDBMSs to store identity-related and storage-related data.
  • Product-specific databases: In addition to the main Carbon database, your product may have other databases for storing product-specific datathe Business Process profile and Message Broker profile also has profile-specific databases.

Changing the default databases

The embedded H2 databases shipped with your product are suitable for development, testing, and some production environments. For most production environments, we recommend industry-standard RDBMSs such as Oracle, PostgreSQL, MySQL, MS SQL, etc. Further, if you have features of WSO2 Identity Server or WSO2 Enterprise Store (ES) in your product, it is recommended to use separate RDBMSs for each, i.e., identity-related and storage-related data.  

WSO2 products are shipped with scripts for creating the required tables in all the required databases: The scripts for creating tables for user management and registry data are stored in the <PRODUCT_HOME>/dbscripts folder directory of your EI profile. If productprofile-specific databases are required, and if features of WSO2 Identity Server or WSO2 Enterprise Store (ES) are used in the product, there will be subfolders in the <PRODUCT_HOME>/dbscripts directory with separate scripts.

...

Children Display

Changing the default productprofile-specific databases:The process of setting up and configuring product-specific databases is similar to changing the default Carbon database. However, depending on the product, there may be additional configuration files to update. See the documentation for the respective product for instructions.