FRx Software Corp., a Microsoft company and a part of Microsoft Business Solutions, announced the availability of Microsoft Business Solutions for Analytics-Integration Designer 1.0, an easy-to-use application that accelerates the process of integrating FRx Software's financial reporting application with nearly any mid-market segment general ledger (GL) system. Integration Designer was designed to help FRx Software's value-added resellers (VARs) grow their business in financial analytics by offering Microsoft Business Solutions for Analyticsƒ{FRx to customers who don't have a way to use the application with their particular GL. FRx is a financial reporting application used by more than 115,000 organizations worldwide.

Integration Designer automates and simplifies the process of transforming and loading data from the GL to a financial data mart that can be read by FRx. This tool enables VARs to cut weeks off the integration process and can greatly reduce the technical expertise required to integrate with FRx. Once the integration is set up, minimal customer assistance is required. The customer can upload data from their general ledger with the click of a button as often as they like, or it can occur on a regularly scheduled basis.

In addition, value-added resellers benefit from the ability to leverage an integration built for one data source across multiple customers who are using the same GL, which establishes a substantial revenue generator for FRx Software's Analytic Solution Provider channel. To accomplish seamless integration, Integration Designer relies on two components:

  • Data Integrator automates the otherwise time-consuming process of mapping data from general ledgers that allow schema discovery to the FRx FDM. Users can rapidly map and transform data using drag-and-drop functionality. Task lists keep track of required items as well as those yet to be completed. Upon completion of the mapping process, the Data Integrator tool automatically creates scripts needed to move the data from the GL to the FDM, saving the user from manually writing thousands of lines of code to accomplish this same process.
  • Data Refresher executes the scripts created by the Data Integrator and ultimately populates the FDM with the GL data collected. Data Refresher will support both full and incremental data loads. This component puts control into the hands of end users, giving them the ability to perform updates and access data with minimal training. With the scheduling functionality, manual intervention also is kept to a minimum. Built into the Data Refresher tool is a security administrator function, which applies security roles and rules around the ability to execute the scripts for a given GL company.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access