SAP Business objects DATA SERVICES Supplement for Salesforce.com

Supplement for Salesforce.com

■ SAP BusinessObjects Data Services XI 4.0 (14.0.0)

2010-12-02

© 2010 SAP AG. All rights reserved.SAP, R/3, SAP NetWeaver, Duet, PartnerEdge, ByDesign, SAP Business ByDesign, and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP AG in Germany and other countries. Business Objects and the Business Objects logo, BusinessObjects, Crystal Reports, Crystal Decisions, Web Intelligence, Xcelsius, and other Business Objects products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of Business Objects S.A. in the United States and in other countries. Business Objects is an SAP company.All other product and service names mentioned are the trademarks of their respective companies. Data contained in this document serves informational purposes only. National product specifications may vary.These materials are subject to change without notice. These materials are provided by SAP AG and its affiliated companies ("SAP Group") for informational purposes only, without representation or warranty of any kind, and SAP Group shall not be liable for errors or omissions with respect to the materials. The only warranties for SAP Group products and services are those that are set forth in the express warranty statements accompanying such products and services, if any. Nothing herein should be construed as constituting an additional warranty.

2010-12-02

Introduction.............................................................................................................................5Chapter 1

1.1

2.1

2.1.1

2.2

2.2.1

3.1

3.2

3.2.1

3.2.2

3.3

3.3.1

3.4

3.4.1

3.4.2

3.4.3

3.4.4

3.4.5

3.5

3.5.1

3.6

3.7

Audience and assumptions.......................................................................................................5

Overview and installation........................................................................................................7Chapter 2

Installing the Adapter for Salesforce.com.................................................................................7

Requirements...........................................................................................................................7

Adapter overview.....................................................................................................................7

To use the Adapter for Salesforce.com from SAP BusinessObjects Data Services.................8

Deploying the Adapter............................................................................................................9Chapter 3

Deployment overview...............................................................................................................9

Configure the adapter..............................................................................................................9

Configure an adapter instance................................................................................................10

Start and stop the adapter instance........................................................................................12

Create the datastore..............................................................................................................12

To create an Adapter for Salesforce.com datastore...............................................................12

Working with Salesforce.com metadata.................................................................................14

Browse and import metadata.................................................................................................14

The DI_PICKLIST_VALUES table...........................................................................................15

Open and delete imported metadata......................................................................................15

Metadata mapping.................................................................................................................16

CDC datastore tables and generated columns.......................................................................17

Design flows..........................................................................................................................17

Changed data and Salesforce.com.........................................................................................17

Run applications.....................................................................................................................21

Understanding error messages..............................................................................................22

Index 25

2010-12-023

Contents

2010-12-024

Introduction

This user guide tells you how to use the SAP BusinessObjects Data Services Adapter for Salesforce.com interface to integrate Salesforce.com with Data Services.

The Data Services Adapter for Salesforce.com interface allows you to create a datastore that connects to the Salesforce.com web service and retrieves data using Data Services data flows.

1.1 Audience and assumptions

This user guide assumes the following:

• You understand how to use the most current version of SAP BusinessObjects Data Services to

design and run batch and real-time data flows and administer Data Services processes. (Administer adapters from the Administrator.)

• You have a working knowledge of Salesforce.com..

• You know what an adapter is and the role it plays in business systems integration.

• You are familiar with how to use SQL query statements.

• You understand Changed Data Capture concepts.

• You are familiar with object-oriented modeling and can work with an object-oriented XML configuration

file.

• Because you will integrate Data Services, the Data Services Adapter for Salesforce.com, and

Salesforce.com, familiarity with systems administration and systems integration issues is recommended.

2010-12-025

Introduction

2010-12-026

Overview and installation

2.1 Installing the Adapter for Salesforce.com

The SAP BusinessObjects Data Services Adapter for Salesforce.com is automatically installed when you install Data Services version 12.0.0 or later. The adapter is associated with several files including:

• Adapter jar files

• Adapter configuration templates

• Salesforce.com Software System extensions

•

User's Guide for Adapter for Salesforce.com

2.1.1 Requirements

The Job Server you associate with adapters must be configured to manage adapters. For general Job Server installation and configuration information, see the

Guide

Note:

For information about Salesforce.com, visit the Salesforce.com Web page.

SAP Business objects DATA SERVICES Supplement for Salesforce.com

Specifications and Main Features

Frequently Asked Questions

User Manual

Contents

Introduction

Overview and installation