BusinessObjects Data Integrator 4.0

RapidDecision pre-built data warehouse software utilizes Business Objects Data Services 4.0 (Data Integrator) to manage and facilitate critical elements of the RapidDecision data structure.  This hands-on, instructor-led offering is a three-day course that utilizes SAP Authorized course material.

Who Should Attend
RapidDecision users responsible for implementing, administering, and managing data integration projects.

What You Will Learn
In this course participants learn how to administer and operate SAP Business Objects Data Integrator in a production RapidDecision CDC environment.  Content will include creating, executing, and troubleshooting batch jobs, using functions, scripts and transforms to change the structure and formatting of data, handling errors, setting yup a replication schema, capturing changes in replicated data, and an overview of the RapidDecision batch job scream methodology.

Topics covered
Describing Data Services

  • Describe the purpose of Data Services
  • Describe Data Services architecture
  • Define Data Services objects

Defining Source and Target Metadata

  • Datastores in Data Services
  • Data Services system configurations
  • Flat file formats
  • Excel file formats

Creating Batch Jobs

  • Work with objects
  • Create a data flow
  • Use the Query transform
  • Use target tables
  • Execute the job

Troubleshooting Batch Jobs

  • Setting Traces and adding annotations
  • Using the Interactive Debugger
  • Configuring and using the Audit features

Using Functions, Scripts, and Variables

  • Using the built-in functions
  • Using the Map Operations transform
  • Using the Validation transform
  • Using the Merge transform
  • Using the Case transform
  • Using the SQL transform

Setting up Error Handling

  • Set up recoverable work flows

Using Data Integrator Transforms

  • Describe the Data Integrator transforms
  • Use the Pivot transform
  • Describe performance optimization
  • Use the Data Transfer transform

Data Integrator & CDC via Replication Services

  • Overview of Replication Services in MS SQL Server
  • Replication CDC in Business Objects Data Integrator
  • Configuring replication in CDC in Business Objects Data Integrator
  • Job Execution of replication CDC

Using the Administrator Services

  • Management administrator services
  • Metadata reporting: impact / lineage analysis
  • Metadata reporting: auto documentation
  • Using the operational dashboard
  • Using data validation reports

Knowledge of data warehousing and ETL concepts, experience with MySQL and SQL language, Experience using functions, elementary procedural programming, and flow-of-control statements such as If-Then-Else and While Loop statements, knowledge of Data Warehouse Architecture and Modeling fundamentals

Duration: 3 days

Tuition: US $2,250 per student (three student minimum required to confirm session)

Magnitude Software specifies the dates of public classes. Private and on site classes will be scheduled by mutual agreement. Magnitude Software may cancel or defer any scheduled class on 10 working days notice. If Magnitude Software cancels a class for which you have prepaid, Magnitude Software will refund the price you paid to Magnitude Software. Magnitude Software will not be responsible for any loss incurred by you, e.g. travel expenses, as a result of Magnitude Software’s cancellation or deferral of a class.


© 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.


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.


Bill Stephens

General Manager, Magnitude Applications

Bill leads the Magnitude Applications business, driving strategic direction, product and service execution, revenue growth and customer engagement across Magnitude’s applications portfolio.

A seasoned IT and consulting executive with a 20-year track record leading teams to drive customer success across diverse industries, Bill previously served as BIAS’ Vice President of Services overseeing the successful delivery of solutions across the Public Sector and Commercial markets. Prior to BIAS, Bill served for over a decade at Oracle Corporation as an applications consultant, project manager, senior operations director, and consulting executive.

He developed the foundation of his leadership skills while serving as a Cavalry Scout in the Kentucky Army National Guard.

Bill holds a Bachelor of Science in Finance from the University of Louisville.


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.


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.


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.


Karen McPhillips

Vice President,

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.