The Ensemble SQL inbound and outbound adapters enable your Ensemble productions to communicate with JDBC or ODBC-compliant databases. This chapter provides a brief introduction to these adapters.
The adapters also provide methods to perform common SQL activities such as the following:
Executing stored procedures
Performing inserts, updates, and deletes
Performing database transactions
Connecting to and disconnecting from a data source
The adapters are clients and perform authentication by passing calls that include the username and password; they do not use authentication from the operating system.
Ensemble provides two helper classes that are used as arguments and return values for the built-in SQL methods:
At a high level, to include an adapter in a production, you do the following:
In most cases, your custom code resides within your business host class. You do not typically need to customize the adapters directly.