Configuring tFileInputDelimited - 7.3
Microsoft CRM
- EnrichVersion
- Cloud
- 7.3
- EnrichProdName
- 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 ESB
- Talend Real-Time Big Data Platform
- EnrichPlatform
- Talend Studio
- task
- Data Governance > Third-party systems > Business applications > Microsoft CRM components
- Data Quality and Preparation > Third-party systems > Business applications > Microsoft CRM components
- Design and Development > Third-party systems > Business applications > Microsoft CRM components
Procedure
-
Double-click tFileInputDelimited to display
its Basic settings view and define its
properties.
-
Set the Property Type to Repository if you have stored the input file
properties centrally in the Metadata node in
the Repository tree view. Otherwise, select
Built-In and fill the fields that follow
manually. In this example, property is set to Built-In.
-
Click the three-dot button next to the File name/Stream
field and browse to the delimited file that holds the input data. The input file
in this example contains the following columns: new_id,
new_status, new_firstname,
new_email, new_city,
new_initial and
new_zipcode.
-
In the Basic settings view, define the
Row Separator allowing to identify the end
of a row. Then define the Field Separator used
to delimit fields in a row.
-
If needed, define the header, footer and limit number of processed rows in the
corresponding fields. In this example, the header, footer and limits are not
set.
-
Click Edit schema to open a dialog box where
you can define the input schema you want to write in Microsoft CRM
database.
-
Click OK to close the dialog box.