Flexible Results API and FIS SQL Connector

Corporate 049

The Flexible Results API provides the ability to query results when using the FIS Flexible Results module.

  • The module is an API and can be used to retrieve results directly from FIS Enterprise Manager (formerly Prophet Enterprise) when using Flexible Results.

  • The FIS Data Repository (formerly Insurance Data Repository) uses the Flexible Results API to populate its Microsoft SQL Server database without a staging database such as the FIS SQL Connector (formerly Prophet Results Database).

Alternatively, for Data Repository customers that have not licensed Flexible Results, the SQL Connector loads your FIS Insurance Risk Suite (formerly Prophet) results into a Microsoft SQL Server staging database.

  • The module is an Extract, Transform and Load (ETL) program. When called at the end of an Insurance Risk Suite run, it will convert a set of Insurance Risk Suite results to tables in a relational database.
  • Once imported into the database, the results can be queried by a variety of applications including Microsoft Excel.
  • Key information from the Insurance Risk Suite Runlog is also stored in the database.
  • The ETL completes the audit trail with an input log table.