Oracle Open Gateway version 4.0 includes support for executing stored procedures on third-party database servers, support for the Simple Network Management Protocol (SNMP) for management of gateways through common network management tools, better replication support for host systems, and overall faster query processing.
The new support allows applications built on the company's database server to execute stored procedures, in addition to data, on third-party database servers.
Stored procedures are small reusable pieces of code embedded within a database that execute frequently used statements. Typically, stored procedures are not portable between different manufacturers of database systems. The new support will let developers build Oracle-based applications that can work with multiple database servers that make up a larger corporate application, such as an order entry system that spans multiple sites.
Oracle also introduced Oracle Replication Services for IBM DataPropogator, a new product for automatically replicating data from host systems, such as IBM mainframes and AS/400 systems, into Oracle databases.
The company also said it is moving its gateway lineup onto Microsoft's Windows NT operating system within the next year. A new gateway to Microsoft SQL Server, announced today, is the first part of the plan.
Oracle's Transparent Gateway for Microsoft SQL Server version 4.0 and Replication Services for Data Propogator 1.2 are now shipping. Oracle Transparent Gateways for IBM DRDA, DB2, DB2/400, Sybase, Informix, and Ingres databases will ship late this year. All gateways are priced from $15,000.