create a report on top of salesforce

[Former Member]

Hi All,

If any one can help me,

How to create a report on salesforce database in IDT? How to configure salesforce database in to Business objects?

[Former Member]

To connect to sales for you will have to create a multisource universe in IDT as it leverage the data federation servers which are needed for connecting to salesforce.com

http://help.sap.com/businessobject/product_guides/sbo41/en/sbo41sp2_data_acs_en.pdf

Here are the setup steps that will help

7.10 salesforce.com Connections - To Configure the Environment

You must first configure your environment to make salesforce.com connections work either in the

universe design tool or in the information design tool.

1. Stop the Connectivity Service from the CMC and the client application.

2. Run regedit.exe in the MS Windows command line to open the Registry Editor.

3. Gotothe Salesforce ODBC datasourceunder HKEY_LOCAL_MACHINE > SOFTWARE > ODBC

> ODBC.INI > <SALESFORCE_DSN_NAME>, where SALESFORCE_DSN_NAME is thesalesforce.com

data source name.

4. Right-click the data source name and select New > String Value.

5. Enter CheckJVMChanged.

6. Double-click the property and enter 0.

7. Close the Registry Editor.

You must then follow the steps below to complete the configuration.

7.10.1 To Make salesforce.com Connections Work in the Information Design Tool

1. Exit the information design tool.

2. Copy the sforce.jar driver file to the bip-install-dir\win32_x86\jdk\jre6\lib\ext

directory.

3. Go to the bip-install-dir\win32_x86 directory.

4. Open the InformationDesignTool.ini for editing.

5. Add the following line at the end of the file:

-Dosgi.parentClassloader=ext

6. Save the file.

7. Restart the application.

When you complete this task, connections to salesforce.com are properly configured.

[Former Member]

Hi,

Please check the links below It may help .

http://blogs.datadirect.com/2012/05/sap-business-objects-universe-to-salesforce-crm-database-com-for...