You are here: Configuration > Access External Database > Access Client Information from an External Database

 

Access Client Information from an External Database

OIPA may be integrated with external systems to retrieve client information that can be displayed on the OIPA Role screen. External client information can also be attached to a policy. Information that is pulled in from an external database cannot be edited in OIPA.

 

Steps to Configure Access to an External Database

  1. Make sure that External Client in Plan Pages security is enabled (checked) in the Rules Palette.
  2. From Administration | Code Names, add codes for new external roles to the AsCodeRole code set in the AsCode table. If using the OIPA client search option, then add codes for external client types to the AsCodeClientType code set.
  3. If needed, insert authorizations for the ExternalClient page to be able to see the ExternalClientDetail screen that is used to view the details of the external client.

  4. Create a company level override of the ExternalClientDetailsScreen rule to configure the external client role codes and fields that are associated with each defined external role. The information in the rule is used to validate a set of keys identifying a client in the external system. The keys are returned when a new external role is created. The fields that must be configured include the following:

  5. Configure a plan level override of the PolicyScreen rule or Segment rule (for segment roles). External client roles must be added to the configuration. The class that implements the IExternalClientRowRetriever interface must be called to retrieve a row of external client data from an external system.

  6. If the Client Screen Search menu is needed in OIPA to search for external clients, then the ClientSearchScreen rule needs to include configuration for the client search screen for the defined external client types. The name of a class that implements the IExternalClientSearch interface should be specified using the ExternalClientSearchRetriever tag.

 

Implement Java Classes

After configuration is complete, integration with an external client system requires implementation of several OIPA interfaces by a Java developer. The external classes that implement the interfaces should be deployed in a shared library similar to any other extension classes.

 

Refer to the OIPA Extensibility document on OTN in the 9.7.1.0 library for a complete explanation of the process for implementing java classes to support external client retrieval.

 

Copyright © 2009, 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices