Home / Companies / Fivetran / Blog / Post Details
Content Deep Dive

From Guidewire Cloud Access to analytics-ready data

Blog post from Fivetran

Post Details
Company
Date Published
Author
Parmeet Kohli
Word Count
1,010
Language
English
Hacker News Points
-
Summary

Insurers transitioning from on-premise Guidewire InsuranceSuite to Guidewire Cloud aim for enhanced agility and faster upgrades, with Guidewire Cloud Data Access (CDA) playing a crucial role. CDA facilitates near real-time streaming of incremental change data into Amazon S3 buckets as Parquet files, offering a more advanced foundation than traditional batch extracts. However, the challenge lies in making this data usable for business teams, as it requires continuous ingestion, mapping, and adaptation to evolving schemas. Fivetran's Amazon S3 connector, featuring Dynamic Table Mapping, addresses these issues by automating the mapping of CDA files to destination tables, eliminating the need for manual ingestion logic and reducing engineering workload. This solution enables business teams to access timely, analytics-ready data while minimizing pipeline failures and maintenance tasks. As insurers move to the cloud, Fivetran's approach allows for a standardized, automated data ingestion process that enhances efficiency and supports high-value use cases across various departments such as claims, underwriting, and finance.