SAP IQ Administration

COURSE OUTLINE:

Description

In this course, you will learn how to keep SAP IQ operating, stable, and productive for your users while you explore the optional and advanced features of the product.

Audience

Database administrators

Prerequisites

Understanding of database concepts and database fundamentals
Knowledge of SQL
Minimum of two years of DBA experience is highly recommended

Learning Objectives

SAP IQ architecture
Install SAP IQ
Connect to SAP IQ
Plan for and create an SAP IQ database
Configure the server and database
Configure memory
Define SAP IQ data types and index types
Load data and manage data loading issues
Manage SAP IQ security
Create and manage multiplexes
Manage transactions and locking in SAP IQ
Monitor SAP IQ
Troubleshoot SAP IQ
Back up and restore SAP IQ databases

1. SAP IQ Overview and Architecture

Describing SAP IQ
Describing SAP IQ Architecture

2. Installation

Installing SAP IQ

3. SAP IQ Tools

Connecting to SAP IQ

4. SAP IQ Databases

Planning for SAP IQ Databases
Creating SAP IQ Databases

5. Server and Database Configuration

Configuring the Server

6. Memory Configuration

Configuring Memory

7. SAP IQ Data and Index Types

Defining SAP IQ Datatypes and Index Types

8. Table and Index Creation

Describing SQL in SAP IQ
Creating Tables
Creating Views
Creating Indexes

9. Data Loading

Loading Data

10. Additional Data Loading Topics

Inserting data
Resolving Data Loading Issues

11. Security Management

Designing a Security Model
Implementing a Security Model
Migrating Authorization

12. Multiplex

Creating a Multiplex
Managing a Multiplex
Managing Resources through Logical Servers

13. Transaction Management and Locking

Describing Transactions and Locking in SAP IQ

14. SAP IQ Monitoring

Monitoring SAP IQ

15. SAP IQ Troubleshooting

Troubleshooting SAP IQ

16. Backup and Restore

Backing Up SAP IQ databases
Restoring SAP IQ databases

17. Licensing and Premium Features

Generating SAP IQ Licenses

RELATED COURSES

Technical Training
SAP

SAP Business Planning and Consolidation(BPC440v10)

In this course, you will learn all of the key steps to set up consolidation based on the SAP Business Planning and Consolidation, version for SAP NetWeaver. You will learn consolidation-specific configuration and how to use the consolidation central tool. You will also learn how to use the data manager to execute currency translations, and perform eliminations for example. Additionally, you will be introduced to the EPM add-in for Excel.

This course is based on software release:

BPC 10.1 NW Standard Model SP5
SAP BW 7.4 SPS10
HANA SPS9
EPM add-in SP21
Design Studio 1.4
Analysis for Office 1.4.9

Technical Training
SAP

Introduction to Programming with ABAP

This course is based on software release SAP ECC 6.07 (SAP NetWeaver 7.40).

The ABAP Workbench Foundations programming courses require that you understand the content of this basic course.

Technical Training
SAP

SAP BusinessObjects Dashboards 4.1

In this course, you will learn about SAP BusinessObjects Dashboards 4.1, which is data visualization software. It enables you to transform Excel workbooks into captivating dashboards. You will learn how to build engaging dashboards for executives and business users. Dashboards provide insight into complex data and deliver confidence to those who the dashboard to make decisions.

As a business benefit, you will be able to connect your dashboards to any data source and provide everyone in your organization with up-to-the-minute personalized data. You’ll learn how to manage multiple data sources by controlling all live data connections from one central interface. You will improve your productivity by manipulating and linking your data to visually compelling analytics in a single design.

This course is based on software release SBO DASHBOARDS 4.1.

Technical Training
SAP

SAP BusinessObjects Business Intelligence Platform: Administration and Security

Perform key administrative tasks in SAP BusinessObjects Business Intelligence platform to manage users, groups, and objects, and to distribute contents to users

This course is based on software release SAP BusinessObjects BIP version 4.1.

Certification:

SAP Certified Application Associate – SAP BusinessObjects Business Intelligence platform 4.0
SAP Certified Application Associate – SAP BusinessObjects Business Intelligence Platform 4.1
SAP Certified Application Associate – SAP BusinessObjects Enterprise XI 3.x