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.


PURCHASE STYLUS STUDIO ONLINE TODAY!!

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

Buy Stylus Studio Now

Learn XQuery in 10 Minutes!

Say goodbye to 10-minute abs, and say Hello to "Learn XQuery in Ten Minutes!", the world's fastest and easiest XQuery primer, now available for free!

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!

 
Free Stylus Studio XML Training:
W3C Member