A "remote" database is any data source that is not the default Derby database. A remote database may be network connected and/or installed on the local server. The Entity Engine supports simultaneous connections to an unlimited number of remote databases in addition to, or as a replacement for, the default instance of Derby.
Each remote database connection requires a datasource
element entry in the entityengine.xml
file. Adding and removing database connections may be performed at any time; however, entityengine.xml
file changes are only effective upon OFBiz restart.
Collect all the necessary information required to connect to the remote database. In particular, you will need, at a minimum, the following information:
Database name.
Username and password for OFBiz to pass when negotiating connections to the remote database. In some cases, passwords are not required. Check your remote database setup for more information.
Database schema name, if appropriate...