下载PDF
North Carolina Farm Bureau Reaps Productivity Advantages With iWay
技术
- 分析与建模 - 数据即服务
- 平台即服务 (PaaS) - 数据管理平台
适用行业
- 农业
适用功能
- 商业运营
- 销售与市场营销
挑战
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 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.
解决方案
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.
运营影响
数量效益
相关案例.
Case Study
Intelligent Farming with ThingWorx Analytics
Z Farms was facing three challenges: costly irrigation systems with water as a limited resource, narrow optimal ranges of soil moisture for growth with difficult maintenance and farm operators could not simply turn on irrigation systems like a faucet.
Case Study
Greenhouse Intelligent Monitoring and Control Solution
Farming Orchids is the most successful form of precision farming in Taiwan, and also the most exported flower. Orchids need a specific temperature and humidity conditions to grow and bloom, and its flowering time may not be in line with market demands, so the price collapses when there is overproduction. Therefore, some farmers began to import automated greenhouse control systems for breeding and forcing, which not only improves quality, but also effectively controls the production period and yield to ensure revenue. In 2012, an orchid farmer built a Forcing Greenhouse of about 200 pings (approximately 661 Square Meters) in Tainan, Taiwan. The system integrator adopted Advantech’s APAX-5000 series programmable automation controllers to build the control platform, coupled with Advantech WebAccess HMI/SCADA software, to achieve cloud monitoring. The staff of the orchid field can monitor important data anytime via smart phone, iPad, and other handheld devices, and control the growth and flowering conditions. System requirements: In the past, most environmental control systems of orchid greenhouses in Taiwan used PLCs (Programmable Logic Controller) with poorscalability and control, and could not be connected to the Internet formonitoring from the cloud. For advanced database analysis and networking capability, the PC platform must be adopted. Therefore, PAC Systems (Programmable Automation Controller) with both PLC programming capabilities andPC functions is a better choice.The environmental control of the Orchid greenhouse switches on and off devices like fan, shade net, cooling/heat pump, liquid flow control, water-cooling wall etc. It is controlled by a control panel of electric controllers, and is driven by a motor, to adjust the greenhouse temperature, humidity, and other environmental conditions to the set parameters.
Case Study
Enabling Internet of Things Innovation in Agriculture
DigiBale, wanted to apply technology know-how and IP from implementations successfully to more agriculture sectors including cotton, forestry, sugarcane and cattle. However, farmers and growers still have worries about the connected technology.
Case Study
Precision beekeeping with wireless temperature monitoring
Honeybees are insects of large economic value and provide a vital service to agriculture by pollinating a variety of crops. In addition, bees provide us with valuable products such as honey, beeswax, propolis, bee venom, etc. Monitoring of honeybee colony health, population, productivity, and environmental conditions affecting the colony health have always been exceedingly difficult tasks in apiculture. Research has shown that even small deviations (by more than 2°C) from the optimal temperatures have a significant influence on the development of the brood and the health of adult bees.