Trust Your IT Training |
Oracle University Awards ExitCertified Corporation with North American Partner of the Year.
ExitCertified Strengthens Relationship with Red Hat with Advanced Reseller Status.
Oracle University Awards ExitCertified Outstanding Instructor Quality Award.
ExitCertified Featured in Dynamic Entrepreneurs of the 21st Century Book Release.
ExitCertified Corporation Receives Third Nomination for the Chamber of Commerce Awards.
ExitCertified Expands Apple relationship with the Addition of Authorized Mac OS Education Delivery in Phoenix, AZ.
 |
WebSphere Information Integrator Federated Workshop (U5789) |
 |
|
| Format: Instructor-Led Classroom |
| Other Formats: |
|
|
|
|
| IACET credits 4.0 |
|
| |
WebSphere Federated Database Technology, as implemented by DB2 UDB and WebSphere Information Integrator (formerly known as DB2 Information Integrator), provides unparalleled capabilities to access and manage both relational and non-relational data spanning multiple data sources, including multivendor, from a single query, all of this with superior performance. This is true cross platform multidatabase support without the cross platform limitations imposed by other federated tools and facilities.
Develop your skills by setting up and administrating a Federated Database environment. Learn the configuration for all supported DB2 UDB and WebSphere Information Integrator data sources. Complete hands-on exercises between DB2 UDB for Windows, DB2 UDB for z/OS and OS/390, DB2 UDB for AIX, Microsoft SQL Server, and Oracle databases are included. Using a server that you configure, perform an optimized four-way join between these data sources from a single SQL statement. Use the ability to create a Materialized Query Tables (MQT) based upon nicknames in order to employ a data grid. Access non-relational data sources, for example Excel spreadsheets, Extensible Markup Language (XML) documents or Web services, from DB2 SQL select statements.
Continue developing your management skills by monitoring, tuning, and troubleshooting a Federated Database environment. Learn the configuration options for all supported DB2 UDB and WebSphere Information Integrator data sources and how to tune the Federated Server for maximum Federated Database performance. Complete hands-on exercises in which you will further optimize your previously implemented four-way join while exploring tuning and problem determination options.
This course is appropriate for professionals working with DB2 UDB, WebSphere Information Integrator, and DiscoveryLink Federated Technology applications. |
|
|
|
|
|
|
|
 |
|
 |
Skills Gained |
| |
Configuring the federated environment
Define user mappings in order to connect to remote multivendor data sources
Change the default type mappings to have more appropriate data mappings for your environment
Define function mappings to make the federated server aware of remote fuctions
| |
Use Passthru to access the remote data source in native mode
Define the appropriate security settings to implement your desired federated security environment
Set the appropriate server, nickname, and column options in order to optimize performance
Tune the federated environment
| |
|
|
|
|
Who Can Benefit |
| |
This is an intermediate course for database administrators, application programmers, Data Warehouse (DW) administrators, system architects, and consultants. It is also for Business Intelligence (BI), e-business, application integration, and system integration professionals. Additionally, it is for other professionals with an interest in architecting, planning, and constructing an Integrated DW or Online Transaction Processing (OLTP) solution. |
|
|
|
|
Prerequisites |
| |
You should be able to configure DB2 clients using the DB2 Configuration Assistant or manual means or be able to set up client/server connectivity for either Oracle or Microsoft SQL databases.
You should complete: |
| |
IBM DB2 UDB Essentials Curriculum (T14D1)
| |
or understand the basic concepts of a relational database and its usage within a business
| |
|
|
|
|
Course Materials |
| |
he course materials cover WebSphere Information Integrator V8.2. |
|
|
|
|
Hands-On Labs |
| |
Ten labs are included to address helping you to implement a DB2 federated server to access both relational and non-relational data sources and to optimize accessing the various data sources. |
|
|
|
| |
 | This course is taught by Certified IBM instructors.
As your Authorized IBM Training partner, ExitCertified can put you in any IBM class in North America.
There is a difference. Learn More  |
|
 |
| Code: |
U5789 |
| Format: |
Instructor-Led Classroom |
|
| Length: |
5 days |
| Certified By: |
IBM |
|
|
|
|
| |
|
|
 | There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links below. We can also contact you when the course is scheduled in your area. |
