The ImpEx tool is a Kuali-developed application which is based on Apache Torque. It reads in database structure and data from XML files in a platform independent way and then creates the resulting database in either Oracle or MySQL.
The ImpEx tool is included in the Rice binary and server distributions. It is located in the database/database-impex directory of the relevant archive. If you are building Rice from source, the ImpEx tool can be acquired from Subversion:
svn co https://test.kuali.org/svn/kul-cfg-dbs/trunk
For Oracle users, you must run two scripts on your Oracle database before continuing on to the ImpEx development database ingestion process. Please contact your DBA and have him or her run these two setup scripts as the Oracle SYS user. These scripts will be in the database/database-impex distribution (or the impex subdirectory if you checked out the tool from svn). These are the commands, and they must be run in this order:
create_kul_developer.sql (Creates the KUL_DEVELOPER role and applies grants)
system_grants.sql (Creates the KULUSERMAINT user for Rice Oracle system maintenance)
Please inform your DBA that the above scripts must be run under the Oracle SYS account.
After your DBA runs the above scripts, you must run two more scripts as the kulusermaint:
create_admin_user.sql (Creates the kuluser_admin user)
kuluser_maint_pk.sql (Creates the package containing the functions that the Rice system uses to do Oracle system maintenance)
The Rice team released four different sets of data with Rice 1.0.3. The server distribution contains only the first two listed, whereas the binary distribution contains all four. You can find these datasets in the /database directory of the relevant archive:
bootstrap-server-dataset – This is the core dataset. The Rice standalone server cannot function properly without this data.
demo-server-dataset – This is a superset of the bootstrap-server-dataset which, in addition to necessary bootstrap data, includes sample security groups and workflow documents.
bootstrap-client-dataset – This dataset is necessary for creating a Rice client application
demo-client-dataset – This is a superset of the data in the bootstrap-client-dataset. In addition to necessary bootstrap data, it includes tables used by some of the Rice sample client applications.
This guide does not deal with developing a client application; for more information on creating a Rice client application and the use of the client datasets, see the Global Technical Reference Guide.
After you have uncompressed the distribution (Binary or Server) you will use for Rice, login as the user that you use to run the Tomcat server:
1. Go to the sub-directory, <directory where uncompressed>/database/database-impex. This directory is the same for each of the distributions.
Copy the impex-build.properties.sample file to your home directory, renaming the file to impex-build.properties.
Configure the drivers.directory, the directory where the MySQL and Oracle JDBC drivers are located.
Configure import.torque.database.*. Set the user and password to the user under which you want to run the Rice software.
Configure import.admin.user and import.admin.password.
Set import.admin.url as follows:
import.admin.url=jdbc:mysql://localMySQLServerComputerName:MySQL-port-number/
Example: import.admin.url=jdbc:mysql://localhost:3306/
Set import.admin.url as follows:
import.admin.url=jdbc:mysql://remoteMySQLServerComputerName:MySQL-port-number/
Example: import.admin.url=jdbc:mysql://192.168.25.22:3306/
To setup the database from one of the distributions, change directories to /database/database-impex and use these commands:
ant create-schema ant import
Configure the drivers.directory, the directory where the MySQL and Oracle JDBC drivers are located.
Configure import.torque.database.* for the Oracle setup. Set the user and password to the user under which you want to run the Rice software.
Configure import.admin.user and import.admin.password.
import.admin.url= ${import.torque.database.url}Configure oracle.usermaint.*
To setup the database from one of the distributions, use these Ant commands:
ant create-schema ant import