To Create the Database Tables

1. If you have not done so already, create a standard database using Oracle or SQL Server database tools.

2. Use SQL*Plus to create a user for the database. Use the following script as a sample, entering the user name and password of the Sun Master Patient Index user who will create the database files and provide the connection from the EDM and eWays.

   create user username identified by password;

   grant connect, resource to <username>;

   commit;

3. In the Projects window, expand the eIndex project, expand eView Application - Person, and then expand the Database Script folder.

4. Right-click Database Script, and then select Properties.

5. On the Properties window, do the following.

   1. For Oracle: In the Database Server field, change <hostname> to the name of the computer on which the database resides, change the port number if you are not using the default, and change <SID> to the SID name of the Sun Master Patient Index database. You can enter “localhost” for the hostname if the database is on your local computer.

   2. For SQL Server: In the Database Server field, delete the default value and replace it with jdbc:sqlserver://server:port;databaseName=database, where server is the name of the computer on which the database resides, port is the port number the database is listening on, and database is the name of the database.

   3. In the User field, enter the user ID for the user you created in step 2 above.

   4. In the Password field, enter the password for the user you created in step 2 above.

   5. Close the dialog box.

6. Under Database Script, right-click Create Person Database, click Run, and then click OK on the Information dialog box.

7. Run Create User Indexes as above.

8. Run Systems as above.

9. Run Code List as above.

10. Run Create User Code Data as above.

11. Continue to Configure the Connectivity Maps.