Data Warehouse: Should You Build or Buy?

Data warehouse projects are complex and demand a variety of skills to build and maintain. The upfront work: gathering reporting requirements, defining data models, and creating the metadata that catalogs the content of the data warehouse is a huge undertaking. It’s not uncommon for users to have difficulty articulating their reporting needs, so just getting a project off the ground can be a hurdle.

One of the most technically challenging and labor intensive parts of a custom data warehouse project is writing the data extraction, transformation, and loading (ETL) code — mapping tens of thousands of columns from various source systems into the data warehouse. The ETL architecture should be able to not only load historical data, but also efficiently identify changes and deletions in order to quickly update the data warehouse on a timely basis.

While many reports may only need data that is current as of last night, an operational data store may be necessary to address near real-time reporting requirements to avoid bogging down the transaction system.

Integrating a custom data warehouse with an organization’s BI platform involves the time-consuming process of defining the semantic layer metadata that enables users to build reports and dashboards.

Before you make a decision, consider the following issues:

Initial Costs and Time-to-Value

A prebuilt data warehouse or packaged analytics solution costs much less than a custom-designed data warehouse and can be implemented in a fraction of the time. Custom-built solutions are resource-intensive and timelines often stretch from weeks into months, and from months into years.

Magnitude RapidDecision and Magnitude Noetix Analytics:

  • Cost 70 to 90 percent less than a custom implementation
  • Have an implementation time of weeks, not months or years
  • Saves countless development hours and costs with prebuilt dashboards and report
  • Provides broad prebuilt BI content for Oracle E-Business Suite, JD Edwards, and PeopleSoft (RapidDecision Coverage  |   Noetix Analytics Coverage)

IT Knowledge Required

Because data warehouses need current information – not information updated daily or weekly – customers who design a custom data warehouse require deep skills in the following areas:

  • Data warehouse design
  • Business intelligence (BI) requirements
  • Database architecture, design, development, and administration
  • Extract, transfer and load (ETL) including change data capture (CDC) architecture, design and development
  • Real-time design optimization

The Magnitude Software Professional Services Team has implemented hundreds of data warehouses for industry-leading brands. With Magnitude, you can leverage our deep knowledge in a wide variety of subject areas, such as real-time design or performance optimization, rather than having to develop this expertise yourself.

ERP Knowledge Required

Magnitude provides the broadest out-of-the-box support for multiple ERP systems, versions and past releases. This eliminates the need for you to deeply understand the internal workings of these systems.

Ongoing Maintenance Costs

In-house development teams don’t often stop to consider a solution’s sustainability – how upgrades and ongoing maintenance will be handled. Magnitude provides ERP upgrade protection, shielding your reports and queries from changes in new versions and releases.

Flexibility

Magnitude’s open architecture enables you to choose the BI tools or databases that best fit your unique business environment.

  • JDE Enterprise One
  • JDE World
  • EBS
  • PeopleSoft
  • 23 available marts
  • 23 available marts
  • 7,000 available marts
  • 5 available marts
  • 300,000+ mappings
  • 275,000+ mappings
  • 84,000+ mappings
  • 60,000+ mappings
Request a Demo

Cost Estimator

Build or Buy? That is the question. Download our Cost Calculator to compare costs.

“RapidDecision turned a two-day process to export, massage and validate data from EnterpriseOne into a 30-second, push-button refresh. We have so many examples of report generation that have been condensed from days or hours into minutes or seconds.”

Chris Sinkwitz
Director of IT
Meritage Homes

“Our measure of success is not just the installation component, but also time spent developing reports has decreased by 80 percent since the Noetix deployment.”

Deepak Kaul
Director of Change Management & Process Improvement
Zebra Technologies

© Copyright 2017 Magnitude Software, Inc. All rights reserved. Magnitude Software is a registered trademark of Magnitude Software, Inc. in the U.S. and other countries. All other product and company names mentioned herein are used for identification purposes only and may be trademarks/registered trademarks of their respective owners

Chris Ney

Chairman and
Chief Executive Officer

Chris oversees Magnitude Software’s overall corporate vision and strategic direction.

As Chairman and CEO, Chris leads Magnitude Software’s corporate vision and strategic direction, driving the company’s acquisition, integration and growth strategies to extend the company’s global reach. Under his leadership, Magnitude Software has developed an unparalleled customer experience, strengthened its culture of innovation, and greatly increased profitability and shareholder value. In September 2014, Chris successfully secured up to $100 million in capital to further build Magnitude Software through product innovation, organic growth and strategic acquisitions.

Ney was previously Co-Founder and President of Silverback Enterprise Group, where the team completed the strategic acquisition of nine industry-leading enterprise software companies and leveraged their synergies to build two powerful new entities: Magnitude Software and Upland Software. Magnitude Software offers a family of award-winning solutions for enterprise performance management, master data management and data connectivity. Upland Software (Nasdaq: UPLD) went public in late 2014 and is a leading provider of cloud-based enterprise work management software with over 2,000 active enterprise customers and more than 235,000 active users in more than 50 countries.

