Use the Salesforce.com ODBC driver to publish Salesforce.com data in a BusinessObjects repository and access that data from a BusinessObjects client tool.
To do this, execute the file distribution that you downloaded in the previous step, and follow the on screen instructions.
The install program starts the Easysoft License Manager, because you cannot use the Salesforce.com ODBC Driver until a license is obtained.
The following types of license are available:
You MUST enter the Name, E-Mail Address and Company fields.
The E-Mail Address MUST be the same as the address used to register and download from the Easysoft web site or you will be unable to obtain trial licenses.
You are asked for a license type.
The License Manager asks what software you are licensing. Select from the drop-down list and then click Next.
The License Manager requests your authorization code.
Enter the authorization code and then click Next.
The License Manager then sends a request to the Easysoft license server to activate your license key automatically. This is the quickest method and results in your details being entered immediately into our support database.
Each of these methods involves providing Easysoft with information including your machine number (a number unique to your machine) and then waiting to receive your license key.
Instead of emailing your details to Easysoft, you can enter them directly at the Easysoft web site and your license key will be emailed to you automatically.
To use this method, click View Request, and then visit:
In the Licensing page, enter your machine number (and authorization code for purchased license), click Submit and your license key will be emailed to you.
When you receive the license key, you can activate it either by double-clicking the email attachment or by clicking Enter License on the License Manager main screen and pasting the license key into the dialog box.
The installation is complete.
Before you can use the Salesforce.com ODBC Driver to connect your application to Salesforce.com, you need to configure an ODBC data source. An ODBC data source stores the connection details for the target database (e.g. Salesforce.com) and the ODBC driver that is required to connect to it (e.g. the Salesforce.com ODBC driver).
To run ODBC Administrator on 32-bit Windows, open Administrative Tools in Control Panel, and then open Data Sources (ODBC). (On older versions of Windows, the Control Panel applet that launches ODBC Administrator is labelled Data Sources.)
There are two versions of ODBC Administrator on this platform. The version of ODBC Administrator that you need to run depends on whether the application you want to connect to Salesforce.com is 32-bit or 64-bit. For SAP BusinessObjects, Central Management Server is a 64-bit application. Business View Manager, Information Design Tool and Web Intelligence Rich Client are 32-bit applications.
If you have a 64-bit application, you need to run 64-bit version of ODBC Administrator. To do this, open Administrative Tools in Control Panel, and then open Data Sources (ODBC). (On Windows Server 2003 and earlier, the Control Panel applet that launches ODBC Administrator is labelled Data Sources. On Windows 8 and later, the Control Panel applet is labelled ODBC Data Sources (64-bit).)
If you have a 32-bit application, you need to run 32-bit version of ODBC Administrator. To do this, in the Windows Run dialog box, type:
If you are not sure whether your version of Windows is 32-bit or 64-bit, follow the instructions in this Microsoft Knowledge Base article to find out.
|User Name||The name of your Salesforce.com user. For example, firstname.lastname@example.org.|
|Password||The password for your Salesforce.com user.|
|Token||The security token for your Salesforce.com user, if required. |
To find out whether you need to supply a security token, choose the Test button. If the connection attempt fails with an error which contains
Salesforce.com emails the security token to the email address associated with your Salesforce.com user account. If you have not received a security token, you can regenerate it. Salesforce.com will then email the new security token to you. To regenerate your security token, log in to Salesforce.com and then choose Setup from the user menu. Search for "security token" in the Quick Find box. Click Reset Security Token in the Reset Security Token page. When you receive the token in your email client, copy it and then paste it into the Token field.
These instructions show you how to publish Salesforce.com data in a BusinessObjects repository and access that data from a BusinessObjects client tool. You need to install the Salesforce.com ODBC driver on both the BusinessObjects Server and client tools machines. You need to configure a Salesforce.com ODBC driver System data source with the same name on both these machines.
64-bit Windows The BusinessObjects Central Management Server is a 64-bit application, and so you need to configure the data source in the 64-bit ODBC Administrator. The BusinessObjects client tools are 32-bit applications, and so you need to configure the data source in the 32-bit ODBC Administrator.
The New Project dialog box is displayed.
The New Relational Connection dialog box is displayed.
The New Relational Connection dialog box is displayed.
The New Data Foundation dialog box is displayed.
The New Business Layer dialog box is displayed.
The Publish Universe wizard starts.
Your Universe is now available to the various BusinessObjects reporting tools. The remaining steps in this section will use Web Intelligence Rich Client to illustrate this.
The Universe dialog box is displayed.
Query Panel starts.
The Salesforce data is displayed in the Web Intelligence document.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.