1 / 20

IBM Office Connect 3.0

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

rona
Download Presentation

IBM Office Connect 3.0

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. 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

  2. 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

  3. 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

  4. Personal Edition Application Databases Personal Edition ODBC ODBC Personal Edition ODBC Personal Edition

  5. 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

  6. 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

  7. 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

  8. 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

  9. 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.

  10. Office Connect Components • Project Manager • Connection Manager • Model Viewer • Query Builder • Repository Manager • Web Query

  11. 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

  12. Connect to a database

  13. Import the Data Model

  14. Model Wizard Checkboxes allow you to select which tables to include in the model Save the model file so that it can be reused

  15. Project Manager and Data Model

  16. Drag a Table to the Worksheet

  17. Populating a Range

  18. A Populated Range

  19. 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

  20. 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

More Related