# tSalesforceOutput Inserts, updates, upserts, or deletes data in a Salesforce object. This component is not shipped with your Talend Studio by default. You need to install it using the Feature Manager. For more information, see [Installing features using the Feature Manager](https://help.qlik.com/talend/r/en-US/8.0/studio-user-guide/install-features-to-talend-studio). ## tSalesforceOutput Standard properties These properties are used to configure tSalesforceOutput running in the Standard Job framework. The Standard tSalesforceOutput component belongs to the Business and the Cloud families. The component in this framework is available in all Talend products. ## Basic settings | Properties | Description | | --- | --- | | Property Type | Select the way the connection details
will be set.



This property is not available when other connection component is selected from
the Connection Component dropdown list. | | Component list | Select the component that opens the database connection to be reused by this
component. | | Connection type | Select the type of the connection from the drop-down list. The connection
properties will vary according to the connection type you choose.

| | User Id | The Salesforce username.

This property is available only when the Basic connection type is selected. | | Password | The Salesforce password associated with the username.

This property is available only when the Basic connection type is selected. | | Security Token | The Salesforce security token. For more information, see [Reset Your Security Token](https://help.salesforce.com/articleView?id=user_security_token.htm&type=5).

This property is available only when the Basic connection type is selected. | | Issuer | The OAuth Consumer Key, generated when your
connected app is created and shown in the connected app detail page in Salesforce.
For more information, see [Create a Connected App](https://help.salesforce.com/articleView?id=connected_app_create.htm&type=5).

This property is available only when
the OAuth connection type is selected. | | Subject | The Salesforce username.

This property is available only when
the OAuth connection type is selected. | | Audience | Json Web Token audience.

You can set your own Json Web Token audience.

This property is available only when
the OAuth connection type is selected. | | Expiration time (in seconds) | The expiration time of the assertion (in seconds) within five minutes.

This property is available only when
the OAuth connection type is selected. | | Key store | The path to the keystore file in Java Keystore (JKS) format.

The keystore file can be generated by creating a certificate signed by Salesforce
and then exporting it to keystore. For more information, see [Generate a Self-Signed Certificate](https://help.salesforce.com/articleView?id=security_keys_creating.htm&type=5).

This property is available only when
the OAuth connection type is selected. | | Key store password | The keystore password.

This property is available only when
the OAuth connection type is selected. | | Certificate alias | The unique name of the certificate signed by Salesforce.

This property is available only when
the OAuth connection type is selected. | | Mutual authentication | Select this option to enable mutual authentication for establishing connections to
Salesforce. For more information about mutual authentication in Salesforce, see
[Set Up a Mutual Authentication
Certificate](https://help.salesforce.com/s/articleView?id=sf.security_keys_uploading_mutual_auth_cert.htm&type=5).

If you are using this option:



By default, this option is not selected. | | Mutual auth keystore (Deprecated) | Enter the path to the mutual authentication keystore file, a password protected
file containing keys and certificates.

This option is deprecated, it is recommended to use a [tSetKeystore](https://help.qlik.com/talend/r/en-US/8.0/components/keystore/tsetkeystore) component to provide the mutual
authentication keystore and keystore password.

This option is available when both the Basic connection
type and the Mutual authentication check box are
selected. | | Mutual auth keystore password | Enter the password for the mutual authentication keystore file.

This option is available when both the Basic connection
type and the Mutual authentication check box are
selected. | | Module Name | Click the [...] button next to the field and in the dialog
box displayed, select the module that will be used or select the Use
custom object check box and specify the module name in the
Object Name field. | | Schema and Edit schema | A schema is a row description. It defines the number of fields
(columns) to be processed and passed on to the next component. When you create a Spark
Job, avoid the reserved word line when naming the
fields.

Click Edit
schema to make changes to the schema. If the current schema is of the Repository type, three options are available:



Click Sync
columns to retrieve the schema from the previous component connected in the
Job.

This component offers the advantage of the
dynamic schema feature. This allows you to retrieve unknown columns from source
files or to copy batches of columns from a source without mapping each column
individually. For further information about dynamic schemas, see [Dynamic schema](https://help.qlik.com/talend/r/en-US/8.0/studio-user-guide/dynamic-schema).

This dynamic schema feature is designed for the purpose of
retrieving unknown columns of a module and is recommended to be used for this purpose only; it
is not recommended for the use of creating modules. | | Output Action | Select one of the following operations to be performed from the drop-down list.

| ## Advanced settings | Properties | Description | | --- | --- | | Salesforce URL | The Webservice URL required to connect to Salesforce.

Information noteWarning: Due to a [breaking change](https://help.salesforce.com/s/articleView?id=release-notes.rn_security_mutual_authentication.htm&release=246&type=5) in the latest versions of
Salesforce, if you use the Basic connection type with
mutual authentication, you need to adjust the endpoint to prevent errors while
running the Job. Example:
https://MyDomainName.my.salesforce.com:8443/services/Soap/u/version | | API version | The Salesforce API version.

This property is available only when
the OAuth connection type is selected. | | Use or save the connection session | Select this check box and in the Session directory field
displayed, specify the path to the connection session file to be saved or
used.

This session file can be shared by different Jobs to retrieve a connection session
as long as the correct user ID is provided by the component. This way, you do not
need to connect to the server to retrieve the session.

When an expired session is detected, if the correct connection information (the
user ID, password, and security key) is provided, the component will connect to
the server to retrieve the new session information and update the connection
session file.

This property is available only when the Basic connection type is selected. | | Need compression | Select this check box to activate SOAP message compression, which can result in
increased performance levels. | | Use Http Chunked | Select this check box to use the HTTP
chunked data transfer mechanism. | | Client Id | Enter the ID of the real user to differentiate between those who use the same
account and password to access the Salesforce website. | | Timeout | Enter the intended number of query timeout in milliseconds in Salesforce. | | Use Proxy | Select this check box to use a SOCKS proxy server, and in the
Host, Port, User
Id, and Password fields displayed, specify
the connection parameters of the SOCKS proxy server.

Information noteNote: To use a proxy of any allowed type (including HTTP proxy, HTTPS proxy, and
SOCKS proxy), use the tSetProxy component. | | Relationship mapping for upsert | Click the
[+] button to add lines as needed and specify the
external ID fields in the input flow, the lookup relationship fields in the upsert
module, the lookup module as well as the external ID fields in the lookup
module.



This property is
available only when UPSERT is selected from the
Output Action drop-down list. | | Extend Insert | This check box is selected by default and allows you to transfer the output
data in batches. In the Commit Level field
displayed, specify the number of lines per batch. | | Die on Error | This check box is selected by default. Clear the check box to skip the row
on error and complete the process for error-free rows. If needed, you can retrieve
the rows on error via a Row > Rejects link. | | Retrieve Id | Select this check box to allow Salesforce to return the Salesforce ID for
the inserted or updated records.

This check box is available
only when INSERT or UPSERT is
selected from the Output Action
drop-down list and the Extend Insert
check box is cleared.

When this check box is selected and the
tSalesforceOutput component is linked to another
component via a Row > Main connection, the following column(s) will be added to the schema
of the data flow:

| | Ignore Null | Select this check box to ignore NULL values.

This
property is available only when UPDATE or
UPSERT is selected from the Output Action drop-down list. | | Log File Name | Specify the path to the log file that holds all error logs. | | Use UTC time for datetime | Select this option to use the UTC time for datetime type data. If this
option is cleared, the local time is used. | | tStatCatcher Statistics | Select this checkbox to gather the Job processing metadata at the Job level
as well as at each component level. | ## Global Variables | Variables | Description | | --- | --- | | NB\_LINE | The number of rows processed. This is an After variable and
it returns an integer. | | NB\_SUCCESS | The number of rows successfully processed. This is an After
variable and it returns an integer. | | NB\_REJECT | The number of rows rejected. This is an After variable and
it returns an integer. | | ERROR\_MESSAGE | The error message generated by the component when an error
occurs. This is an After variable and it returns a string. | ## Usage | Usage guidance | Description | | --- | --- | | **Usage rule** | This component can be used as an end
component or an intermediate component of a Job or subJob and it always needs an input
link. | | Limitation | If you change the component schema or any of the following parameters — Output Action, Extend Insert, or Retrieve Id — click Guess Schema on Schema MAIN and Reject Schema to refresh the output schemas accordingly.

Information noteNote: This behavior will be improved in a future release to support automatic schema updates. | **Related concepts** * [Upserting Salesforce data based on external IDs](https://help.qlik.com/talend/en-US/components/8.0/salesforce/tsalesforceinput-tsalesforceconnection-tlogrow-upserting-salesforce-data-based-on-external-ids-standard-component-the-job "Here is an example of using Talend components to insert and update Salesforce Contact object data based on the mapping relationship with external IDs of the Account object.")