Oracle® Cloud

Using Salesforce Cloud Adapter Configuration Wizard

12.1.3

E65458-02

October 2016

Oracle Cloud Using Salesforce Cloud Adapter Configuration Wizard, 12.1.3

E65458-02

Copyright © 2015, Oracle and/or its affiliates. All rights reserved.

Primary Author: Mark Kennedy

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, the following notice is applicable:

U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are "commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S. Government.

This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.

This software or hardware and documentation may provide access to or information about content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services, except as set forth in an applicable agreement between you and Oracle.

Contents

Preface

- Audience

- Documentation Accessibility

- Related Resources

- Conventions

1 Configuring Salesforce Cloud Properties

- Configuring Basic Information Properties

- What You Can Do from the Basic Info Page

- What You See on the Basic Info Page

- Configuring Oracle Cloud Adapter Connection and CSF Key Properties

- What You Can Do from the Oracle Cloud Adapter Connection Page

- What You See on the Oracle Cloud Adapter Connection Page

- What You Can Do from the Oracle Cloud Adapter CSF Key Page

- What You See on the Oracle Cloud Adapter CSF Key Page

- Configuring Salesforce Cloud Target Operation Properties

- What You Can Do from the Salesforce Cloud Target Operations Page

- What You See on the Salesforce Target Operations Page

- Configuring Salesforce Cloud Target Header Properties

- What You Can Do from the Salesforce Cloud Target Headers Page

- What You See on the Salesforce Target Headers Page

- Reviewing Configuration Values on the Summary Page

- What You Can Do from the Summary Page

- What You See on the Summary Page

Preface

Topics:

Using the Salesforce Adapter Configuration Wizard describes the pages of the Adapter Configuration Wizard that you are guided through to configure the Salesforce Adapter.

- Audience

- Related Resources

- Conventions

Audience

Using the Salesforce Adapter Configuration Wizard is intended for users who want to create, deploy, test, and monitor applications that use the Salesforce Adapter.

Documentation Accessibility

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.

Access to Oracle Support

Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.

Related Resources

For more information, see these Oracle resources:

- Developing SOA Applications with Oracle SOA Suite

- Administering Oracle SOA Suite and Oracle Business Process Management Suite

- Administering Oracle Service Bus

- Understanding Technology Adapters

Conventions

The following text conventions are used in this document:

Convention

Meaning

boldface

Boldface type indicates graphical user interface elements associated with an action, or terms defined in text or the glossary.

italic

Italic type indicates book titles, emphasis, or placeholder variables for which you supply particular values.

monospace

Monospace type indicates commands within a paragraph, URLs, code in examples, text that appears on the screen, or text that you enter.

1 Configuring Salesforce Cloud Properties

The Salesforce Cloud adapter enables you to create integrations with a Salesforce Cloud application.

The following sections describe the wizard pages that guide you through configuration of the Salesforce Cloud adapter as a target in an integration.

Topic

- Configuring Basic Information Properties

- Configuring Oracle Cloud Adapter Connection and CSF Key Properties

- Configuring Salesforce Target Operations Properties

- Configuring Salesforce Target Headers Properties

- Reviewing Configuration Values on the Summary Page

Configuring Basic Information Properties

You can enter a name and description on the Basic Info page of each source and target adapter in your integration.

Topics

- What You Can Do from the Basic Info Page

- What You See on the Basic Info Page

What You Can Do from the Basic Info Page

You can specify the following values on the Basic Info page. The Basic Info page is the initial wizard page that is displayed whenever you drag an adapter to the trigger (source) or invoke (target) area supported by your adapter.

- Specify a meaningful name.

- Specify a description of the responsibilities.

What You See on the Basic Info Page

The following table describes the key information on the Basic Info page.

Element

Description

What do you want to call your endpoint?

Provide a meaningful name so that others can understand the responsibilities of this connection. You can include English alphabetic characters, numbers, underscores, and dashes in the name. You cannot include the following:

- Blank spaces (for example, My Inbound Connection)

