SAP Business objects DATA SERVICES Salesforce.com Adapter Interface Guide

Data Services Salesforce.com Adapter Interface Guide
BusinessObjects Data Services XI 3.0 (12.0.0)
Copyright
© 2008 Business Objects. All rights reserved. Business Objects owns the following U.S. patents, which may cover products that are offered and licensed by Business Objects: 5,555,403; 5,857,205; 6,289,352; 6,247,008; 6,490,593; 6,578,027; 6,831,668; 6,768,986; 6,772,409; 6,882,998; 7,139,766; 7,299,419; 7,194,465; 7,222,130; 7,181,440 and 7,181,435. Business Objects and the Business Objects logo, BusinessObjects, Business Objects Crystal Vision, Business Process On Demand, BusinessQuery, Crystal Analysis, Crystal Applications, Crystal Decisions, Crystal Enterprise, Crystal Insider, Crystal Reports, Desktop Intelligence, Inxight, the Inxight Logo, LinguistX, Star Tree, Table Lens, ThingFinder, Timewall, Let there be light, Metify, NSite, Rapid Marts, RapidMarts, the Spectrum Design, Web Intelligence, Workmail and Xcelsius are trademarks or registered trademarks in the United States and/or other countries of Business Objects and/or affiliated companies. All other names mentioned herein may be trademarks of their respective owners.
Third-party Contributors
Business Objects products in this release may contain redistributions of software licensed from third-party contributors. Some of these individual components may also be available under alternative licenses. A partial listing of third-party contributors that have requested or permitted acknowledgments, as well as required notices, can be found at: http://www.businessobjects.com/thirdparty
2008-03-12

Contents

Introduction 5Chapter 1
Audience and assumptions..........................................................................6
Overview and Installation 7Chapter 2
Adapter overview.........................................................................................8
Installing the Adapter for Salesforce.com....................................................8
Deploying the Adapter 9Chapter 3
Deployment overview................................................................................10
Configure the adapter................................................................................11
Create the datastore..................................................................................11
Working with Salesforce.com metadata....................................................12
Design flows..............................................................................................14
Run applications........................................................................................16
Understanding error messages.................................................................17
Requirements.........................................................................................8
Configure an adapter instance.............................................................11
Start and stop the adapter instance.....................................................11
Browse and import metadata...............................................................12
The DI_PICKLIST_VALUES table........................................................12
Open and delete imported metadata....................................................12
Metadata mapping................................................................................13
CDC datastore tables and generated columns....................................14
Changed data and Salesforce.com......................................................14
Data Services Salesforce.com Adapter Interface Guide 3
Contents
Index 21
4 Data Services Salesforce.com Adapter Interface Guide

Introduction

1
Introduction
1

Audience and assumptions

This user guide tells you how to use the BusinessObjects™ Data Services Adapter for Salesforce.com interface to integrate Salesforce.com version
6.0 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.
Audience and assumptions
This user guide assumes the following:
You understand how to use the most current version of 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 version 6.0.
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 version 6.0, familiarity with systems administration and systems integration issues is recommended.
6 Data Services Salesforce.com Adapter Interface Guide

Overview and Installation

2
Loading...
+ 15 hidden pages