Customer Story - MacLean-Fogg Component Solutions Goes Agile with Stylus Studio

Stylus Studio

Company Background

MacLean-Fogg Component Solutions (http://www.macleanfoggcs.com/) is a worldwide leading supplier of fastener components, engineered components, and suspension components to a myriad of industries since 1925. MacLean-Fogg Component Solutions is a child company of MacLean-Fogg Company (http://www.macleanfogg.com/).

As part of the company’s innovation efforts, MacLean-Fogg Component Solutions is transitioning all of their divisions to a single ERP system. Across the dozen divisions there are currently eight different legacy ERP systems, which often means there are eight different versions of any given business process.

Chris Misztur and Keen Chan are two of MacLean-Fogg’s developers and resident XML experts. Their skills span multiple programming languages, database and web technologies. Chris and Keen have been tasked with architecting the “Extract, Transform, Load” process along side of functional and systems experts. Several programming languages and ETL/XML tool-sets have been reviewed before making a decision to use Stylus Studio as the primary transformation tool.

Tool-set Selection

A customer service call was placed into each company as we reviewed their product offerings. Out of the 5% that responded to our call, only one was able to answer all of our questions at both functional and technical levels. This was the Stylus Studio team!

We arrived at our decision to use Stylus Studio based on the following factors:

Ease of use
Microsoft SQL Server adapter
Technical support / customer service
Flexibility
Multiple XQuery processors
Code generation and pipeline workflow
Source control integration
Cost

Agility and Transparency

Soon after the legacy Excel, Access, Flat File data started pouring in it became clear that there will many iterations of the ETL cycle. With an organized project structure within Stylus Studio we were able to contain each master data type to its own ETL cycle. This structure allows us to load legacy data incrementally while maintaining focus on a single master data type at a time.

With each iteration of the ETL cycle, the legacy data becomes cleaner and more complete. The ETL scenarios are tracked with several manually maintained XML documents and data queries against the new ERP. An HTML report is generated from over ten sources after each ETL cycle completion using Xquery and XML Reports. This status report includes processing exceptions, impediments and links to reference documents. It is published to the entire implementation team for transparency.

If you have a great story or quote about Stylus Studio XML IDE that you would like to share, we would love to hear from you. Please Contact Us and let us know how Stylus Studio has helped you or helped your company.

Prev: "Northwestern University Customer Story" Next: "Genpro XML Data Processing Case Study"

Download a 15 Day Free Trial Now >

See What's New in Stylus Studio® X16 XML >

Buy Stylus Studio Now >

Stylus Most Wanted

PURCHASE STYLUS STUDIO ONLINE TODAY!!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

What's New for Stylus Studio® X16?

New XQuery & Web Services Tools, Support for MySQL, PostgreSQL, HL7 EDI, Microsoft .NET Code Generation and much more!

Why Pay More for XML Tools?

With Stylus Studio® X16 XML Enterprise Suite, you get the most comprehensive XML tool suite at one incredibly low price. Value: it's just one of many reasons why smart XML developers are choosing Stylus Studio!