Transcript No Slide Title

IBM Office Connect 3.0
James Edmiston
Consultant
Quest Information Systems, Inc.
703-425-4726
[email protected]
Mike Terrell
IT Specialist
IBM Data Management Solutions
703-448-2133
[email protected]
What is Office Connect
• Microsoft Excel Add In
• GUI with model viewer and query builder
• Binds spreadsheet columns to database columns
or stored procedures
• Dynamic SQL filtering
• Update/insert capability
Deployment Options
• Personal Edition
– User connects directly to database
– Builds spreadsheets for personal use
• Web Edition
– Design Time client develops spreadsheet for use
by others
– Runtime client uses pre-developed spreadsheet
Personal Edition
Application
Databases
Personal
Edition
ODBC
ODBC
Personal
Edition
ODBC
Personal
Edition
Deploying Applications
Application
Databases
Middle Tier
Users
DCOM
MTS
InformixRDAS
.DLL
ODBC
ODBC Definitions
Personal Edition
MTS Enabled
No ODBC Definitions
File System
Excel
Workbooks
Developer
Personal Edition
ODBC Definitions
Web Edition
Application
Databases
Servlet
Web Edition Engine
Servlet
HTTP
Web Client
JDBC/HTTP
JDBC
Repository
ODBC/HTTP
ODBC
Web Edition
Design Time
HTML
DataSources
Deploying Web Edition
HTML
DataSource
Web
Pages
Middle Tier
HTTP
Servlet Engine
HTTP
Server
HTTP
Web Client
Tomcat
Apache
etc
Tomcat
WebSphere
JDBC
Office Connect
Servlet
JDBC
Repository
Application
Databases
System Requirements
• Client side
– IBM Office Connect 3.0
– Windows (95/98, NT 4.0 SP4, 2000 SP1)
– Excel 97 (Excel 2000 for Web edition)
– Informix Client SDK
– Web browser
• Server Side
– Windows or Unix
– Database server
Web Edition
•
Java 2 SDK 1.3
•
Apache Jakarta Tomcat Java Servlet Engine
•
IBM Office Connect Servlet installed into Tomcat
•
Install appropriate JDBC drivers (DB2 or JDBC)
•
ODBC datasource if using an Access repository.
Office Connect Components
• Project Manager
– Connection Manager
– Model Viewer
– Query Builder
• Repository Manager
• Web Query
Using Office Connect
Menus
Toolbars
Design Time Toolbar
Project Manager
Repository Manager
Web Query
Refresh
worksheet
Refresh
workbook
Run Time Toolbar
Save to DB
Web
Login
and Find
Refresh
Range
Web Logout
Update
Range
Refresh
Worksheet
Connect to a database
Import the Data Model
Model Wizard
Checkboxes allow you to select
which tables to include in the
model
Save the model file so that it
can be reused
Project Manager and Data Model
Drag a Table to the Worksheet
Populating a Range
A Populated Range
Online Resources
Office Connect 3.0 Tech Brief
http://www-4.ibm.com/software/data/informix/tools/officeconnect/
Office Connect product announcement
http://www.iiug.org/news/prod_alert_16oct01.html
Office Connect Email Discussion List
www.iiug.org, Resources, Discussion Groups
[email protected]
Questions?
James Edmiston
Consultant
Quest Information Systems, Inc.
703-425-4726
[email protected]
Mike Terrell
IT Specialist
IBM Data Management Solutions
703-448-2133
[email protected]