Jitterbit Case Studies State of Iowa Case Study
Edit This Case Study Record
Jitterbit Logo

State of Iowa Case Study

Jitterbit
Application Infrastructure & Middleware - Data Exchange & Integration
Cities & Municipalities
Procurement
System Integration
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
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
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
Jitterbit processes all service requests from state and local governments.
It provides automatic validation of payment info to the state’s ERP system.
Jitterbit updates a custom portal based on changes to back-office data.
Allows for collection of about $3 million a year in payments for state and local government agencies.
Download PDF Version
test test