200 likes | 353 Views
IBM Office Connect 3.0. James Edmiston Consultant Quest Information Systems, Inc. 703-425-4726 james@questisinc.com. Mike Terrell IT Specialist IBM Data Management Solutions 703-448-2133 terrell0@us.ibm.com. What is Office Connect . Microsoft Excel Add In
E N D
IBM Office Connect 3.0 James Edmiston Consultant Quest Information Systems, Inc. 703-425-4726 james@questisinc.com Mike Terrell IT Specialist IBM Data Management Solutions 703-448-2133 terrell0@us.ibm.com
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 MTS InformixRDAS.DLL DCOM ODBC ODBC Definitions Personal Edition MTS Enabled No ODBC Definitions Developer File System Excel Workbooks Personal Edition ODBC Definitions
Web Edition Application Databases Servlet Engine Web Edition Servlet HTTP JDBC/HTTP Repository Web Client JDBC HTML DataSources ODBC/HTTP ODBC Web Edition Design Time
Deploying Web Edition HTML DataSource Web Pages Application Databases Middle Tier HTTP HTTP Server Tomcat Apacheetc Servlet EngineTomcat WebSphere JDBC HTTP Office Connect Servlet Web Client JDBC Repository
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
Project Manager Repository Manager Web Query Refresh worksheet Refresh workbook Save to DB Web Login and Find Web Logout Refresh Range Update Range Refresh Worksheet Using Office Connect Menus Toolbars Design Time Toolbar Run Time Toolbar
Model Wizard Checkboxes allow you to select which tables to include in the model Save the model file so that it can be reused
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 office-connect@iiug.org
Questions? James Edmiston Consultant Quest Information Systems, Inc. 703-425-4726 james@questisinc.com Mike Terrell IT Specialist IBM Data Management Solutions 703-448-2133 terrell0@us.ibm.com