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

AS ABAP – Administration

Based on the fundamental understanding of SAP NetWeaver technology you gained in SAPTEC, this course introduces you to many different tasks that you will encounter as a person technically responsible for SAP systems based on SAP NetWeaver Application Server ABAP (AS ABAP). In this course, you will acquire knowledge and hands-on experience to keep the system running.

The course will not only provide lots of practical knowledge but will also give you some insight into the inner working of AS ABAP-based SAP systems.

Understanding the concepts and principles of the functions you are introduced to, will improve the efficiency of your day-to-day work and also prepares you for gaining detailed knowledge in more specialized tasks and topics

This course is based on software release SAP NetWeaver 7.4 SP10.

Technical Training
SAP

SAP Business Planning and Consolidation, version for SAP NW (Standard Edition): Administration & Planning Configuration

In this course, you will learn about architecture and administration including environments, dimensions, properties, hierarchies, models, connecting and planning in the EPM add-in, security, performance optimization, HANA optimization settings, administration parameters, activity and data audit, transports, project implementations, and validating member combinations. You will learn how to position calculation options, script Logic syntax, scoping, loops, variables, time offsets, allocations, running script logic real time and in data manager packages in batch mode, business add ins (BAdIs), dimension member formulas, MDX trace in HANA.

Additionally, you will learn how to use the data manager, add and configure new packages, run characteristic master data imports for members, attributes, and hierarchies including time dependent hierarchies, flat file imports, infoProvider imports, delta imports, running data manager packages from process chains. You will learn how to configure business process flows for planning, work status, and custom menus. The course concepts culminate in an end-to-end cost center accounting planning scenario.

This course is based on software release SAP Business Planning and Consolidation, version for SAP NetWeaver (Standard Edition) 10.1.

Certification:

SAP Certified Application Associate – SAP Business Planning and Consolidation

Technical Training
SAP

SAP Workflow – Concepts, Inboxes, Reporting and Using Standard Templates (BIT600v15_EHP7 for ERP 6.0)

Gain knowledge about SAP Business Workflow concepts. The course does not cover how to build customer-specific workflows. This course is not an introductory course. The units on reporting, customizing, and inboxes are discussed in this class only. This course is based on software release SAP ERP Central Component 6.0.

Technical Training
SAP

Migration to SAP HANA using DMO (HA250v12)

In this course, you will learn how to use the one-step migration procedure (DMO) to SAP HANA autonomously. You will learn about the most important tasks for the combined update and migration of an SAP system to the SAP HANA database. Furthermore, you will learn how to prepare the procedure and technical details of the process.

This course based is on software release:

SAP Business Suite 7i2016
SAP Enhancement Package 8 for SAP ERP 6.0
SAP NetWeaver AS ABAP 7.5