DB2 Office Connect Web Edition

Premeňte svoje statické Excel tabuľky na dynamické e-business aplikácie

DB2 Office Connect je komponent plug-in pre Microsoft Excel, ktorý umožňuje dômyselné dotazovanie a aktualizáciu databázy. Vytvára dynamicky aktualizované tabuľky, ktoré umožňujú plynulé vykonávanie SQL kódu v IBM dátových skladoch alebo v takmer všetkých ostatných zdrojoch údajov, ktoré sú v súlade s JDBC. Tretia generácia tohto nástroja na pripojenie umožňuje používateľom realizovať slice and dice operácie na údajoch v dobre známom a ľahko použiteľnom tabuľkovom procesore. Používatelia môžu vytvárať svoje vlastné reporty jednoducho spôsobom drag-and-drop, čím sa odbúravajú požiadavky na odborné znalosti z oblasti programovania.

Bezpečné webové Microsoft Excel aplikácie je možné nasadiť pri minimálnej investícii času a zdrojov. Takéto centralizované modely tabuliek sa môžu distribuovať cez firemný intranet alebo cez Internet do zabezpečeného riadeného prostredia.

Existujú tri vydania produktu DB2 Office Connect V4.0:

DB2 Office Connect Enterprise Web Edition - poskytuje neobmedzené používateľské licencie,

DB2 Office Connect Professional Web Edition - obsahuje päť používateľských licencií a

DB2 Office Connect Analytics Edition - je navrhnutý pre použitie s DB2 Cube.

Zistite viac

• Viac podrobností o produktoch (US)

Nakúpiť DB2 Office Connect Web Edition

ViacMenej

• Enables development of powerful BI applications just using Excel

• Binds Excel worksheets to databases for read and write capability

• Integrate multiple data sources in the same Excel application

• Allows creation of master detail and QBE scenarios

• Offers intuitive wizards and drag-and-drop interfaces that follow Excel's existing paradigm

• Leverages Excel's native functionality such as pivot tables, macros or functions

• Allows spreadsheet distribution to enterprise users to enable secure and role based (SSL and LDAP) access to databases over the web

• Java based application server runs inside any J2EE compliant web server

• Office Connect Web Client installs and upgrades silently over the web

• Certified against most of the popular databases including, DB2/UDB, DB2/390, Informix (all shades), MS Access, Oracle and Sybase

• Leverages the organization's existing skills and comfort with spreadsheet technology

• Uses drag-and-drop/point-and-click technology for managing enterprise data from within a spreadsheet

• Extends the organization's existing investment in office automation tools (Excel)

• Simplifies the deployment and distribution of reports (over an intranet and the internet)

• Simplifies the development and deployment of business-to-employee (B2E) and other data input applications such as human resources forms, budget planning forms, etc.

• Provides the missing link between existing spreadsheet solutions and databases

• Processes large volumes of database and other data source information for real-time access

• Reduces dependency on the MIS/IT organization to develop and deploy custom reports and applications

• Reduces dependency on complex third and fourth generation programming and reporting languages

• Makes the domain expert (Excel power user) the application developer

• Spreadsheets are centrally managed, with simple access control mechanisms

• Corporate data is maintained in a database, not the spreadsheet

• Collaborative, multiuser access is managed to prevent duplicate "master" spreadsheets

• Eliminates bugs introduced by extensive macros needed to provide even limited database access from Excel

• Permits remote access from any desktop PC running Excel over the intranet/internet

• Allows disconnected updates and data synchronization

• Highly scalable to grow with organization needs

• Complex analytical models and queries can be developed, tested, audited and deployed within the database server (instead of within the spreadsheet), and are made available to all spreadsheet users/applications.

• Changes to analytical models and queries are therefore tightly controlled and consistently deployed.