-
Double-click the tFileInputDelimited
component to open its Basic settings
view.
-
In the File name/Stream field, browse to or
enter the path to the source file. In this example, it is D:/SalesforceAccount.txt.
In the Header field, type in 1 to skip the header row in the beginning of the
file.
-
Click the [...] button next to Edit schema and in the pop-up schema dialog box,
define the schema by adding four columns Name,
ParentId, Phone and
Fax of String type.
Click OK to save the changes and close the
dialog box.
-
Double-click the tSalesforceOutput component
to open its Basic settings view.
-
In the User Id, Password and Security Key
fields, enter the user authentication information required to access
Salesforce.
-
Click the [...] button next to the Module Name field and in the pop-up dialog box,
select the object you want to access. In this example, it is Account.
Click OK to save the settings and close the
dialog box.
-
Click Sync columns to retrieve the schema
from the preceding component and accept the propagation prompted by the pop-up
dialog box.
-
Double-click the first tLogRow component to
open its Basic settings view.
In the Mode area, select Table (print values in cells of a table) for better
readability of the result.
-
Do the same to configure the second tLogRow
component.
Click OK to save the changes and close the dialog box.
Click OK to save the settings and close the dialog box.
In the Mode area, select Table (print values in cells of a table) for better readability of the result.