In the Input tab of Parse Data activity, give the path of CSV file which should be read. Configuration tab of Parse Data activity will look like below screenshot: As we are going to read from a CSV file, we specify File as input type. In configuration tab of Parse Data activity, browse for the Data Format that we created in Step 1 and use that.
HOW TO SELECT PARSE RESUME ON MAC HOW TO
You can read in my other tutorial how to handle exceptions in TIBCO BW processes. I have kept the process very simple and haven’t even added Exception handling. JDBC Update activity to insert the CSV file data into a database table.
Parse Data activity to parse the CSV file contents.To read the CSV file, I have created a BW process in TIBCO with following activities: Step 2: Create BW Process to read CSV File: We don’t need to make any changes to Field Offsets tab. So we create elements for all of them in our Data Format tab as shown below: As you can see in the snapshot of our Employee.csv file, we have Employee Code, Employee Name, Employee Designation and Employee age in comma separated form in our input file. In the Data Format tab, we specify what will be the data format that will be parsed using this activity. Complete configuration will look like below: In configuration tab of Data Format, choose Delimiter Separated as format type, comma in col separator and carriage return/line feed in line separator. Our source file that we will be reading is Employee.csv with comma separated records as shown below:įor reading this CSV file in our TIBCO BW process, we first create a Data Format by going through Add Resource àParse àData Format
0 kommentar(er)
