Articles & Content
Topic: 2009 NA
Subtopic: Cross Platform DB2 for z/OS & LUW
DATE: 2009-5-15 (10:30 AM - 11:30 AM)
SPEAKERS: Paul Zikopoulos (IBM Toronto Lab)
Microsoft calls Office users Information Workers; what's more, they are considered a development arm of their business. The fact that Microsoft Office's Excel and Access are some of the worlds' most popular reporting and analysis tools sometimes customers needlessly move and stage data to SQL Server for the sole purpose on enabling ends users to use their favorite tools without impacting their productivity. In this session, you'll learn how to hook up your Excel and Access applications to a DB2 server residing on any platform. You'll learn how to expose stored procedures in DB2 as a simple Access query, build reports, and more. In Excel, you'll learn how to get DB2 data into Excel, use Pivot Tables with DB2 data, and even store an Excel spreadsheet on DB2! After completing this session you will have to the tools you need to address concerns from these users with you data delivery platform.
EXP. LEVEL: Beginner,Intermediate,Advanced
The Microsoft Office Information Worker
Hooking up Excel to your DB2 data server
Working with DB2 and Excel
Hooking up Access to your DB2 data server
Working with DB2 and Access
Click Here to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.