Flexible Data Ingestion for Seamless Solvency II Processing
Tabular by Solvency II Solutions is designed to fit into any insurer’s existing infrastructure—no matter how data is structured, stored, or delivered. With full support for XML, CSV, Excel, XBRL, and other input formats, Tabular offers a completely flexible integration layer that removes friction from the regulatory reporting process. Whether your data comes from actuarial models, finance systems, investment platforms, or spreadsheets, Tabular can ingest, transform, and map it into Solvency II reporting structures automatically.
Built-In ETL Layer with Full Customisation
At the heart of Tabular’s integration capability is a fully configurable ETL (Extract, Transform, Load) layer. This allows users to define exactly how incoming data should be processed—from field mapping and data type transformation to validation, conditional logic, and staging. Each input stream can be customised independently, allowing Tabular to interface with structured systems, unstructured data, or hybrid formats without manual intervention.
This ETL capability is designed for insurers, not developers. Interfaces can be configured using simple rules and mapping screens—there’s no coding required. Once configured, data integration becomes a repeatable and fully automated part of the workflow.
Input Format Flexibility
Tabular accepts data in a wide range of formats, ensuring that existing processes and tools can be retained without change. Common formats include:
- CSV: Used for flat data exports from finance or investment systems.
- Excel: For manually prepared files or internally generated actuarial outputs.
- XML: Frequently used for internal model output or structured reporting feeds.
- XBRL: Tabular can ingest XBRL where required, allowing round-trip reporting cycles or group-level consolidations.
- Custom Structures: Users can define their own data schemas and Tabular will adapt accordingly.
This flexibility eliminates the need to restructure upstream systems or convert files manually, dramatically reducing time spent on data preparation.
Output Integration
On the output side, Tabular delivers QRTs and reports in both human-readable and machine-readable formats, including Excel, PDF, XML, and XBRL. These outputs can be pushed to regulatory gateways, document management systems, or data repositories. File naming, folder paths, and export structures are all configurable, enabling full integration into existing reporting pipelines.
Unlimited Customisation and Bespoke Integration
If you need support for a new data format or integration point that isn’t currently available, Solvency II Solutions will build it for you—at no additional cost. The license includes unlimited scope for bespoke input/output connectors and custom automation logic. This ensures that even highly specialised workflows or legacy systems can be accommodated without friction.
Real-World Integration Scenarios
- Actuarial Model Feed: Daily or monthly model outputs exported as CSV or Excel are picked up, validated, and used to populate relevant QRTs such as S.25 and S.28, without user typing.
- Investment Book Integration: Asset data from custodians or internal systems is imported in XML or Excel and used to generate asset templates like S.06.02, with cross-validation against SCR inputs and balance sheets.
- Finance System Interface: Trial balance exports in CSV format are mapped directly to own funds templates (S.23.01), allowing finance teams to stay aligned with regulatory disclosures without spreadsheet manipulation.
- Group Consolidation: For group-level entities, XBRL imports from subsidiaries can be aggregated and validated centrally in Tabular for submission to the PRA or EIOPA.
Summary: Integration and Format Capabilities
| Capability | Supported in Tabular | Notes |
|---|---|---|
| CSV Input | Yes | Full mapping + validation |
| Excel Input | Yes | Multiple sheets + custom ranges |
| XML Input | Yes | Structured + schema-free |
| XBRL Input | Yes | For ingestion and reconciliation |
| Custom Format Support | Yes (on request, included) | Built free as part of the license |
| ETL Configuration | Yes | No-code mapping, full control |
| Output Formats | Excel, XBRL, XML, PDF | Configurable, human + machine-readable |
| API / System Integration | Yes (via exports/imports) | Can be tailored to your infrastructure |
Conclusion
Tabular gives insurers complete control over how regulatory data is ingested, processed, and reported. Its multi-format support and customisable integration layer ensure compatibility with any system, process, or data structure—without needing external consultants or complex reengineering. If your format isn’t supported out-of-the-box, it will be—no charge, no delay.