Configuring CAPS with an Oracle Database

1. Run the ODP.NET_12CR2.bat under the current directory with administrator privileges from a command prompt.
2. 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

3. Double-click CAPSConfigurator, enter the server and port number of the EGateway, and sign in using your EMC credentials. A list of Service Hosts appears.
4. Click the Service Host to configure.
5. Click CAPS Schema.
6. 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 onto the Oracle database server, for example, the system user name. This user name cannot be a DBA user.

   • Password: Enter the current user’s password to sign onto the Oracle database server.

7. 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.
8. 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.