ETL Product Model Loader plugin

The ETL Product Model Loader plugin extracts product model data from the running PolicyCenter server, and stores the information in ETL product model tables in the PolicyCenter database. Policy data combined with the ETL product model data can be extracted, transformed, and loaded into a data warehouse or data store for analysis or reporting.

When the PolicyCenter server starts, it runs the ETL Product Model Loader plugin. PolicyCenter provides two implementations of this plugin interface (IETLProductModelLoaderPlugin).

  • ETLProductModelLoaderPlugin – Operational plugin implementation that is enabled and registered in the base configuration.
  • ETLProductModelLoaderEmptyPlugin – Non-operational plugin implementation.

Only one implementation can be enabled at a time.

See also

Plugin implementation

In the base configuration, the ETL Product Model Loader plugin implementation is registered and enabled in the plugins registry. This plugin implementation first removes data from the ETL product model database tables. Then the plugin extracts the PolicyCenter product model to ETL entities and writes these entities to the ETL product model database tables.

If you update the product model in Product Designer, first synchronize the product model from Product Designer to propagate your changes to PolicyCenter. Then restart PolicyCenter to run the Product Model Loader plugin. The plugin repopulates the ETL database tables with the current product model.

If you add policy lines or add clauses and coverage terms to existing policy lines, the Product Model Loader creates ETL product model tables for these additions. You can also extend the Product Model Loader to access other product model data, including product offerings or questions in question sets. These changes may require modifying the ETL entities.

The Gosu code for the Product Model Loader plugin is in ETLProductModelLoaderPlugin.gs in the gw.plugin.etlprodmodloader.impl package. In the start method, the plugin first clears the ETL database tables and entities by calling the deleteModel method. Then the plugin populates the ETL database tables and entities by calling the loadModel method.

The factory subpackage contains creator classes for each ETL product model entity type. For example, the ETLClausePatternCreator.gs class contains code to create ETLClausePattern entity instances.

Non-operational plugin implementation

To effectively disable the ETL Product Model Loader plugin, register and enable the Non-operational ETL Product Model Loader plugin implementation. This implementation does not populate the ETL database tables. Nor does the implementation clear the ETL database tables.

The code for the Non-operational ETL Product Model Loader plugin implementation is in ETLProductModelLoaderEmptyPlugin in the gw.plugin.etlprodmodloader.impl package.

In the registry for this plugin (IETLProductModelLoaderPlugin.gwp), perform the following operations.

  • Register and enable the ETLProductModelLoaderEmptyPlugin plugin implementation.
  • Remove the ETLProductModelLoaderPlugin plugin implementation from the registry.