My data source is SFDC, destination is an Oracle table. I need to get data from SFDC and merge into the Oracle database table by either insert or update. How to create a database profile to perform merge for the operation of database connector?
Hi Shu Song,
Once you perform Salesforce Query Operation (Salesforce Integration Guide) , you can use Map Shape with Salesforce Response profile as source and Database Profile as Destination, followed by Database Connector(Database Integration Guide )
Documents below should help you in creating Database Profile
Creating a databaseprofile from Component Explorer
Generating adatabase profile with the Import Wizard
Retrieving data ...