Information Builders > Case Studies > North Carolina Farm Bureau Reaps Productivity Advantages With iWay

North Carolina Farm Bureau Reaps Productivity Advantages With iWay

Information Builders Logo
Company Size
1,000+
Region
  • America
Country
  • United States
Product
  • iWay DataMigrator
  • iWay Intelligent Adapters
  • iWay change data capture (CDC) option
Tech Stack
  • COBOL
  • DB2
  • Microsoft Windows NT
Implementation Scale
  • Enterprise-wide Deployment
Impact Metrics
  • Cost Savings
  • Productivity Improvements
Technology Category
  • Analytics & Modeling - Data-as-a-Service
  • Platform as a Service (PaaS) - Data Management Platforms
Applicable Industries
  • Agriculture
Applicable Functions
  • Business Operation
  • Sales & Marketing
About The Customer
The North Carolina Farm Bureau Mutual Insurance Company (NCFB) is North Carolina’s largest domestic property and casualty insurer. The company was incorporated in 1953 to provide rural and farming citizens appropriate and affordable insurance coverage. Since then, the company has expanded its reach far beyond the local farms to become the largest domestic property and casualty insurer in the state. NCFB is leveraging technology to help farmers and other customers initiate policies, make payments, and manage claims. The company is headquartered in Raleigh, North Carolina.
The Challenge
The North Carolina Farm Bureau Mutual Insurance Company (NCFB) was facing several challenges. The company was using a manual process of writing COBOL batch programs to move data from one platform to another. This process was labor-intensive and consumed mainframe cycles, making the mainframe unavailable for ad hoc query and reporting activities. NCFB wanted to make claims and payment information available via the Web and reduce the load on mainframe information systems. The company also wanted to work with compressed DB2 data. To address these challenges, NCFB decided to build a data warehouse that could be periodically refreshed from the mainframe DB2 data. The warehouse, residing on a Microsoft Windows NT platform, would always be available for live queries, thus sparing the mainframe the arduous task of fielding ad hoc requests.
The Solution
NCFB chose iWay's DataMigrator to address its challenges. The DataMigrator met all of NCFB’s technical requirements and was the only product that could capture the changes on a compressed database. iWay’s change data capture (CDC) was a critical element in NCFB’s decision. iWay automates the process of copying the differences in data so NCFB doesn’t have to use its resources to write COBOL batch routines. Another important deciding factor was iWay’s ability to work bidirectionally – reading from the mainframe, writing to the Windows NT servers, and vice versa. With help from Information Builders’ Consulting, Wall and her team had several iWay ETL processes up and running within a couple of months. NCFB is using iWay ETL tools to replicate and move tables from a test server to a production server. iWay is also assisting with customer-service processes by staging data for access by Web-based applications.
Operational Impact
  • Rapid application development for e-business processes, including online credit card payment system.
  • Converting data from platform to platform faster.
  • More efficient query processing distribution.
  • Automated ETL processes reduce costs and streamline customer service.
Quantitative Benefit
  • Automating more than 150 ETL processes once the new credit card application goes online.

Case Study missing?

Start adding your own!

Register with your work email and create a new case study profile for your business.

Add New Record

Related Case Studies.

Contact us

Let's talk!
* Required
* Required
* Required
* Invalid email address
By submitting this form, you agree that IoT ONE may contact you with insights and marketing messaging.
No thanks, I don't want to receive any marketing emails from IoT ONE.
Submit

Thank you for your message!
We will contact you soon.