Jitterbit Case Studies State of Iowa Case Study

Edit This Case Study Record

	State of Iowa Case Study Jitterbit

State of Iowa Case Study

Jitterbit

Technology Category	Application Infrastructure & Middleware - Data Exchange & Integration
Applicable Industries	Cities & Municipalities
Applicable Functions	Procurement
Services	System Integration
Challenge	The State of Iowa's Department of Administrative Services (DAS) was tasked with maintaining a database of debtors within a vendor-offset program. This required the integration of data from both inside and outside the state's network. In 2007, legislation was passed allowing county and city agencies to add their debtors to the database, leveraging the state's data processing power to secure payments of locally oriented debts. This new program required the database to pull information from dozens of different file types. The challenge was that thousands of files from local agencies were inundating the database with incomplete files and mismatched data. Read More
About Customer	The Iowa Department of Administrative Services (DAS) was established in 2003 to manage and coordinate the major resources of state government. DAS provides infrastructure products and services to Iowa state government customers to help them deliver better service to the citizens of Iowa and support the State of Iowa in achieving economic growth. The formation of DAS is the first and largest endeavor of this kind in the country. DAS is directly responsible for maintaining a database of debtors within a vendor-offset program, which requires the integration of data from both inside and outside the state's network. Read More
Solution	DAS selected Jitterbit, a powerful, flexible, and easy-to-use data and application integration software. Jitterbit's graphical 'No-Coding' approach accelerates and simplifies the configuration and management of on-premise and cloud integration projects. Jitterbit was chosen because it allowed new users to get started quickly and its Jitterpaks made sharing integration projects simple. Jitterbit was used to provide secure, reliable processing of all files submitted by agencies. It offered batch-oriented processing of the files submitted by various agencies and bridged the gap to transactional data to handle receiving mixed types of data from outside the state’s firewall without reworking their Web application. Read More Log in to view content
Contents

Technology Category

Application Infrastructure & Middleware - Data Exchange & Integration

Applicable Industries

Cities & Municipalities

Applicable Functions

Procurement

Services

System Integration

Challenge

The State of Iowa's Department of Administrative Services (DAS) was tasked with maintaining a database of debtors within a vendor-offset program. This required the integration of data from both inside and outside the state's network. In 2007, legislation was passed allowing county and city agencies to add their debtors to the database, leveraging the state's data processing power to secure payments of locally oriented debts. This new program required the database to pull information from dozens of different file types. The challenge was that thousands of files from local agencies were inundating the database with incomplete files and mismatched data.

About Customer

The Iowa Department of Administrative Services (DAS) was established in 2003 to manage and coordinate the major resources of state government. DAS provides infrastructure products and services to Iowa state government customers to help them deliver better service to the citizens of Iowa and support the State of Iowa in achieving economic growth. The formation of DAS is the first and largest endeavor of this kind in the country. DAS is directly responsible for maintaining a database of debtors within a vendor-offset program, which requires the integration of data from both inside and outside the state's network.

Solution

DAS selected Jitterbit, a powerful, flexible, and easy-to-use data and application integration software. Jitterbit's graphical 'No-Coding' approach accelerates and simplifies the configuration and management of on-premise and cloud integration projects. Jitterbit was chosen because it allowed new users to get started quickly and its Jitterpaks made sharing integration projects simple. Jitterbit was used to provide secure, reliable processing of all files submitted by agencies. It offered batch-oriented processing of the files submitted by various agencies and bridged the gap to transactional data to handle receiving mixed types of data from outside the state’s firewall without reworking their Web application.

Impact #1	Jitterbit processes all service requests from state and local governments.
Impact #2	It provides automatic validation of payment info to the state’s ERP system.
Impact #3	Jitterbit updates a custom portal based on changes to back-office data.

Impact #1

Jitterbit processes all service requests from state and local governments.

Impact #2

It provides automatic validation of payment info to the state’s ERP system.

Impact #3

Jitterbit updates a custom portal based on changes to back-office data.

Benefit #1	Allows for collection of about $3 million a year in payments for state and local government agencies.

Benefit #1

Allows for collection of about $3 million a year in payments for state and local government agencies.

Download PDF Version

Overview

State of Iowa Case Study

Operational Impact

Quantitative Benefit