tAmazonMysqlCommit – Docs for ESB 5.x
tAmazonMysqlCommit tAmazonMysqlCommit Properties Component family Cloud/AmazonRDS/MySQL Function Validates the data processed through the job into the connected DB Purpose Using a unique connection, this component commits in one go a global transaction instead of doing that on every row or every batch and thus provides gain in performance. Note that if you need to…
tAmazonOracleInput – Docs for ESB 5.x
tAmazonOracleInput tAmazonOracleInput properties Component family Cloud/AmazonRDS/Oracle Function tAmazonOracleInput reads a database and extracts fields based on a query. Purpose tAmazonOracleInput executes a DB query with a strictly defined order which must correspond to the schema definition. Then it passes on the field list to the next component via a Main row link. Basic settings…
tAmazonOracleOutput – Docs for ESB 5.x
tAmazonOracleOutput tAmazonOracleOutput properties Component family Cloud/AmazonRDS/Oracle Function tAmazonOracleOutput writes, updates, makes changes or suppresses entries in a database. Purpose tAmazonOracleOutput executes the action defined on the table and/or on the data contained in the table, based on the flow incoming from the preceding component in the Job. Basic settings Property type Either Built-in or…
tAmazonOracleRollback – Docs for ESB 5.x
tAmazonOracleRollback tAmazonOracleRollback properties Component family Cloud/AmazonRDS/Oracle Function Cancel the transaction commit in the connected DB. Purpose Avoids to commit part of a transaction involuntarily. Basic settings Component list Select the tAmazonOracleConnection component in the list if more than one connection are planned for the current job. Close Connection Clear this check box to…
tAmazonOracleRow – Docs for ESB 5.x
tAmazonOracleRow tAmazonOracleRow properties Component family Cloud/AmazonRDS/Oracle Function tAmazonOracleRow 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 doesn’t provide output. Purpose Depending on the nature of the query and the…
tApacheLogInput – Docs for ESB 5.x
tApacheLogInput tApacheLogInput properties Component family File/Input Function tApacheLogInput reads the access-log file for an Apache HTTP server. Purpose tApachLogInput helps to effectively manage the Apache HTTP Server,. It is necessary to get feedback about the activity and performance of the server as well as any problems that may be occurring. Basic settings Property type…
tAmazonMysqlRow – Docs for ESB 5.x
tAmazonMysqlRow tAmazonMysqlRow properties Component family Cloud/Amazon/MySQL Function tAmazonMysqlRow is the specific component for this database query. It executes the SQL query stated in the specified database. The row suffix means the component implements a flow in the job design although it doesn’t provide output. Purpose Depending on the nature of the query and the…
tAmazonOracleClose – Docs for ESB 5.x
tAmazonOracleClose tAmazonOracleClose properties Component family Cloud/AmazonRDS/Oracle Function tAmazonOracleClose closes the transaction committed in the connected DB. Purpose Close a transaction. Basic settings Component list Select the tAmazonOracleConnection component in the list if more than one connection are planned for the current Job. Advanced settings tStatCatcher Statistics Select this check box to collect log data…
tAmazonOracleCommit – Docs for ESB 5.x
tAmazonOracleCommit tAmazonOracleCommit Properties Component family Cloud/AmazonRDS/Oracle Function Validates the data processed through the job into the connected DB Purpose Using a unique connection, this component commits in one go a global transaction instead of doing that on every row or every batch and thus provides gain in performance. Note that if you need to…
tAmazonOracleConnection – Docs for ESB 5.x
tAmazonOracleConnection tAmazonOracleConnection Properties Component family Cloud/AmazonRDS/Oracle Function 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 the…