- Special characters (for example,  #;83& or righ(t)now4)

- Multibyte characters

What does this endpoint do?

Enter an optional description of the connection’s responsibilities. For example: This connection receives an inbound request to synchronize account information with the cloud application.

Configuring Oracle Cloud Adapter Connection and CSF Key Properties

Enter the Oracle Cloud adapter configuration connectivity and Credential Store Framework (CSF) key values for your integration.

Topics

- What You Can Do from the Oracle Cloud Adapter Connection Page

- What You See on the Oracle Cloud Adapter Connection Page

- What You Can Do from the Oracle Cloud Adapter CSF Key Page

- What You See on the Oracle Cloud Adapter CSF Key Page

What You Can Do from the Oracle Cloud Adapter Connection Page

You can specify the following connection values for the Oracle Cloud adapter.

- Specify the WSDL URL for some adapters. If you are configuring the Oracle Eloqua Cloud adapter, no WSDL is required.

- Specify the security policy.

- Create the authentication key. A key created for one direction (for example, outbound) is also available for selection in the other direction (for example, inbound).

What You See on the Oracle Cloud Adapter Connection Page

The following table describes the key information on the Oracle Cloud adapter Connection page.

Element

Description

WSDL URL

Note: This field is not displayed for the Oracle Eloqua Cloud adapter.

Specify the WSDL. The WSDL is used to build integrations specific to your instance. You can also select the WSDL from a file system or another source by choosing the browser icon next to the WSDL URL field. Click File System at the top of the dialog, then browse for the WSDL.

Security Policy

Select the security policy appropriate to your environment (for example, USERNAME_PASSWORD_TOKEN).

- The wizard shows all policies, including those that may not be applicable. To make a correct selection, you must have a knowledge of policies. For example, you cannot select a SAML-based policy because the identity is not propagated.

- The policies you apply to the cloud adapter are unique to the cloud adapter and do not impact other endpoints in the composite.

Authentication Key

Select the CSF authentication key.

- Add: Click to create a new authentication key. You must specify the key name, user name, and password.

- Edit: Click to edit an authentication key.

- Delete: Click to delete an authentication key.

Test

Click to validate the authentication key.

What You Can Do from the Oracle Cloud Adapter CSF Key Page

You can specify the following CSF key values for the Oracle Cloud adapter.

- CSF key name

- User name and password

- If you are configuring the Oracle NetSuite Cloud adapter only, you must specify an email account and role.

- If you are configuring the Oracle Eloqua Cloud adapter only, you must specify a company name.

What You See on the Oracle Cloud Adapter CSF Key Page

The following table describes the key information on the Oracle Cloud adapter CSF Key page.

Element

Description

CSF Key Name

Specify the CSF key to enable runtime injection of credentials. The adapter uses the CSF to retrieve the username and password required for authentication with the application (for example, the Oracle Sales Cloud or Oracle HCM application). This key identifies your login credentials during design-time. To successfully deploy and administer your application, you must specify these same values in Oracle Enterprise Manager Fusion Middleware Control.

Company Name (Oracle Eloqua Cloud adapter only)

Note: This field is only displayed for the Oracle Eloqua Cloud adapter.

Specify the Oracle Eloqua company name.

Email Account and Role

Note: This field is only displayed for the Oracle NetSuite Cloud adapter.

Specify the email account and role.

User Name

Enter the user name for connecting to your application (for example, the Oracle Sales Cloud or Oracle ERP application). Your administrator provides you with user credentials.

Password

Enter the password for connecting to your application.

Re-enter Password

Re-enter the same password a second time.

Configuring Salesforce Cloud Target Operation Properties

Enter the Salesforce Cloud target operation values for your integration.

Topics

- What You Can Do from the Salesforce Target Operations Page

- What You See on the Salesforce Target Operation Page

What You Can Do from the Salesforce Cloud Target Operations Page

You can configure the following target operations values for Salesforce Cloud.

- Select either of the following operation types:

1. CRUD

2. Salesforce Object Query Language (SOQL) or Salesforce Object Search Language (SOSL) query

- Select the business objects.

- Specify the SOQL/SOSL query.

What You See on the Salesforce Target Operations Page

The following table describes the key information on the Salesforce Cloud target Operations page.

Element

Description

Select an Operation Type

Select the type of operation to perform:

- CORE : Represents all core operations supported by the Salesforce application.

- CRUD: Represents the create, read, update, delete, or destroy operation to perform on Salesforce business objects. Each letter maps to a standard SQL statement, HTTP method, or DDS operation. Select the CRUD operation to perform: Create, Delete, Retrieve, or Update.

- MISC: Represents specialized task operations (such as fetching user information associated with the current session) in the Salesforce application.

- SOSL/SOQL: Select to enter a Salesforce Object Query Language (SOQL) or Salesforce Object Search Language (SOSL) query to send as a request to the Salesforce application. The following operations are available:

- query: Executes a query against specific criteria and returns data matching that criteria. Only records not deleted from your Salesforce application account are returned.

- queryAll: Returns the same data as the query operation, along with deleted records present in the recycle bin.

- search: Returns records from the Salesforce application. You can specify binding parameters to dynamically provide a search string as input to your search operation.

If you select this option, the page is refreshed to display a field for entering an SOQL or SOSL query to send for validation:

- Query Statement: Enter a valid query statement. SOQL statements evaluate to a list of sObjects, a single sObject, or an integer for count method queries. The following examples are provided:

“SELECT Id FROM Contact WHERE Name LIKE 'A%' AND MailingCity = 'California'”

SELECT COUNT() FROM Contact

SOSL statements evaluate to a list of sObjects, where each list contains the search results for a particular sObject type. For example:

“SELECT a.name, a.id, a.accountNumber, c.name from Contact c, c.Account”

- Binding Parameters: Displays any parameters included in the query. For example, orgId is a parameter in the following query:

SELECT a.name, a.id, a.accountNumber, c.name from Contact c, c.Account a WHERE a.name = "&orgId"

This query displays a binding parameters text box in which to enter a test value for orgId.

- Test My Query. Click to validate the query against the Salesforce application. Query results are displayed. If errors occur, you receive results about how to correct the query.

Filter By Object Name

Type the initial letters to filter the display of business objects. You can also select a filter type:

- All: Displays all objects.

- Custom: Displays objects you created. Custom business objects are appended with “_c.”

- Standard: Business objects delivered as part of the Salesforce application.

Select Business Objects

Select a single or multiple business objects to include in the operation. You can select up to ten objects for one operation.

Configuring Salesforce Cloud Target Header Properties

Enter the Salesforce Cloud target header values for your integration.

Topics

- What You Can Do from the Salesforce Target Headers Page

- What You See on the Salesforce Target Headers Page

What You Can Do from the Salesforce Cloud Target Headers Page

You can configure the target header properties for Salesforce Cloud.

What You See on the Salesforce Target Headers Page

The following table describes the key information on the Salesforce Cloud target Headers page.

The headers available for configuration are based on the operation you selected on the target Operations page. There are two types of headers:

- Request headers are sent with the request message to the Salesforce application.

- Response headers are received with the response message sent from the Salesforce application.

For more information about these header properties, visit www.salesforce.com and specify the specific name of the property in the search utility.

Element

Description

AllOrNoneHeader (request header)

Specifies the transactional behavior for Salesforce application operations. If you set AllorNone to true, the call to the Salesforce application is committed only if it completes without any errors. Otherwise, it is rolled back. The default behavior is to commit partial records without any error.

AllowFieldTruncationHeader (request header)

Specifies the truncation behavior for the following fields (each are string data types):

- anyType

- email

- picklist

- encryptedstring

- textarea

- mulitpicklist

- phone

- string

Set allowFieldTruncation to one of the following values:

- True: If you enter a value of 25 characters in a field of 20 characters, the first 20 records are inserted into the field and the transaction is successful.

- False: If you enter a value of 25 characters in a field of 20 characters, an error is thrown and the transaction does not commit.

AssignmentRuleHeader (request header)

Specifies the assignment rule to use when creating or updating an account, case, or lead. The assignment rule can be active or inactive. The ID is retrieved by querying the AssignmentRule object. If the ID is specified, you do not need to specify the useDefaultRule value.

- assignmentRuleId: The ID of the assignment rule to use. The ID is not validated by the Salesforce Cloud application, whether or not it exists. Validation occurs during runtime.

- useDefaultRule: If set to true, the default (active) assignment rule is used. If set to false, the default (active) assignment rule is not used.

EmailHeader (request header)

Specifies whether or not to send a notification email. You can set the following properties:

- triggerAutoResponseEmail

- true: Triggers automatic response rules for leads and cases.

- false: Automatic response rules for leads and cases are not triggered.

- triggerOtherEmail

- true: The email is triggered outside the organization.

- false: The email is not triggered outside the organization.

- triggerUserEmail

- true: The email is triggered and sent to users in the organization. This email is triggered by a number of events such as adding comments to a case or updating a task.

- false: The email is not triggered and sent to users in the organization.

DebuggingHeader (request header)

Specify the debugging log level. The following log levels are supported:

- NONE (least verbose)

- DEBUGONLY

- DB

- PROFILING

- CALLOUT

- DETAIL (most verbose)

MruHeader (request header)

The Salesforce application shows the most recently used (MRU) items. In API version 7.0 or later, the list is not updated by itself. Use MruHeader to update the list. Using this header can negatively impact performance. Set updateMru to one of the following values:

- true: The list of MRU items is updated in the Salesforce application.

- false: The list of most recently used items is not updated in the Salesforce application.

PackageVersionHeader (request header)

Specifies the package version for any installed package. The package version identifies the components in a package. The package version follows the format majorNumber.minorNumber.patchNumber (for example, 3.4.5, where 3 refers to majorNumber, 4 refers to minorNumber, and 5 refers to patchNumber) .

QueryOptions (request header)

Specifies the batch size for queries. The default value is 500, the minimum value is 200, and the maximum value is 2000.

DebuggingInfo (response header)

This information is only returned if the debugLevel request header is sent with the request payload to the Salesforce application.

LimitInfoHeader (response header)

Provides information about the limitations of API calls on a per-day basis for the organization.

- current: The number of calls already used in the organization.

- Limit: The organization’s limit for the specified limit type.

- Type: The limit information type specified in the header API REQUESTS (contains limit information about API calls for the organization).

Reviewing Configuration Values on the Summary Page

You can review the specified adapter configuration values on the Summary page.

Topics

- What You Can Do from the Summary Page

- What You See on the Summary Page

What You Can Do from the Summary Page

You can review source or target configuration details from the Summary page. The Summary page is the final wizard page for each adapter after you have completed your configuration.

- View the configuration details you defined for the source or target adapter. For example, if you have defined an inbound source adapter with a request business object and immediate response business object, specific details about this configuration are displayed on the Summary page.

- Click Done if you want to save your configuration details.

- Click a specific tab in the left panel or click Back to access a specific page to update your configuration definitions.

- Click Cancel to cancel your configuration details.

What You See on the Summary Page

The following table describes the key information on the Summary page.

Element

Description

Summary

Displays a summary of the source or target configuration values you defined on previous pages of the wizard.

For adapters for which a generated XSD file is provided, click the XSD link to view a read-only version of the file.

To return to a previous page to update any values, click the appropriate tab in the left panel or click Back.

Oracle Legal Notices

Copyright Notice

Copyright © 1994-2017, Oracle and/or its affiliates. All rights reserved.

License Restrictions Warranty/Consequential Damages Disclaimer

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

Warranty Disclaimer

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

Restricted Rights Notice

If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, then the following notice is applicable:

U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are "commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S. Government.

Hazardous Applications Notice

This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.

Trademark Notice

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.

Third-Party Content, Products, and Services Disclaimer

This software or hardware and documentation may provide access to or information about content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services, except as set forth in an applicable agreement between you and Oracle.

Alpha and Beta Draft Documentation Notice

If this document is in preproduction status:

This documentation is in preproduction status and is intended for demonstration and preliminary use only. It may not be specific to the hardware on which you are using the software. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to this documentation and will not be responsible for any loss, costs, or damages incurred due to the use of this documentation.

Private Alpha and Beta Draft Documentation Notice

If this document is in private preproduction status:

The information contained in this document is for informational sharing purposes only and should be considered in your capacity as a customer advisory board member or pursuant to your beta trial agreement only. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described in this document remains at the sole discretion of Oracle.

This document in any form, software or printed matter, contains proprietary information that is the exclusive property of Oracle. Your access to and use of this confidential material is subject to the terms and conditions of your Oracle Master Agreement, Oracle License and Services Agreement, Oracle PartnerNetwork Agreement, Oracle distribution agreement, or other license agreement which has been executed by you and Oracle and with which you agree to comply. This document and information contained herein may not be disclosed, copied, reproduced, or distributed to anyone outside Oracle without prior written consent of Oracle. This document is not part of your license agreement nor can it be incorporated into any contractual agreement with Oracle or its subsidiaries or affiliates.

Documentation Accessibility

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.

Access to Oracle Support

Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.