Salesforce Reader Parameters

Newline characters in field values are stripped out by the Salesforce reader.

Salesforce objects and records do not have geometry. All incoming features will not have geometry.

Salesforce fields of type base64 and address are not supported. Refer to User Attributes for details. To reduce bandwidth requirements and processing time, remove unused user attributes from the Salesforce reader’s feature types.

Salesforce Login

Host

Specifies the host through which to log in to Salesforce. Upon successful login, the Salesforce Reader will automatically switch to a different host if necessary.

Username and Password: Enter the username and password to access the service.

Security Token

If Salesforce is accessed outside of a trusted network, a security token is needed to log in.

Constraints

Tables

After specifying the database connection, click the Browse button (...) to select tables for import. A connection window appears while the system retrieves the tables from the database.

Once the Select Tables dialog appears, you can select one or more tables. Click OK to dismiss the window and add the selected table name(s) to the Tables parameter.

Additional Attributes to Expose

Use this parameter to expose Format Attributes in Workbench when you create a workspace:

  • In a dynamic scenario, it means these attributes can be passed to the output dataset at runtime.
  • In a non-dynamic scenario, this parameter allows you to expose additional attributes on multiple feature types. Click the browse button to view the available format attributes (which are different for each format) for the reader.

Specify which attributes to expose by entering the attribute names. Click the browse button next to the Additional Attributes to Expose parameter.

Note: If a SELECT Statement or WHERE clause is specified in the Salesforce Reader, the resulting attributes may be hidden. To expose the attributes created, you can place an AttributeExposer transformer in the workspace, after the Salesforce Reader. See Salesforce Reader: Feature Type Parameters