Configuring the first subjob – Docs for ESB 6.x
Configuring the first subjob Double click tFileFetch_1 to open its component view. Select the protocol you want to use from the Protocol list. Here, we use the https protocol. In the URI field, type in the URI through which you can log in the website and fetch the web page accordingly. In this example, the…
Configuring the input and output components – Docs for ESB 6.x
Configuring the input and output components Double-click the tFileInputDelimited component, which is labeled Source, to display its Basic settings view where you can define the component properties. Warning: The dynamic schema feature is only supported in Built-In mode and requires the input file to have a header row. In the File name/Stream field, type in…
Configuring the input component – Docs for ESB 6.x
Configuring the input component Double-click tNamedPipeOpen to define its propeties in its Basic settings view. Fill in the Name field with the name of a named-pipe and select Delete if already exist to avoid duplicate named-pipe. Double-click tParallelize to define its properties in its Basic settings view. Select end of all subjobs from the Wait…
Configuring the input components – Docs for ESB 6.x
Configuring the input components Double-click PreferredSubject to open its Basic settings view. In the Default Table Name field, enter an input table name. In this example, it is PreferredSubject. Click the […] button next to Edit schema to define the schema of the input table PreferredSubject in the schema editor. Click the [+] button to…
Configuring the input data – Docs for ESB 6.x
Configuring the input data In the design workspace, select tFixedFlowInput. Click the Component tab to define the basic settings for tFixedFlowInput. Click the three-dot […] button next to Edit Schema to describe the data structure you want to create from internal variables. In this scenario, the schema is made of three columns, now of type…
Configuring the input flow – Docs for ESB 6.x
Configuring the input flow Double-click the tFileInputXML component labelled Customers to open its Basic settings view. Click the […] button next to Edit schema and in the [Schema] dialog box define the schema by adding one column Customer of Document type. Note that the Document data type is essential for making full use of tXMLMap….
Configuring the output component – Docs for ESB 6.x
Configuring the output component Double-click tJasperOutput to display its Basic settings view. Enter the full path of the report template file created via Jaspersoft’s iReport in the Jrxml file field. You can click the three-dot button to browse. Note: The schema of the file, which is used to create a .jrxml template file via iReport,…
Configuring the output flow – Docs for ESB 6.x
Configuring the output flow To extract the data of interest, you need to configure the output flow. The operations to be performed are as follows: Double-click tExtractXMLField to open its Basic settings view. Click Edit schema to open the schema editor. In the Output schema to the right of the editor, add and define the…
Configuring the output components – Docs for ESB 6.x
Configuring the output components Double-click the first tLogRow to open its Basic settings view on the Component tab. Click the Sync columns button to retrieve the schema from the preceding component. In the Mode area, select Table (print values in cells of a table) for a better display of the result. Do the same to…
Configuring the output component and executing the Job – Docs for ESB 6.x
Configuring the output component and executing the Job Double-click the tFileOutputExcel component to display the Basic settings view and define the component properties. Set the destination file name as well as the sheet name and then select the Define all columns auto size check box. Save your Job and press F6 to execute it. The…