Sonic Database Service
Simplified Enterprise-wide Integration of Data Sources
Simplify access and reuse of relational data sources in a service-oriented architecture (SOA) with Progress® Sonic® Database Service. By eliminating the need for inflexible and costly custom coding, the Sonic Database Service makes it easy to configure and execute queries, updates and stored procedures as broadly-available services on Sonic ESB.
Sonic Database Service is a native ESB service that enables ESB applications to access relational data stored in JDBC-enabled data sources from any location on the enterprise service bus. The Sonic Database Service enables a Sonic ESB application to execute SQL statements and stored procedures and transforms the result set into an XML document, thereby eliminating the associated coding required.
Sonic Database Service embeds DataDirect Connect for JDBC drivers, the fastest and most comprehensive set of Type 4 JDBC drivers. With support for all the major databases, developers can standardize on one driver set and do not have to deal with the frustrations of working with different drivers of varying quality and multiple support organizations. The drivers are built on a common architecture and all have similar implementations of the JDBC standard. Out-of-the-box support is provided for leading databases including: Progress OpenEdge, Oracle 8i, IBM DB2, Microsoft SQL Server, Sybase Adaptive Server, and Informix Dynamic Server. The Sonic Database Service can integrate any JDBC driver and its associated data sources, e.g. Microsoft Excel.
As companies move to standardize on XML and achieve greater reuse of existing data assets through the implementation of service-oriented architectures, the challenge is to easily convert relational data result sets into XML documents. Without a service framework for database access and management, significant time is spent coding XML transformations in languages such as C++, Java and JavaScript and configuring the associated connection settings, management functions and service interactions. What is needed is a more productive and natural way for a database to be accessed and reused as a service by other services throughout the enterprise.
The Sonic ESB Database Service meets these needs, delivering the benefits below:
- Easy incorporation of relational data sources into your SOA infrastructure.
- Rapid integration of popular relational databases.
- Rapid integration of JDBC-compliant data sources such as Microsoft Excel.
- Increased scalability and reliability of database services made available on the ESB.
- Ability to customize database queries at runtime.
- Seamless integration of relational data with ESB processes without coding.
- Query scheduling offers a flexible choice for database interactions.
- Configuration-driven development and testing of database queries eliminates custom coding.
- Ability to start, stop, monitor, and configure database services from anywhere on the ESB.
Sonic Database Service enables ESB applications to access relational data stored in JDBC-enabled data sources from any location on the enterprise service bus. Here is a look at some of the features Sonic Database Service has to offer:
- Service interface to database queries, updates and stored procedures.
- Relational database support with out-of-the-box connectivity for leading relational databases, including Progress, Oracle, DB2, SQL Server, Informix and Sybase.
- JDBC driver support that integrates any JDBC driver and its associated data source.
- Load balancing offers support for client load balancing, connection failover and connection retry.
- Parameterized queries will populate SQL query parameters based on XML message parameters or use if Dynamic SQL.
- Result set transformer maps SQL query result set to populate XML message(s).
- Query scheduling can execute upon receipt of a message or at a scheduled time using a polling query.
- Database operation editor provides an intuitive environment to create, test, and debug SQL queries, map XML messages to SQL query parameters and map result sets to XML message.
- ESB-enabled management allows you to control database service configuration and database connections through a Sonic management console.
Sonic Database Service V7.6.2
For a list of supported platforms for functionally stable, mature or retired products, visit our Platform Support Archives page.
| Operating System and Version | Processor | JVM Vendor and Version |
| Microsoft Vista Business SP2 | x86-32 | Sun V1.6.0 [32-bit] |
| Sun V1.5.0 [32-bit] |
||
| IBM V1.4.2 [32-bit] |
||
| Microsoft XP Professional SP3 | x86-32 | Sun V1.6.0 [32-bit] |
| Sun V1.5.0 [32-bit] |
||
| Sun V1.4.2 [32-bit] |
||
| IBM V1.4.2 [32-bit] |
||
| Microsoft Windows Server 2003 SP2 | x86-32 | Sun V1.6.0 [32-bit] |
| Sun V1.5.0 [32-bit] |
||
| Sun V1.4.2 [32-bit] |
||
| IBM V1.4.2 [32-bit] |
||
| x86-64 | Sun V1.6.0 [64-bit] |
|
| Sun V1.5.0 [64-bit] |
||
| Microsoft Windows Server 2008 | x86-32 | Sun V1.6.0 [32-bit] |
| Sun V1.5.0 [32-bit] |
||
| Sun Solaris 9 | SPARC | Sun V1.6.0 [32-bit] |
| Sun V1.5.0 [32-bit] |
||
| Sun V1.4.2 [32-bit] |
||
| Sun V1.6.0 [64-bit] |
||
| Sun V1.5.0 [64-bit] |
||
| Sun Solaris 10 | x86-32 | Sun V1.6.0 [32-bit] |
| Sun v1.5.0 [32-bit] |
||
| Sun v1.4.2 [32-bit] |
||
| x86-64 | Sun V1.6.0 [64-bit] |
|
| Sun V1.5.0 [64-bit] |
||
| SPARC | Sun V1.6.0 [32-bit] |
|
| Sun V1.6.0 [64-bit] |
||
| Sun V1.5.0 [64-bit] |
||
| Red Hat Enterprise Linux 4 Update 6 | x86-32 | Sun V1.6.0 [32-bit] |
| Sun V1.5.0 [32-bit] |
||
| Sun V1.4.2 [32-bit] |
||
| x86-64 | Sun V1.6.0 [64-bit] |
|
| Sun V1.5.0 [64-bit] |
||
| Red Hat Enterprise Linux 5 Update 2 | x86-32 | Sun V1.6.0 [32-bit] |
| Sun V1.5.0 [32-bit] |
||
| Sun V1.4.2 [32-bit] |
||
| x86-64 | Sun V1.5.0 [32-bit] |
|
| Sun V1.6.0 [64-bit] |
||
| IBM V1.6.0 [64-bit] |
||
| IBM V1.5.0 [64-bit] |
||
| SuSE Enterprise Linux V9.0 SP3 | x86-32 | Sun V1.6.0 [32-bit] |
| Sun V1.5.0 [32-bit] |
||
| Sun V1.4.2 [32-bit] |
||
| SuSE Enterprise Linux V10.0 SP2 | x86-32 | Sun V1.6.0 [32-bit] |
| Sun V1.5.0 [32-bit] |
||
| Sun V1.4.2 [32-bit] |
||
| x86-64 | Sun V1.6.0 [64-bit] |
|
| IBM V1.6.0 [64-bit] |
||
| IBM V1.5.0 [64-bit] |
||
| IBM AIX 5L V5.2 | pSeries | IBM V1.5.0 [32-bit] |
| IBM V1.4.2 [32-bit] |
||
| IBM AIX 5L V5.3 | pSeries | IBM V1.6.0 [32-bit] |
| IBM V1.5.0 [32-bit] |
||
| IBM V1.4.2 [32-bit] |
||
| IBM V1.6.0 [64-bit] |
||
| IBM V1.5.0 [64-bit] |
||
| HP-UX V11i V2 | PA-RISC | HP V1.6.0 [32-bit] |
| HP V1.5.0 [32-bit] |
||
| HP V1.4.2 [32-bit] |
||
| Itanium | HP V1.5.0 [64-bit] |
|
| Sun V1.6.0 [64-bit] |
||
| HP-UX V11i V3 | Itanium | HP V1.6.0 [64-bit] |
| HP V1.5.0 [64-bit] |
Database Drivers
The Database Service uses the following JDBC drivers for 'out-of-the-box' connectivity:
- DataDirect Connect for JDBC v3.7
- Progress JDBC driver for OpenEdge RDBMS 10.1A or later
The Connect for JDBC v3.5 drivers support the following databases:
- IBM DB2 UDB
- IBM DB2 UDB v7.x, v8.1, v8.2 for Linux, UNIX, and Windows
- IBM DB2 UDB v7.x, v8.1 for z/OS
- IBM DB2 UDB v5R1, v5R2, v5R3 for iSeries
- Informix Dynamic Server v9.2x, v9.3x, v9.4, v10
- Microsoft SQL Server
- Microsoft SQL Server v7.0
- Microsoft SQL Server 2000 (including service packs 1, 2, 3a, & 4)
- Microsoft SQL Server 2000 Desktop Engine (MSDE 2000)
- Microsoft SQL Server 2000 Enterprise Edition [64-bit]
- Microsoft SQL Server 2005
- Oracle RDBMS
- Oracle 8i R2-R3 (8.1.6-8.1.7)
- Oracle 9i R1-R2
- Oracle 10g R1 (10.1)
- Oracle 10g R2 (10.2)
- Sybase Adaptive Server
- Sybase Adaptive Server 11.5, 11.9
- Sybase Adapter Server Enterprise 12.0, 12.5, 12.5.1, 12.5.2, 12.5.3
The Progress JDBC driver supports the following database:
- Progress OpenEdge RDBMS v10.C
Virtualization
Sonic 7.6.x is supported on any of the "7.6.x supported platforms", running on the following hosted environments:
- VMWare ESX 3.5
- HP-UX 11iV3 – Itanium2 VSE
Note: For Sonic Workbench (32 bit JVM) the guest operating system is Windows XP.
Products supported on this environment are to include:
- Sonic ESB Product Family
- Sonic MQ Product Family
IBM Zseries
Sonic 7.6.x has support for IBM Zseries with the following Guest operating systems:
- Red Hat 5 running IBM JVM 1.5 64 bit on ZVM
- Suse 10 running IBM JVM 1.5 64 bit on ZVM
Products supported on this environment are to include: * Sonic ESB Product Family * Sonic MQ Product Family.
