This course is developed for Federation Server Version 9.5. 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.

If you are enrolling in a Self Paced Virtual Classroom or Web Based Training course, before you enroll, please review the Self-Paced Virtual Classes and Web-Based Training Classes on our Terms and Conditions page, as well as the system requirements, to ensure that your system meets the minimum requirements for this course.

http://www.ibm.com/training/terms

• 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

Please refer to the course overview for description information.

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

• 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