Federated Database with DB2 Information Integrator: Up and Running

start > courses and registration > training feature sheet

This course has been upgraded to:

»	U5789 WebSphere Information Integrator Federated Workshop

This course is no longer publicly scheduled and displayed for reference purposes only. To find more information about this course expiry or request this archived course, send us an email.

Federated Database with DB2 Information Integrator: Up and Running

course schedule			who can benefit
prerequisites			skills gained
other notes			course content
related solutions

code.

DW480

length.

3 days

type.

Instructor-Led

partner.

IBM

price.

$1,875

IACET credits 2.4

DB2 Federated Database Technology, as implemented by DB2 UDB and DB2 Information Integrator, provides unparalleled capabilities to access and manage both relational and non-relational data spanning multiple data sources, including multivendor, all from a single query. All of this with the superior performance you expect from DB2. 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, using, monitoring, and troubleshooting a Federated Database environment. Learn the configuration for all supported DB2 UDB and DB2 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 five-way join between these data sources from a single SQL statement.

Also, discuss DB2 Federated Technology's Life Sciences application, DiscoveryLink, and include it in some exercises.

There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links below.

who can benefit

Database administrators, application programmers, Data Warehouse (DW) administrators, system architects, and consultants. Business Intelligence (BI), e-business, application integration, and system integration professionals. Other professionals with an interest in architecting, planning, and constructing an Integrated DW or Online Transaction Processing (OLTP) solution.

prerequisites

You should complete:

? DB2 Family Fundamentals Courseware Package (CD-ROM) (CT030)
? OR understand the basic concepts of a relational database and its usage within a business

You should also 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.

skills gained

	Describe the advantages of using DB2 Federated Database technology for your systems and application integration project needs
	Describe the architectural and product components of an integrated DW or OLTP e-business solution related to the DB2 federated database approach, including the DB2 Information Integrator, DB2 UDB for UNIX, Windows and Linux, and DB2 Connect products in addition to the back end data sources
	Use the DB2 UDB Control Center to configure an operational federated database environment between any member of the DB2 UDB family and supported non-IBM sources, Oracle and Microsoft SQL Server
	Illustrate how DB2 Federated Technology can extend the reach of content management and Web services based solutions

this course has been combined

This course has been combined with:

? DB2 Federated Database Performance, Tuning, and Advanced Topics Workshop (DW490)

into a single five day course:

? DB2 Information Integrator Federated Workshop (U5789)

Please refer to U5789 for additional details and to check the course schedule.

ibm education advantage program eligibility:

	Yes - IBM Education Card
	Yes - IBM Education Pack
	Yes - IBM Corporate Education Pass
	Yes - IBM Education Pack - online account

skill level

Intermediate

course content details

	Course Content Outline

	Introduction to DB2 federated technology
	Configuring the federated environment
	Security: user mappings
	Type mappings
	Function mappings
	Passthru