The Progress® DataDirect® for JDBC™ for Oracle Eloqua™ driver supports SQL read-write access to Oracle Eloqua. To support SQL access to Oracle Eloqua, the driver creates a relational map of the Oracle Eloqua data model and translates SQL statements provided by the application to Oracle Eloqua queries and web service calls. The driver optimizes performance when executing joins by leveraging data relationships among Oracle Eloqua objects to minimize the amount of data that needs to be fetched over the network. The driver recognizes the relationships among standard objects and custom objects and can access and update each. Relationships among objects can be reported with the metadata methods getBestRowIdentifier(), getColumns(), getExportedKeys(), getImportedKeys(), getPrimaryKey(), getTables(), and getTypeInfo().

The documentation for the driver also includes the Progress DataDirect for JDBC Drivers Reference. The reference provides general reference information for all DataDirect drivers for JDBC, including content on troubleshooting, supported SQL escapes, and DataDirect tools.

For the complete documentation set, visit the Progress DataDirect Connectors Documentation Hub.