Prior to co-founding Silverback, Ney was CEO of a series of Trilogy/Versata portfolio software companies. He previously served as Chairman of the Board, CEO and Founder of CoreTrac, a financial services CRM software company. Ney began his career working for investment banking firms Lehman Brothers and UBS.

He holds a Bachelor’s Degree in Economics from Texas A&M University.

LinkedIn

Kevin Mischnick

Senior Vice President,
Finance and Accounting

Kevin oversees global financial operations for Magnitude Software.

Bringing more than 25 years of financial experience to Magnitude Software, Kevin is responsible for a number of areas of the business, including Finance, Accounting, Legal and Information Technology.

Kevin’s background includes building and transforming financial teams into high-performing units, implementing systems and processes focused on cost savings and efficiency, and raising nearly $100 million in investor capital. He served as Senior Vice President of Finance for Multimedia Games Inc. and Capstar Broadcasting Corporation. Under his financial leadership, the market values of both companies increased more than tenfold.

Kevin is a certified public accountant and holds a Bachelor of Business Administration in Accounting from Texas Tech University.

LinkedIn

Bill Stephens

General Manager, Magnitude Applications

Bill leads the Magnitude Application business, driving strategy, revenue, product and operations as well as leveraging and integrating our Agility- based technologies for new Magnitude solutions.

With over 20 years in senior customer-facing leadership and operations management roles, Bill brings to our Magnitude Applications business expertise in driving growth and operational effectiveness. Bill’s approach is one of multi-functional teaming and process excellence, which has resulted in an impressive leadership record built and refined at companies such as BIAS and Oracle.

Bill earned a Bachelor’s degree in Finance from University of Louisville.

LinkedIn

Tony Fisher

General Manager, Magnitude Integration

Tony leads the Magnitude Integration business, driving strategy, revenue, product and operations as well as leveraging and integrating our Simba- and Innowera- based technologies for new Magnitude solutions.

An accomplished data management and big data marketplace leader, Tony previously served as the SVP, Business Development & Strategy at Zaloni, an award-winning enterprise data lakes management provider; prior to that role, he was Vice President, Data Collaboration & Integration at Progress Software, where he led the business line’s strategic direction and operations.

Prior to Progress, Tony was the CEO of Dataflux Corporation. He also served as Director of data warehouse technology at SAS. A key technology leader at SAS, Tony provided the engineering research and development direction that helped make SAS the market leader in data warehouse software sales.

Tony earned a Degree in Computer Science and Mathematics from Duke University.

LinkedIn

Darren Peirce

Chief Technology Officer

Darren spearheads the development, execution and management of strategic opportunities and key customer accounts across our portfolio.

As Magnitude’s technology guru and evangelist, Darren is critical to building on our position as a leading provider of software and services that help organizations tackle the challenges and opportunities inherent in digital information management.

Previously, Darren served as CTO and Group Vice President of Product Management at Kalido; prior to that role, he was the Lead Solutions Architect and Manager of Professional Services in the United Kingdom. He also worked in senior consulting positions for companies such as Royal Dutch Shell and British Telecom.

Darren received a degree in Management from Intec College in Cape Town, ,South Africa, and studied Economics at the University of Stellenbosch.

LinkedIn

Mihir Shah

Executive Vice President,
Corporate Development and Strategy

Mihir is responsible for Magnitude Software’s acquisition and organic strategy.

Mihir has over a decade of experience leading acquisitions and strategy. During this period, he led several public and private company acquisitions, divestitures, and minority and majority equity investments.

Previously, Mihir was M&A Executive for IBM’s Information Management Software division, executing IBM’s inorganic strategy through M&A and strategic partnerships. He also served as Operating Executive for private equity firm, Golden Gate Capital, and as Vice President for Corporate Development at Aspect Software.

Mihir holds an MBA from the University of Chicago Booth School of Business and Master of Science from Worcester Polytechnic Institute.

LinkedIn

Karen McPhillips

Vice President,
Marketing

The mind that opens to a new idea never returns to its original state

Karen McPhillips drives marketing strategy and operational execution to grow the company profile, revenue and market position.

Leveraging 20+ years of transformational marketing experience, Karen fuels Magnitude’s corporate and existing portfolio marketing, collaborating to maximize the company’s business strategy while also supporting integration of acquired products and services.

Karen has served on leadership teams of public and private companies of all sizes, transforming marketing functions and generating both tangible and intangible value. Most recently at PlumChoice, she and her team repositioned the brand and metamorphosed the marketing function in support of the company’s pivot from IT support provider to leader in the cloud services and Internet of Things spaces. At Iron Mountain and its technology arm, Iron Mountain Digital, she created new marketing functions, introduced the marketing operations discipline, and spearheaded a closed-loop leads-to-revenue framework coupled with a brand-to-demand communication platform that raised the bar on marketing’s revenue influence. Prior to Iron Mountain, Karen held marketing leadership roles with SaaS back-up leader, Connected Corporation (acquired by Iron Mountain), and SilverStream Software, contributing to the company’s IPO and acquisition by Novell.

Karen earned a Bachelor’s degree in Journalism from St. Michael’s College in Vermont.