Scenario: Adding a lead record to a list in the Marketo DB - 6.1

Talend Open Studio for Big Data Components Reference Guide

EnrichVersion
6.1
EnrichProdName
Talend Open Studio for Big Data
task
Data Governance
Data Quality and Preparation
Design and Development
EnrichPlatform
Talend Studio

The following scenario describes a three-component Job that adds a lead record into a list in the Marketo database.

Setting up the Job

  1. Drop tMarketoListOperation, tFixedFlowInput and tLogRow onto the design workspace.

  2. Connect tFixedFlowInput to tMarketoListOperation using a Row > Main connection. In the pop-up dialog box, click Yes to get the schema from the target component.

  3. Connect tMarketoListOperation to tLogRow using a Row > Main connection.

Configuring the input component

  1. Double-click tFixedFlowInput to define the component properties in its Basic settings view.

  2. Click the [...] button next to Edit schema to view its schema.

  3. In the Mode area, select Use Inline Table.

  4. Click the plus button to add a new line and fill the line with respective values. In this example, these values are: MKTOLISTNAME for ListKeyType, bchenTestList for ListKeyValue, IDNUM for LeadKeyType and 308408 for LeadKeyValue.

Configuring tMarketoListOperation

  1. Double-click tMarketoListOperation to define the component properties in its Basic settings view.

  2. Click the Sync columns button to retrieve the schema defined in tFixedFlowInput.

  3. Type in 1 in the Number of rows field.

  4. Fill the Endpoint address field with the URL of the Marketo Web server. In this example, it is https://na-c.marketo.com/soap/mktows/1_5.

    Note that the URL used in this scenario is for demonstration purposes only.

  5. Fill the Secret key field with encrypted authentication code assigned by Marketo. In this example, it is 464407637703554044DD11AA2211998.

  6. Fill the Client Access ID field with the user ID. In this example, it is mktodemo41_785133934D1A219.

  7. From the Operation list, select addTo.

  8. Type in the limit of query timeout in the Timeout field. In this example, use the default number: 60000.

Job Execution

  1. Double-click tLogRow to define the component properties in its Basic settings view.

  2. Click the Sync columns button to retrieve the schema defined in tMarketoListOperation.

  3. In the Mode area, select Table.

  4. Save your Job and press F6 to execute it.

The result of adding a lead record to a list in Marketo DB is displayed on the Run console.