Upcoming Event: 
Deep Dive into Anypoint Runtime Fabric Security
View all events
Upcoming Event: 
Data Synchronization and Replication - What Batch's Got To Do With It?
View all events
What We Do
Who We Are
Technologies
Technologies
AWS
Azure
Boomi
Confluent
MuleSoft
Snowflake
Software AG
Events
Insights
INSIGHTS
Blog Posts
Industry News and Updates
Case Studies
Recent Projects
Offerings
Project Accelerators
White Papers & eBooks
Insights and Education
Contact
Contact Us

State Government Modernizes Campaign Finance Data Submission with Integrated MuleSoft and Salesforce Solution

API Enablement
MuleSoft

Customer Scenario

A sizeable western state government wanted a solution to automate their existing manual campaign finance form submission process and provide integration with a wide array of vendors (entities that submit the required campaign finance data). The solution needed to also provide the ability to perform manual updates efficiently.

The existing process required campaign finance forms to be submitted by vendors as PDF documents. These submissions would then be manually processed and data inserted into an MYSQL database.

This submission process was time-consuming, increased the opportunity for human error, and made it hard for the state’s employees to update information. Due to field relationships between the forms, the state employees needed to update the same information in many places, leading to data duplication and lengthy work processes.

Once the information was submitted into the state’s system, the vendors did not have a consistent way of accessing existing campaign finance data or submitting new data.

Solution

The state chose to implement a solution that uses MuleSoft’s Anypoint Platform and Salesforce. The automated solution would include a web front-end for the vendors to submit the form data, automated data validation, and storage of the data in a SaaS solution that would permit state employees to access and modify the data easily.  

In the solution, MuleSoft was used to create an Experience API that would allow vendors to easily submit XML versions of the same PDF forms that they had already used. These forms would then be handled by a Process API which would validate the form's contents, passing back any errors and canonicalizing the data. This canonicalized data would then be sent to the System API, which would insert the information into Salesforce. A MuleSoft app was also created to handle batch processing for especially large forms that needed to be hand-validated before being inserted. Using Salesforce, state employees could view, add, or change data as necessary.

This solution met all of the state’s requirements.

Results

The solution is being deployed for an initial set of campaign finance data submission forms. The vendors are excited about the newly released integrations as it allows them to get instant feedback on their form data instead of sending it and waiting for a manual review.

The state employees have an updated process that reduces human error and duplicate data entry. They also have a consistent view of the data by using Salesforce, which also adds a security layer that restricts access to the data based on the employee’s role.

The solution also reduced the state’s IT team’s technical debt as the existing custom front-end/back-end code and MYSQL database were no longer needed.

‍

ADOPTION & EXPANSION

+ Number of APIs
+ Business coverage
+ Number of contracted apps
+ API usage
+ API reuse
‍
‍

EFFICIENCY & COST SAVINGS

+ Number of APIs in each SDLC stage
+ Time spent in each SDLC stage
+ Cost and time to build an API
+ App development velocity
+ Number of launches per year
+ Number of defects
‍

SECURITY & VULNERABILITIES

Security violation
Policy enforcement
Time since the last version was published
Number of throttling issues
‍
‍

ORGANIZATIONAL SUCCESS

+ Time to onboard
+ Uptime
+ Number of deployments
+ Number of incidents
+ Percentage of customers impacted.    per incident
+ Time to resolve incidents

Download Offer
Brian Statkevicus
Ben Stone
Schedule a Meeting
Get the eBook
This is some text inside of a div block.
subscribe

Sign up to stay on top of the latest news.

We've added you to the list!
Something went wrong. Please try again.
Recent Insights
The Practical Guide to DevOps in a Serverless Environment
KPIs for APIs Dashboard
Serverless Syncing Engine
View All

Get Our Recent eBook

ebook

The Practical Guide to DevOps in a Serverless Environment

Download eBook

BUILDING CONNECTIONS IN A DISCONNECTED WORLD

Company
What We DoWho We AreEventsCareersContact us
technologies
AWS
Azure
Boomi
Confluent
MuleSoft
Snowflake
Software AG
insights
Blog Posts
Case Studies
Offerings
White Papers & eBooks
subscribe
Welcome to the Big Compass family!
Oops! Something went wrong while submitting the form. Please try again.
© 2020 Big Compass
  |  
Privacy Policy
  |  
Terms of Service
‍