Skip Navigation Links | |
Exit Print View | |
About Oracle Java CAPS Database Adapters Java CAPS Documentation |
About Oracle Java CAPS Adapter for DB2 Connect
About Oracle Java CAPS Adapter for DB2 Universal Database
About the DB2 Universal Database Adapter
About Oracle Java CAPS Adapter for Informix
About Oracle Java CAPS Adapter for JDBC/ODBC
About Java Database Connectivity (JDBC)
Pure Java driver for database middleware
Type Four Driver: Direct-to-database pure Java driver
About Oracle Java CAPS Adapter for Oracle
About Oracle Java CAPS Adapter for Sybase
This topic provides information about Oracle Adapter for SQL Server.
SQL Server is Microsoft’s client-server Relational Data Base Management System (RDBMS), used for increased scalability, availability, and security of enterprise data and analytical applications while making them easier to create, deploy, and manage.
The SQL Server Adapter enables Oracle Java CAPS ESB Projects to exchange data with external SQL Server databases. This user’s guide describes how to install and configure the SQL Server Adapter.
The SQL Server Adapter uses JCDs (Java Collaboration Definitions) and BPEL (Business Process Execution Language to perform the following:
Query a database
Automatically generate a graphical user interface (GUI) tree representation of database access objects
Populate the structure with the actual data values during run time.
The SQL Server Adapter also uses the same GUI structure as the rest of the Oracle Java CAPS ESB system to describe data flow through the entire enterprise. This feature enables business analysts to define the relationships between a database and relevant applications by dragging and dropping elements between graphical tree structures.