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

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

request_a_call

© 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

Lou Guercia

Chief Operating Officer

Lou is responsible for Magnitude Software’s global operations.

With more than 30 years of experience launching, operating and growing profitable technology companies, Lou ensures cohesiveness across all Magnitude Software functions, creating and implementing the operational strategy for the company’s growth. Lou is critical to the success of Magnitude’s product strategy and to integrating acquired and existing products, which serves as a growth multiplier.

Lou has held leadership roles at several privately funded companies, four of which led to successful exits. He was CEO of Scribe Software, a data integration solutions company, and WebDialogs, a SaaS-based web conferencing provider acquired by IBM. At IBM, Lou served as Director of Strategy and Operations for Online Collaboration Services within IBM Software Group. He began his career in sales at Xerox.

Lou holds a Bachelor of Arts degree from the University of New Hampshire.

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

Tony Fisher

General Manager of Connectivity

Tony leads Magnitude’s Connectivity business, driving strategy, growth, product and operations as well as leveraging and integrating our Simba-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 and
Vice President of Products

Darren drives Magnitude Software’s technology direction and product delivery.

With responsibility for identifying the nexus of market opportunity, technology innovation and Magnitude’s current and future portfolio, Darren oversees Product Management, Product Delivery and Engineering Services while developing and maturing key partnerships with leading technology companies in support of product strategy.

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 has 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

Susie Buehler

susie_450

Chief People Officer

Susie leads Magnitude Software’s global human resources strategy and operational execution.

Susie is a seasoned business leader with more than 25 years of human resources management and recruitment experience at technology companies. At Magnitude, she focuses on building business success through people success across all related disciplines, including talent acquisition, development and retention; compensation and benefits; and all people-related aspects of acquisition integration. She has expertise in HR management and operations and in strategic HR business partnership at rapid-growth, start-up and established high-tech companies with significant M&A activity.

During her career, Susie led HR and Recruitment in the U.S. and China as Vice President and Director of Human Resources at Appconomy. As Vice President of Human Resources and Chief People Officer at Moxie Software/nGenera she oversaw international employee growth. She also served as Vice President of Human Resources and Recruiting at Surgient Networks and worked as an independent strategic HR consultant within the technology industry.

Susie holds a Bachelor’s degree from Texas Tech University and a Master’s degree from Rice University.

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

Amyn Rajan

General Manager,
Connectivity Solutions

Amyn is responsible for leading and growing Magnitude Software’s connectivity solutions business.

Amyn joins Magnitude Software with more than 25 years of experience, including as CEO of Simba Technologies, acquired by Magnitude in 2016. His responsibilities include working with strategic partners and driving product vision along with delivering revenue growth for the company’s data connectivity solutions.

Under Amyn’s leadership, Simba became a global leader in cross-platform, standards-based data access solutions for relational, multi-dimensional and non-relational data sources whose software is embedded by Amazon, Microsoft, SAP and Teradata. Prior to Simba he was CEO of Orbital Technologies, whose customers included Adobe and Microsoft; he also held the position of Vice President of Engineering at Orbital. Amyn’s background includes experience as a software developer at Microsoft and Adobe.

Amyn holds a Bachelor of Science degree in Computer Science from Simon Fraser University. He was appointed co-chair of the Faculty of Applied Sciences External Advisory Council at Simon Fraser University in 2011, and was named to Business in Vancouver magazine’s “Forty Under 40” in 2007.

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.