|
|
|
WebSphere Information Integrator Federated Workshop (U5789) Content Details |
| |
| |
| Introduction to WebSphere federated technology | - recognize integration scenarios appropriate for WebSphere federated database technology
-
describe the intradatabase query performance advantages available via DB2's star burst global optimizer
-
identify the products required to implement a WebSphere federated environment
| |
| Configuring the federated environment | - establish client/server connectivity between the federated server and each prospective relational federated data source
-
create wrappers and define servers for the federated server
-
create nicknames to access data objects on each federated data source
-
describe the advantages of maintaining complete statistics for federated objects
-
maintain federated object statistics via manual efforts or the statistics tool and CREATE INDEX (SPECIFICATION ONLY)
| |
| Federated client security | - describe the complexities of securing a multivendor heterogeneous environment
-
define user mappings to handle multivendor, multisite requirements
| |
| Advanced options for implementing WebSphere federated environments | - discuss the need for data type and function mappings
-
describe how to perform both type and function mappings
-
contrast a full-function mapping and a function template
-
contrast a forward type mapping and reverse type mapping
-
describe DB2 federated Passthru option and its function
-
describe the federated data cache provided by federated MQT
-
implement a simple federated data cache
| |
| Configuring and using non-relational wrappers | - define DiscoveryLink
-
describe the major differences between relational and non-relational wrappers
-
create non-relational wrappers and define non-relational servers (federated data sources) for the federated server
-
create nicknames to access data objects on each non-relational federated data source
-
perform heterogeneous federated joins involving multiple data sources
| |
- describe the effects of federated Data Definition Language (DDL) on the federated server’s catalog views
-
query the catalog views to examine a given federated implementation
| |
| Federated environment security | - describe the complexities of securing a multi-DB2 and a multivendor heterogeneous environment
-
describe how to define a secure federated environment based on your own individual security needs
-
use the FED_NOAUTH configuration parameter appropriately to set up a secure federated environment based on your own individual security needs
| |
| Advanced options for implementing federated environments | - describe the server options available for federated servers and the function and performance implications of each
-
define server options via both the create server and alter server commands and the DB2 control center
-
discuss transaction atomicity as implemented by the DB2 federated technology
| |
| |
| Additional advanced topics | - describe how to automate the monitoring of a federated server using the DB2 Health Monitor
-
discuss the parallel processing capabilities WebSphere Information Integrator can use for requests involving both local tables and nicknames
-
describe the Unicode capabilities of WebSphere Information Integrator
| |
| The federated Distributed Relational Database Architecture Application Server (DRDA AS) | - describe the DRDA AS function of a DB2 UDB federated server
-
configure DB2 UDB federated server as a DRDA AS supporting TCP/IP clients
-
configure the DB2 UDB for z/OS and OS/390 Distributed Data Facility (DDF) as a DRDA Application Requester (AR)
-
configure a DB2 for iSeries server as a DRDA AR
-
bind DB2 UDB for z/OS and OS/390 packages at a DB2 UDB federated server database
-
access heterogeneous data from the DRDA AR
| |
| Tuning and problem determination in the WebSphere federated environment | - list and describe the DB2 Database Manager (DBM) and Database (DB) configuration parameters that can affect federated performance
-
list and describe the federated server options that can affect performance
-
use the DB2 Visual Explain and db2exfmt in conjunction with the DB2 performance monitor to tune individual queries for best federated performance
-
illustrate how to influence join techniques
-
describe the effects of common Data Definition Language (DDL) and Data Control Language (DCL) actions on the federated server and relate such to assist in problem determination
| |
| |
- Welcome
-
Unit 1 - Introduction to WebShpere Federated Technology
-
Exercise - Planning and Installation
-
Unit 2 - Configuring the Federated Environment (Relational Wrappers)
-
Exercise - Configurations
| |
- Exercise - Configurations (Cont)
-
Unit 3 - Federated Client Security
-
Exercise - Federated Client Security
-
Unit 4 - Advanced Options for Implementing WebSphere Federated Environments
-
Exercise - Practice With Some More Advanced Features
-
Unit 5 - Configuring and Using Non-Relational Wrappers
| |
- Unit 5 - Configuring and Using Non-Relational Wrappers (Cont)
-
Exercise - Non-Relational Wrappers (A Life Sciences Solution Example)
-
Unit 6 - Federated Catalog Tables
-
Exercise - Federated Catalog Tables
| |
- Unit 7 - Federated Environment Security
-
Exercise - Federated Environment Security
-
Unit 8 - Advanced Server Options in a Federated Environment
-
Exercise - Server and Nickname Options
-
Unit 9 - Additional Advanced Topics
-
Unit 10 - The Federated DRDA AS
-
Exercise - Implementing the DRDA Server
| |
- Unit 11- Tuning and Problem Determination in the WebSphere Federated Environment
-
Exercise - Tuning Federated Queries
| |
| |
 |
| |
 |
|
| |
When you take a certified course with ExitCertified, you are learning from
the creators of the products you use. Our commitment to your IT
community, along with our authorization to deliver certified courses,
ensures you receive a premium training experience.
There is a difference. Learn from the source. |
|
|
 |
|
|
 |
|
