Canada's Leader in Professional Development

855-581-7246 Call us: 1-855-581-7246

Federation Server Essentials

Currently no upcoming Class Dates

Description

This course explains Federation concepts and describes how to configure a federated database for accessing relational and non-relational data sources.

Learn Federation concepts and describes how to configure a federated database for accessing relational and non-relational data sources. Configuration involves defining wrappers, servers, and nicknames for linking to remote data sources. This course discusses access to both relational and non-relational data sources.

This course is developed for Federation Server Version 9.5.

Objectives

  • Describe the uses of federation technology
  • Use the DB2 Control Center to define wrappers, servers, user mappings, and nicknames
  • Recognize key factors that influence query performance
  • Explain key concepts of SQL support including compensation, passThru, and datatype and functional mappings
  • Explain the major security issues for protecting the federated environment

Audience

This is a basic course designed for DBAs who will configure and maintain a Federation Server database.

Prerequisites

You should have:

  • Basic knowledge of relational database administration for an RDBMS such as DB2, Oracle, or SQL Server
  • Knowledge of SQL
  • Knowledge of how relational databases are used within a business

Duration

3 days

Topics

  • What is Federation
  • How it works
  • Usage scenarios
  • Architecture
  • Wrapper
  • Server
  • Nicknames
  • User mappings
  • Security issues
  • Relational data source access
  • SQL support
  • Compensation
  • PassThru
  • Datatype, function mappings
  • Non-relational data source access
  • Performance and optimization

Click here to reach us by Email Contact Us
About | Terms of Use | Privacy Visit our Facebook page   Visit ot Linkedin page   View our Tweets