Before You Install the Recipe

You must perform the following configuration tasks on your Netezza and Salesforce accounts to successfully connect to these external systems using Oracle Integration.

Configure Salesforce

To access Salesforce using Oracle Integration and retrieve data about Salesforce customers that are created or updated, you must perform certain configurations on your Salesforce instance.

You must create a user account on Salesforce for Oracle Integration. You’ll use the credentials of this user account while configuring the Salesforce connection in Oracle Integration. Also, you must identify your Salesforce instance type and your current Salesforce API version.

• Log in to your Salesforce instance as an Administrator and execute the following tasks.
  1. You need username and password to configure connection with Oracle Integration. To retrieve the credentials, perform the tasks in Prerequisites to Use the Salesforce Username Password Policy (Deprecated).
  2. Identify your current Salesforce API version. See Find Your Current Salesforce API Version.

Configure Netezza

You must perform the following configuration tasks in Netezza,

• To configure Netezza, see Prerequisites for Creating a Connection.
• For this recipe, see the following example table query:

  create table sfdc_netezza (id int null,name varchar(1000) null,annualrevenue varchar(1000),phone int,accountnumber int,website varchar(1000),type varchar(1000),numberofemployees varchar(1000),billingaddress varchar(1000),shippingaddress varchar(1000))