The Salesforce API provides a "upsert" statement, which combines insert and update functionality.
      It would be great to use these feature either by using

      • the connector directly or
      • the UDF's or
      • per SQL.

            [TEIID-4481] Support for the upsert statement which is provided by Salesforce API

            Added support for the pushdown of the Teiid upsert to salesforce. This should work exactly as the the insert support for a single value, bulk, or in the direct query case.

            Steven Hawkins added a comment - Added support for the pushdown of the Teiid upsert to salesforce. This should work exactly as the the insert support for a single value, bulk, or in the direct query case.

            Moving to 9.2. With TEIID-4481 committed it is possible to update both the translator and the resource adapter to handle the pushdown of an insert marked as an upsert.

            Steven Hawkins added a comment - Moving to 9.2. With TEIID-4481 committed it is possible to update both the translator and the resource adapter to handle the pushdown of an insert marked as an upsert.

              Unassigned Unassigned
              tomesc Thomas Esche (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: