Spreadsheets provide an intuitive and powerful front end to represent and manipulate business information. Microsoft® Excel is the de facto tool for spreadsheets. The main problem with Excel is its inability to seamlessly transfer information between the spreadsheet and a relational databases like DB2® or Informix®. Often the users end up writing complex macros to do this. This process is buggy, expensive, difficult to maintain, and frequently beyond the skill set of the regular Excel power user.
IBM® Office Connect 4.0 enables Excel users to overcome this limitation by providing a simple GUI-based patented process that enables information in an Excel spreadsheet to be transferred seamlessly to multiple databases. Office Connect transforms a normally static Excel spreadsheet to a dynamic e-business application by providing enterprise users, secure and authenticated database reporting and update capabilities, in an internet/intranet and client server environment.
There are two editions of DB2 Office Connect
DB2 Office Connect Enterprise Web Edition. Unlimited user licenses. Included in DB2 Data Warehouse Enterprise Edition.
DB2 Office Connect Professional Web Edition. Five user licenses. Included in DB2 Data Warehouse Standard Edition.
