Configuring CAPS with an Oracle Database

1. Navigate to the directory containing the CAPSConfigurator folder.
   Depending on your configuration method, the path is one of the following:

   • [Drive Letter]:\ MICROS\Simphony2\Tools\CAPSConfigurator

   • [Drive Letter]:\ MICROS\Simphony\CAPSonIIS\Tools\CAPSConfigurator

2. Double-click CAPSConfigurator.exe, enter the server and port number of the Egateway, and sign in using your EMC credentials. A list of Service Hosts appears.
3. Click the Service Host to configure.
4. Click CAPS Schema.
5. Enter the appropriate information in the CAPS Schema dialog, and then click Next.

   • Database: Select the Oracle database type.

   • Server: Enter the server name.

   • Port: Enter the port number.

   • Service name: Enter the service name.

   • Admin User: Enter the administrative user name used to sign in to the Oracle database server. This user name cannot be a DBA user.

   • Password: Enter the administrative password used to sign in to the Oracle database server.

6. In the next CAPS Schema dialog, enter the User Name, Password, and Confirm Password to create a new database user for the CAPS database, and then click Next.
7. Click OK to confirm. A message indicates success.

   The CAPS Schema dbsettings.xml is configured at one of the following directories (depending on your configuration):

   • [Drive Letter]:\MICROS\Simphony2\IISCAPSServiceHost

   • [Drive Letter]:\MICROS\Simphony\IISCAPSServiceHost

   Configuring CAPS Access contains important information about enabling the privileges to access the CAPS Configuration Tool.