Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-55

Salesforce connector doesn't expose standard connection pooling or caching connector properties

    Details

      Description

      The connector framework provides both caching and pooling support for connectors that implement the required interfaces. The SFDC connector code does indeed implement all of these interfaces.

      In order to allow users to fine tune caching or pooling behavior for a connector binding, the connector type's CDK file must also list all of the standard connector framework caching and pooling properties. The SFDC connector does not currently expose these properties.

      The SFDC connector's CDK file should be updated to include these properties. Unfortunately we don't document in the connector developer's guide what properties should be defined, but this info can be found in the definition of any of the standard JDBC connector types (Oracle ANSI, etc). These can be marked as "advanced" properties for SFDC as they are for the JDBC connector types.

      The max pooled connections per user property is especially important for SFDC, because of the hard limit on 5 concurrent server side cursors per user in SFDC.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                twalsh1 Tim Walsh
                Reporter:
                greghaber Greg Haber
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: