How to perform a MERGE operation on a Salesforce datasource in TIBCO Data VIrtualization?

How to perform a MERGE operation on a Salesforce datasource in TIBCO Data VIrtualization?

book

Article ID: KB0070045

calendar_today

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.

Issue/Introduction

This article will summarize on how to perform a MERGE operation with Salesforce Data Source in TIBCO Data VIrtualization.

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);

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
Powered by Wolken Software