tELTTeradataInput – Docs for ESB 5.x
tELTTeradataInput tELTTeradataInput properties The three ELT Teradata components are closely related, in terms of their operating conditions. These components should be used to handle Teradata DB schemas to generate Insert statements, including clauses, which are to be executed in the DB output table defined. Component family ELT/Map/Teradata Function Provides the table schema to be…
tELTMSSqlInput – Docs for ESB 5.x
tELTMSSqlInput tELTMSSqlInput properties The three ELT MSSql components are closely related, in terms of their operating conditions. These components should be used to handle MSSql DB schemas to generate Insert statements, including clauses, which are to be executed in the DB output table defined. Component family ELT/Map/MSSql Function Provides the table schema to be…
tCombinedSQLAggregate – Docs for ESB 5.x
tCombinedSQLAggregate tCombinedSQLAggregate properties Component family ELT/CombinedSQL Function tCombinedSQLAggregate collects data values from one or more columns of a table for statistical purposes. This component has real-time capabilities since it runs the data transformation on the DBMS itself. Purpose Helps to provide a set of matrix based on values or calculations. Basic settings Schema and…
tCombinedSQLFilter – Docs for ESB 5.x
tCombinedSQLFilter tCombinedSQLFilter Properties Component family ELT/CombinedSQL Function tCombinedSQLFilter allows you to alter the schema of a source table through column name mapping and to define a row filter on that table. Therefore, it can be used to filter columns and rows at the same time. This component has real-time capabilities since it runs the…
tCombinedSQLInput – Docs for ESB 5.x
tCombinedSQLInput tCombinedSQLInput properties Component family ELT/CombinedSQL Function tCombinedSQLInput extracts fields from a database table based on its schema. This component also has column filtering capabilities since its schema can be different from that of the database table. Purpose tCombinedSQLInput extracts fields from a database table based on its schema definition. Then it passes on…
tELTMysqlMap – Docs for ESB 5.x
tELTMysqlMap tELTMysqlMap properties The three ELT Mysql components are closely related, in terms of their operating conditions. These components should be used to handle Mysql DB schemas to generate Insert statements, including clauses, which are to be executed in the DB output table defined. Component family ELT/Map/Mysql Function Helps to graphically build the SQL…
tELTMysqlOutput – Docs for ESB 5.x
tELTMysqlOutput tELTMysqlOutput properties The three ELT Mysql components are closely related, in terms of their operating conditions. These components should be used to handle Mysql DB schemas to generate Insert statements, including clauses, which are to be executed in the DB output table defined. Component family ELT/Map/Mysql Function Carries out the action on the…
tELTMSSqlMap – Docs for ESB 5.x
tELTMSSqlMap tELTMSSqlMap properties The three ELT MSSql components are closely related, in terms of their operating conditions. These components should be used to handle MSSql DB schemas to generate Insert statements, including clauses, which are to be executed in the DB output table defined. Component family ELT/Map/MSSql Function Helps you to build the SQL…
tELTMSSqlOutput – Docs for ESB 5.x
tELTMSSqlOutput tELTMSSqlOutput properties The three ELT MSSql components are closely related, in terms of their operating conditions. These components should be used to handle MSSql DB schemas to generate Insert statements, including clauses, which are to be executed in the DB output table defined. Component family ELT/Map/MSSql Function Carries out the action on the…
tELTMysqlInput – Docs for ESB 5.x
tELTMysqlInput tELTMysqlInput properties The three ELT Mysql components are closely related, in terms of their operating conditions. These components should be used to handle Mysql DB schemas to generate Insert statements, including clauses, which are to be executed in the DB output table defined. Component family ELT/Map/Mysql Function Provides the table schema to be…