tWriteXMLField – Docs for ESB 5.x
tWriteXMLField tWriteXMLField properties Component family XML Function tWriteXMLField outputs data to defined fields of the output XML file. Purpose tWriteXMLField reads an input XML file and extracts the structure to insert it in defined fields of the output file. Basic settings Output Column Select the destination field in the output component where you want…
tWaitForSqlData – Docs for ESB 5.x
tWaitForSqlData tWaitForSqlData properties Component family Orchestration Function tWaitForSqlData component iterates on a given connection for insertion or deletion of rows and triggers a subjob to be executed when the condition is met. Purpose This component allows a subjob to be triggered given a condition linked to SQL data presence. Basic settings Wait at each…
tVerticaOutputBulk – Docs for ESB 5.x
tVerticaOutputBulk tVerticaOutputBulk Properties The tVerticaOutputBulk and tVerticaBulkExec components are generally used together as parts of a two step process. In the first step, an output file is generated. In the second step, this file is used in the INSERT operation used to feed a database. These two steps are fused together in the tVerticaOutputBulkExec component,…
tWaitForSocket – Docs for ESB 5.x
tWaitForSocket tWaitForSocket properties Component Family Orchestration Function tWaitForSocket component makes a loop on a defined port, to look for data, and triggers a subjob when the condition is met. Purpose This component triggers a Job based on a defined condition. Basic settings Port DB server listening port. End of line separator Enter the…
tWaitForFile – Docs for ESB 5.x
tWaitForFile tWaitForFile properties Component family Orchestration Function tWaitForFile iterates on the specified directory and triggers the next component when the defined condition is met. Purpose This component is used to put the component connected with it in waiting state. It then triggers that component when the defined file operation occurs in the specified directory….
tVerticaRow – Docs for ESB 5.x
tVerticaRow tVerticaRow Properties Component family Databases/Vertica Function tVerticaRow is the specific component for this database query. It executes the SQL query stated onto the specified database. The row suffix means the component implements a flow in the job design although it does not provide output. Purpose Depending on the nature of the query and…
tVtigerCRMOutput – Docs for ESB 5.x
tVtigerCRMOutput tVtigerCRMOutput Properties Component family Business/VtigerCRM Function Writes data into a module of a VtigerCRM database. Purpose Allows to write data from a VtigerCRM DB. Basic settings Vtiger Version Select the version of the Vtiger Web Services you want to use (either Vtiger 5.0 or Vtiger 5.1) Vtiger 5.0 Server Address Type…
tVerticaConnection – Docs for ESB 5.x
tVerticaConnection tVerticaConnection Properties Component family Databases/Vertica Function tVerticaConnection opens a connection to the database for a current transaction. Purpose This component is used to open a connection to the specified database that can then be reused in the subsequent subjob or subjobs. Basic settings Property type Either Built-in or Repository. Since version 5.6, both…
tXSLT – Docs for ESB 5.x
tXSLT tXSLT Properties Component family XML Function Refers to an XSL stylesheet, to transform an XML source file into a defined output file. Purpose Helps to transform data structure to another structure. Basic settings XML file File path to the XML file to be validated. XSL file File path to the reference XSL…
tWebService – Docs for ESB 5.x
tWebService Warning This component requires an Oracle JDK to be functional. tWebService properties Component family Internet Function tWebservice calls the defined method from the invoked Web service and returns the class as defined, based on the given parameters. Purpose This component calls a method via a Web service in order to retrieve the values…