Federation Server EssentialsBusiness Management
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
- User mappings
- Security issues
- Relational data source access
- SQL support
- 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.