Integration between Salesforce and Oracle Eloqua
This section illustrates the migration of Account and Contacts from Salesforce to Oracle Eloqua systems. If there is an existing association of Contacts and Account in the Salesforce, the migration takes care to maintain the same in Oracle Eloqua system as well.
File Type | File Name |
---|---|
Data Flow |
|
DB Connection |
|
ModelStore |
|
- Create these connections:
- Salesforce_TestConnection with Type Salesforce. Click Test and a success message is displayed: The connection Salesforce successfully connected to the data source.
- Eloqua_TestConnection with Type Oracle Eloqua. Click Test and a success message is displayed: Success: The connection Eloqua successfully connected to the data source.
- Import and deploy files using the Spectrum Command line utility. Use following
commands in this order:
- Import modelstore using
command:
modelstore bulkimport –-importDependency true
- Deploy modelstore using
command:
modelstore deploy –-modelStoreName Eloqua_MS modelstore deploy –-modelStoreName Salesforce_MS
- Import dbconnection using command:
dbconnection import –-f Eloqua_MS.json dbconnection import –-f Salesforce_MS.json
- Import data flows using
command:#
dataflow import –-f SalesforceAccount_Sync_OracleEloquaAccount.df dataflow import –-f SalesforceContact_Sync_OracleEloquaContact.df
- Import modelstore using
command:
- Launch the Enterprise Designer application. You can download the executable setup of this application from Desktop section of Platform Client Tool on the Spectrum Platform home page.
- Login using your Spectrum credentials.
- Click View from the menu, click Server Explorer.
- Double-click the SalesforceAccount_Sync_OracleEloquaAccount dataflow job first.
- Double-click Read from DB stage.
- Change the value of field CreatedDate as required and click OK.
Select "SalesforcePM"."Account".* From "SalesforcePM"."Account" where CreatedDate > '2017-01-01'
- Click OK to continue.
- Change the value of field CreatedDate as required and click OK.
- Run the flow by clicking Run button on the Tool Bar in Enterprise Designer.
- Visit the Eloqua home page and click Account. Notice the accounts have migrated to Eloqua.
- Navigate back to Enterprise Designer.
- Double-click the SalesforceContact_Sync_OracleEloquaContact job.
- Double-click Read from DB stage.
- Change the value of the field CreatedDate as required and click OK.
Select "SalesforcePM"."Contact".* From "SalesforcePM"."Contact" where CreatedDate > '2017-01-01'
- Click OK to continue.
- Change the value of the field CreatedDate as required and click OK.
- Run the flow by clicking Run button on the Tool Bar in Enterprise Designer.
- Visit the Eloqua home page and click Contacts. Notice the contacts have migrated to Eloqua.
Note: For more details on how to create connections, see the
Metadata Insights Guide.