HP/MB Foster |
MB Foster |
MINISOFT |
Linkway |
|
Product Name |
ODBC/SE | ODBCLink |
ODBC/32 |
Linkway |
Licensing |
||||
Read/Write capability to Image Databases |
Yes | Yes |
Yes, to Image databases. |
Yes |
Support for ‘stored procedures’ |
No | Yes |
No, can be done with another MINISOFT product called MiddleMan. |
Yes |
Ability to set security based on OTHER than just the schema security (a requirement if you’re dealing with 3rd party databases you can’t control); not having to use MPE Userids would be a plus too |
No | Yes, using DataExpress module, Data Catalog with DataVues. Data extraction can be restricted by users or groups of users with Manager Plus. Extract file size can be limited as can number of read / writes. MPE userids are not used in these security proc |
Yes, MPE passwords can be setup so the user is prompted at logon. If the passwords are stored on the PC, they are encrypted |
|
Ability to set this security based on data/fields WITHIN records |
No | Yes, with Data Catalog |
No |
|
Able to support high transaction volume. The lower the system overhead the better. |
No | Yes, ability to join multiple tables in one join from various databases |
Hi-performance, same as M.B. Foster though MiddleMan can offer even better performance because calls to Image databases are direct via DBGET and DBPUTS etc | Yes |
Ability to control the TCP port# used for connections |
No | Yes, utilize port ID's > 10,000 |
Yes |
Yes |
Direct access to Image databases (*NO* DBEs) |
No | Yes |
Yes |
No |
Read/Write access to KSAM |
No | Yes |
Yes |
??? |
Read/Write access to MPE Files |
No | Yes |
Yes |
??? |
Support for Omnidex/Superdex keys |
No | Yes |
Yes |
Does for Image/SQL |
Support for Image B-trees and TPI |
No | Yes (TPI), Image B-trees under development |
Yes |
Part of ATC itself - not necessary for the driver |
Read/Write access for self-describing files |
No | Yes, PowerHouse and DataExpress |
Yes, supports read/write access for Cognos sub-files in our most recent version. |
No |
Price (purchase price and support costs) |
included w/FOS | See attachment |
Client and Server are included in the single license price. Support is 20% of the primary license. Support for right-to-copy licenses are included in the primary license support. License prices are as follows: Group A - 918, 928, 93 |
|
Support included with support contract |
n/a | 8am-8pm EST 800 telephone support. Upgrades included. |
800 number 7am to 6pm PST, email, fax |
|
Planned support for ODBC 3.5 |
3.5 compliant in future release |
Currently 3.0 compliant and committed to 3.5 support in a future release | Yes |
|
Y2K compliant |
Yes | Yes |
Yes |
Yes |
The ability to pre-select data (do host based queries) and access the query results via ODBC |
Yes | Yes, in addition, reports can be run at night and be waiting in presentation mode such as an Excel spreadsheet |
Support QUIZ and query (SUPRTOOL) formats (release in a couple of weeks) |
Linkway is the only driver that does all selection / processing on the server. All others transfer all records to the client, then the engine will select from there |
Ability to set priority (queues) for certain IDs or query-types |
No | Yes |
No |
Yes |
Ability to display (on the 3000) a list of userids accessing ODBC and what they have open |
No | No, ODBCLink Console will provide (release slated for Mar. '99) |
Yes |
Yes |
Ability to "cleanly" kill one (or more) of those accessors |
No | No, ODBCLink Console will provide (release slated for Mar. '99) |
Yes, via the console server program which is included in the driver license |
Yes |
Ability to support multiple simultaneous queries (multithreaded) |
No | Yes, ODBCLink v5.57 |
Yes |
Yes |
16 and 32 bit client support |
Yes | Yes, also terminal |
No. MiddleMan supports both 16 and 32 bit |
Yes |
Network-friendly installation support (for those of us who may need to install to hundreds/thousands of desktops) |
No | Yes, installation wizard |
Yes |
|
Support for Binary Large Objects (BLOBs) |
No | Yes |
No, developers indicated that Image doesn't support BLOB's. |
Yes |
Maximum number of concurrent statements/cursors? |
48 / user connection |
32 / user connection |
||
Support for mapping HP (Roman8) characters to Windows (ANSI) |
Yes | Yes, as well as other character sets |
Yes |
Yes |
Support for "embedded SQL" |
Yes, Image/SQL, Allbase/SQL, Oracle |
No |
Yes |
|
Supports customized dataviews |
No | Yes, DataExpress |
Yes |
|
User Friendliness |
Yes (See 3000 article) |
Yes (Call References) |
||
Ability to join Windows NT data sources to HP 3000 data sources |
No | Yes, with DataExpress NT |
No |
|
Ability to re-map data from one data type to another |
No | Yes, such as Image to SQL |
Yes |
|
| Support for JDBC (Java Database Connectivity) | No | JDBC is now supported. Existing ODBC/32 users can add this functionality for $1,000 regardless of CPU size. | ||
Training |
No (HP Video available though) | Yes, on-site |
Yes, ODBC and MiddleMan (Training center in Seattle, WA. Classes are held at customer sites and SGA occasionally). 3 day class in Seattle is costs $750 |
|
Handle many to many joins |
No | Yes |
Yes |
|
Contact Information |
Hewlett Packard | Karmin McKay (800) 267-9377 x235 |
Doug Greenup (800) 682-0200 Joe Grimm Neal Kazmi |
Joe Geiser |