tSQLTemplateFilterColumns – Docs for ESB 7.x
tSQLTemplateFilterColumns Homogenizes schemas by reorganizing, deleting or adding new columns. tSQLTemplateFilterColumns makes specified changes to the defined schema of the database table based on column name mapping. This component has real-time capabilities since it runs the data filtering on the DBMS itself. tSQLTemplateFilterColumns Standard properties These properties are used to configure tSQLTemplateFilterColumns running in the…
tMapROjaiInput – Docs for ESB 7.x
tMapROjaiInput Reads documents from a MapR-DB database to load the data in a given Job. You must have properly installed and configured your MapR Client before using this component. A optmaprconfmapr-clusters.conf file is automatically generated out of the Client configuration process to store the connection information to your MapR cluster and your MapR-DB database. At…
tMarkLogicInput – Docs for ESB 7.x
tMarkLogicInput Searches document content in a MarkLogic database based on a string query. tMarkLogicInput passes on the document URI and content to the next component via a Row > Main connection. tMarkLogicInput Standard properties These properties are used to configure tMarkLogicInput running in the Standard Job framework. The Standard tMarkLogicInput component belongs to the Big…
tTeradataTPTExec – Docs for ESB 7.x
tTeradataTPTExec Offers high performance in inserting data from an existing file to a table in a Teradata database. As the combination of tTeradataFastLoad, tTeradataMultiLoad, tTeradataTPump, and tTeradataFastExport, tTeradataTPTExec loads the data from an existing file to a Teradata database. tTeradataTPTExec Standard properties These properties are used to configure tTeradataTPTExec running in the Standard Job framework….
tReservoirSampling – Docs for ESB 7.x
tReservoirSampling Extracts a random sample data from a big data set. tReservoirSampling extracts a sample from the input data set in such a way that profiling results on the sample data are uniform and homogeneous with the profiling results on the full data set. In local mode, Apache Spark 2.0.0, 2.3.0 and 2.4.0 are supported….
Configuring the tokenization – Docs for ESB 7.x
Configuring the tokenization Double-click tJapaneseTokenize to open its Basic settings view in the Component tab. Click Sync columns to retrieve the schema from the preceding component. In the Tokenization table, select the corresponding check box in the Tokenize column for each of the schema columns containing Japanese text to be tokenized. Parent topic: Tokenizing Japanese…
Creating the SAP HANA database connection – Docs for ESB 7.x
Creating the SAP HANA database connection Specify your SAP HANA database in Talend Studio. Select Metadata > DB Connections. Right-click and select Create connection. Fill in the Name, Purpose, and Description fields. Click Next. Select SAPHana from the DB Type dropdown list. Provide the following information: Login Password Server Port Schema Additional Parameters Note: Once…
tAmazonAuroraConnection – Docs for ESB 7.x
tAmazonAuroraConnection Opens a connection to an Amazon Aurora database instance that can then be reused by other Amazon Aurora components. tAmazonAuroraConnection Standard properties These properties are used to configure tAmazonAuroraConnection running in the Standard Job framework. The Standard tAmazonAuroraConnection component belongs to the Cloud and the Databases families. The component in this framework is available…
tIntervalMatch – Docs for ESB 7.x
tIntervalMatch Returns a value based on a Join relation. tIntervalMatch receives a main flow and aggregates it based on join to a lookup flow. Then it matches a specified value to a range of values and returns related information. tIntervalMatch Standard properties These properties are used to configure tIntervalMatch running in the Standard Job framework….
tTeradataClose – Docs for ESB 7.x
tTeradataClose Closes the transaction committed in the connected DB. tTeradataClose Standard properties These properties are used to configure tTeradataClose running in the Standard Job framework. The Standard tTeradataClose component belongs to the Databases family. The component in this framework is available in all Talend products. Note: This component is a specific version of a dynamic…