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

Talend Components Reference Guide

Version
6.1
Language
English (United States)
Product
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Open Studio for Big Data
Talend Open Studio for Data Integration
Talend Open Studio for Data Quality
Talend Open Studio for ESB
Talend Open Studio for MDM
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Data Governance
Data Quality and Preparation
Design and Development

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.