Free-text batch load command and native SQL
The free-text batch load command extracts all policy data from the PolicyCenter
application database by using native SQL. The SQL Select statement that the batch load
command uses is defined in configuration files for specific database brands. These
configuration files are located on the host where the Guidewire Solr Extension resides,
in the following directory:
- opt/gwsolr/pc/solr/policy_active/conf
The configuration files that contain native SQL are:
- For H2 databases – batchload-config-h2.xml, suitable only for development
- For Oracle databases – batchload-config-oracle.xml, suitable for development or production
- For SQL Server databases – batchload-config-sqlserver.xml, suitable for development or production
See also