David Darnell recommends an interesting migration route but this is a route which IMO is flawed because, apart from ODBC being yet another proprietary technology, it is limited by its inefficiencies. IMO a better way is to employ the new platform-neutral J2EE standard Connector Architecture compliant Enterprise Resource Adapter technology. ERA's run in Application Servers (like Weblogic, ANSI Web, Websphere, and maybe Bluestone). The interface to ERA's is provide by the Common Client Interface (CCI), an easy to implement platform-neutral set of Java classes. Because this approach completely devolves the data access from the application (presentation and business logic), moving to a different data source becomes a simple matter of changing the resource adapter. From a programming view point there is already support for ERA's and the CCI in IBM's latest release of Visual Age for Java (VAJ) - an excellent Java development environment which provides a multitude of facilities including a powerful visual editor, support for servlets, JSP's, and EJB's, plus a full test and deployment environment. VAJ integrates smoothly with Websphere Application Development Studio to provide a complete development environment. Running on a range of platforms, including Linux, this software is effectively platform-neutral. Also providing support for Connector Architecture based ERA's for Image and SapDB is Advanced Network Systems' Open Commerce Services. <plug> Evolve your HP e3000s and applications into platform-neutral, enterprise-scalable systems which integrate the old with the new and protects new investments whilst leverages existing investments. The new ANSI's Open Commerce Services (OCS), is a framework aimed specifically at Companies who know they are reliant on limited life, high TCO, "Proprietary systems"; Companies who need to ensure that they achieve and maintain competitive edge through the new initiative of Internet linked infrastructure to collaborate with Business Partners and manage the Supply Chain. ANSI OCS are based on open standards that integrate with existing systems and can respond and evolve to rapid change. Our message is "Continue to develop with confidence on the HP e3000 knowing that the solutions are operating system, DBMS, and Hardware neutral". Regardless of choice of hardware, operating system, or DBMS, including MPE/iX or IMAGE , solutions written using the ANSI OCS frame-work will interoperate with other solutions that follow current industry open systems standards, with little if any reprogramming. For VPLUS applications, ANSI OCS provides ANSI Studio, an extensible platform-neutral GUI-based IDE for evolving VPLUS presentation logic into J2EE and SOAP compliant components; Servlets, JSP's, and Java Applets, that can be deployed automatically to any J2EE compliant application server (ANSI-Web, WebLogic, WebSphere, BEA, Bluestone). The ANSI studio toolset can be integrated into IBM's Websphere Application Studio if required. For MPE based clients, ANSI OCS provides the MPE/iX Enterprise Client API. The complete, real-time solution, for MPE client access to Oracle, DB2, Sybase, SMTP servers, and Enterprise Applications (SAP/R3). MPE/iX Enterprise Client supports embedded SQL, thus providing an alternative for the now un-supported Oracle Gateway for the HP e3000. MPE specific client applications can also scale to other platforms by using MicroFocus COBOL or Oracles Pro*Cobol to compile embedded SQL Cobol programs. For evolving MPE based client applications to platform-neutrality, ANSI OCS provides ADBC-Image and ADBC-Eloquence, Java-based API's that provide direct, non-JDBC, access to IMAGE or to HP-ELOQUENCE, the multi- platform replacement for IMAGE. Also supported is direct platform- neutral client access to the MPE file system, MPE Intrinsic, Spooling, and KSAM. For additionally scalability, ANSI Web, the platform-neutral middle-tier J2EE standard application server, provides enterprise scalable database and connection pooling services. Finally for evolving data sources to platform-neutrality as well as for enabling access to heterogeneous Enterprise Information Systems (EIS), ANSI OCS provides J2EE compliant Enterprise Resource Adapters (ERA), implementations of the platform-neutral J2EE Connector Architecture. ANSI has ERA's available for IMAGE and SAPdB, our preferred DBMS; other ERA's are available from DBMS suppliers or third parties. More information will be provided as our strategic partners are put into place. Please visit our web site in the next few weeks for more details. </plug In article <[log in to unmask]>, David T Darnell <[log in to unmask]> writes >Another migration strategy that I have participated in, which gives you >time to re-write or develop replacement applications while continuing to >operate with existing HP3000 applications: > >1 - ODBC enable your HP3000. This is simpler than you might have heard if >you use ODBC/32 from Minisoft. Allows ODBC access to all IMAGE, KSAM, Flat >FIles (I'm not sure about MSG and CIR). Minisoft's ODBC/32 has extras for >you COGNOS/POWERHOUSE users. Easier to configure and manage than HP's >solution, IIRC. I have nothing against the MBFoster solution, I'm just not >familiar with it. > >2 - Replace your HP3000-based applications a chunk at a time, choosing >those chunks with an eye to #3, below, with ODBC-enabled client >applications you write yourself (again, not necessarily very difficult.) > >3 - Migrate your HP3000 data to an ODBC-enabled server, a chunk at a time. >One database, for instance, could be converted to (for bad example) SQL >Server once all the HP3000 apps accessing that database have been >eliminated. > >If you are a small shop on a tight budget, this is an attractive strategy >because you won't have to staff-up to start your migration. You can >approach your migration in a sane manner at whatever pace works. > >I have names of developers (including myself) who have worked this >scenario. > >-Dave Darnell > >* To join/leave the list, search archives, change list settings, * >* etc., please visit http://raven.utc.edu/archives/hp3000-l.html * > -------------------------------------- Chris Thompson The Internet Agency, UK http://www.the-internet-agency.com European Distributors for Advanced Networks Systems Inc. Distributors of CCS TRAX and CCS C-iX 'C' compiler for MPE Voice: +44 7836 364575 Fax: +44 1202 418209 Email [log in to unmask] Advanced Network Systems Inc. ANSI http://www.advnetsys.com Voice: +1 908-638-3330 Fax: +1 908-638-3331 Email [log in to unmask] ----------------------------------------- * To join/leave the list, search archives, change list settings, * * etc., please visit http://raven.utc.edu/archives/hp3000-l.html *