View Demo Request Trial User Reviews

United Methodist Church

 

United Methodist Church Selects Astera to Integrate Complex Data Across Conferences Nationwide

 

"We are thrilled to work with Astera and are confident that Centerprise will solve our data movement needs. The support and training we have received has been truly top notch and it shows that Astera has a heart for working with nonprofits. We have truly enjoyed the collaboration and cohesiveness among our constitutents that has come as a result of the product."
Michael Cook, IT Director

 

Overview

The General Council on Finance and Administration (GCFA) coordinates and administers the finances, property, and statistical resources of The United Methodist Church and safeguards the Church's legal interests and rights.

GCFA is responsible for consolidating and reporting financial and administrative data from conferences, districts, and churches. Historically, this data consolidation took place using a patchwork of homegrown and off-the-shelf products.

The conference determined that the legacy infrastructure was no longer sufficient for their business needs and embarked on a modernization project. Their primary need was to have data syncing from 59 separate annual church conferences to GCFA, from which the data will be spread among other entities.

After a detailed evaluation, GCFA selected Centerprise for its superior usability, flexibility, and overall functionality.

 

Challenges

GCFA is responsible for consolidating and reporting financial and administrative data from 59 annual conferences spread across the nation. These conferences house data in a variety of homegrown and commercial software products and platforms. Data structures and semantics are different across these conferences and must be normalized before importing to the consolidated operational data store.

This difficulty meant that management reports reflected data that was weeks or even months old, which adversely affected the decision-making processes.

 

Business Needs

Because the selected data integration product would be used by large number of users spread across the globe, ease of use was considered to be of paramount importance. Also important was the ability to provide the functionality for complex data transformations, data cleansing, job orchestration, scheduling, and other features that would enable GCFA to automate the integration process. Additionally, the product must support numerous databases and formats in use at all the conferences.

 

Astera Solution and Results

GCFA evaluated several products and decided to pursue a detailed proof of concept with Astera’s Centerprise Data Integrator. The proof of concept entailed building end-to-end integration with selected conferences. These conferences were chosen for the complexity of their operations and participation by their IT staff.

With Astera’s assistance, a proof of concept was developed and presented to the United Methodist Information Technology Association’s annual meeting. The solution received a resounding approval from the conference attendees.

GCFA is currently in the process of deploying integration solution across the conferences in a phased approach.

 

Why Astera

Centerprise met all of the GCFA requirements and was the easiest to use and the most cost-effective.

   

Astera brings powerful data management and application integration solutions within reach of any organization. Astera's open source solutions for developing and deploying data management services like ETL, data profiling, data governance, and MDM are affordable, easy to use, and proven in demanding production environments around the world. For organizations looking to jump-start a big data initiative, Astera provides applications that accelerate data loading and other aspects of Hadoop setup by enabling developers and analysts to leverage powerful Hadoop technologies like Hadoop Hive, Pig, and Sqoop without having to write Hadoop code. Astera's ESB and data services infrastructure solutions extend proven Microsoft technologies like WCF and MSMQ to deliver affordable, flexible service enablement of distributed applications. To help enterprises improve operational performance, Astera also offers packaged solutions that support business process modeling and simulation as well as rapid development, testing, and deployment of process-oriented applications..NET, SQL Server and all Microsoft-related trademarks are the property of the Microsoft, and are used with permission.