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
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