tSAPODPInput – Docs for ESB 7.x
tSAPODPInput Extracts business data from the ERP part of SAP (SAP Business application, SAP on HANA, SAP R/3, and S4/HANA) through ODP (Operational Data Provisioning). For more information about SAP ODP, see Operational Data Provisioning (ODP) and Delta Queue (ODQ). tSAPODPInput Standard properties These properties are used to configure tSAPODPInput running in the Standard Job…
tMongoDBConfiguration – Docs for ESB 7.x
tMongoDBConfiguration Stores connection information and credentials to be reused by other MongoDB components. You configure the connection to a MongoDB database in tMongoDBConfiguration and configure the other MongoDB components to reuse this configuration. At runtime, the Spark executors read this configuration in order to connect to MongoDB. Depending on the Talend product you are using,…
tStandardizePhoneNumber – Docs for ESB 7.x
tStandardizePhoneNumber Standardizes phone numbers according to given formats. tStandardizePhoneNumber receives phone number data from its preceding component and formats and standardizes these numbers using a built-in Google libphonumber library, org.talend.libraries.google.libphonumber. Depending on the Talend product you are using, this component can be used in one, some or all of the following Job frameworks: Standard: see…
tMySQLValidRows – Docs for ESB 7.x
tMySQLValidRows Checks MySQL database rows against Data Quality patterns (regular expression). tMySQLValidRows allows you to extract DB rows that match a given Data Quality pattern. tMySQLValidRows Standard properties These properties are used to configure tMySQLValidRows running in the Standard Job framework. The Standard tMySQLValidRows component belongs to the Data Quality and the Databases families. This…
tServerAlive – Docs for ESB 7.x
tServerAlive Validates the status of the connection to a specified host. tServerAlive checkes whether the connection to a specified host is up or down, which is indicated by the boolean value returned by the global variable SERVER_ALIVE_RESULT. tServerAlive Standard properties These properties are used to configure tServerAlive running in the Standard Job framework. The Standard…
tELTTeradataOutput – Docs for ESB 7.x
tELTTeradataOutput Performs the action (insert, update or delete) on data in the specified Teradata table through the SQL statement generated by the tELTTeradataMap component. The three ELT Teradata components are closely related, in terms of their operating conditions. These components should be used to handle Teradata database table schemas to generate SQL statements, including clauses,…
tJavaDBInput – Docs for ESB 7.x
tJavaDBInput Reads a database and extracts fields based on a query tJavaDBInput 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. tJavaDBInput Standard properties These properties are used to configure tJavaDBInput running…
tFileOutputXML – Docs for ESB 7.x
tFileOutputXML Writes an XML file with separated data values according to a defined schema. Depending on the Talend product you are using, this component can be used in one, some or all of the following Job frameworks: Standard: see tFileOutputXML Standard properties. The component in this framework is available in all Talend products. MapReduce: see…
tSAPBWInput – Docs for ESB 7.x
tSAPBWInput Executes an SQL query with a strictly defined order which must correspond to your schema definition. tSAPBWInput reads data from an SAP BW database using a JDBC API connection and extracts fields based on an SQL query. Then it passes on the field list to the next component via a Row > Main connection….
tMSSqlTableList – Docs for ESB 7.x
tMSSqlTableList Lists the names of a given set of MSSql tables using a select statement based on a Where clause. tMSSqlTableList Standard properties These properties are used to configure tMSSqlTableList running in the Standard Job framework. The Standard tMSSqlTableList component belongs to the Databases family. The component in this framework is available in all Talend…