Importing from database staging tables

In PolicyCenter, the database staging tables and the database import tools load zone data only.

The Policy Migration Tool supports many migration tasks for policies. This tool streams policy data from legacy systems at renewal time to the cloud with low or no downtime. Guidewire recommends that your migration team undertakes training in using this tool. For information about this tool, see Guidewire Cloud Standards.

The sources for zone data are CSV files for each country or region that you need to support. PolicyCenter provides both a command prompt tool and a web services API to load zone data from CSV files into the staging table for zone data. Configuration files for this tool specify the zone fields to import.

Guidewire recommends that you load a complete set of data for a country rather than loading incremental changes to zone data. Incremental changes cause a non-linear growth in the time to import zone data and in the size of the zone link table. To reload data for a country for which zone data already exists, you must first clear the zone data for that country from the operational zone tables.

The following diagram shows the major steps in a typical zone staging table import.


Data flow from source file through import tools, to correction of errors, to staging tables, and finally operational tables.

High-level steps to import zone data

The following procedure lists the high-level steps involved in a typical database import procedure to load zone data from CSV files into PolicyCenter.

  • Get or create zone data files – These files use comma separated value (CSV) format. Each line in a file contains the columns that the country or region requires, such as the postal code, state, city, and county. A configuration file for the country or region specifies the columns and their order in the line.
  • Run the zone import command to add zone data to the zone staging table – Run a command prompt tool or use the web services API to add your zone data to the staging table.
  • Check the data in the zone staging tables – Set the server to the maintenance run level. Run integrity checks on staging table data. Set the server to the multiuser run level.
  • Review and correct zone data errors – View load errors on the Load Errors page. Fix the errors and then repeat the previous tasks until no errors remain.
  • Load data into operational zone tables – Set the server to the maintenance run level. Load the data from the staging tables into operational tables by using PolicyCenter web services or command prompt table import tools. Set the server to the multiuser run level.

See also