Code
DX900RO
Duration
3 days
Tags
Online Offline

DescriptionWhat we offer

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.

ObjectivesWhat you learn

  • 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

TopicsThe best for you

  • 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

PrerequisitesWhat should you know

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

AudienceWho should attend

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