How to perform a MERGE operation on a Salesforce datasource in TIBCO Data VIrtualization?
Article ID: KB0070045
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | All Supported Versions |
Description
The generic MERGE or the ANSI SQL MERGE is not compatible with Salesforce. Hence a SQL Syntax error can be observed when a Salesforce datasource is queried using MERGE. Salesforce has its own implementation of MERGE which can be used in TIBCO Data Virtualization and how to do it is explained below.
Environment
All Supported Environment
Resolution
To perform the MERGE operation in TDV, implement the following resolution:
- Salesforce provides their implementation of MERGE as a stored procedure and it can be imported in TDV when the datasource is introspected/re-introspected.
- Use the following syntax in a TIBCO Data Virtualization's SQL script as a reference to call the MERGE stored procedure:
declare c cursor; call /shared/QA_SForce/Sources/SForce/"Merge"('ACCOUNT', '0016000000uycCqAAI', '0016000000uycCvAAI,0016000000uycQvABI' , c);
Issue/Introduction
This article will summarize on how to perform a MERGE operation with Salesforce Data Source in TIBCO Data VIrtualization.
Additional Information
https://docs.tibco.com/pub/tdv/8.8.0/doc/pdf/TIB_tdv_8.8.0_AdapterGuide_Salesforce.pdf?id=54#page=21
Feedback
Yes
No
Powered by
