etltalend
Send an email according to a query result after each insert in the table - Talend
I'm building a job on Talend Open Studio that allows me to charge Data from SQL Server table into different tables. Then I want to execute some queries on the new charged tables and send e-mail according to the query result after each insert in those tables.
Is it possible to do that with Talend Open Studio and if so, Can you guide me through this?
Solution
You can achieve this by using tDBInput -> tFlowToIterate -> tSendMail components. tDBInput will read the data from your DB table, and for every row it will send an email. You can grab the data fetched from tDBInput in tSendMail by using (String) globalMap.get("row1.FieldNeeded")
Hope this helps.
- SSIS - the value cannot be converted because of a potential loss of data
- Seeking Advice on Efficient Data Unpivoting in SQL Server with SSIS or Alternative Tools
- How to transfer "Set Variable" activity output into Json file using "Copy Data" activity or any other options?
- How do I pull the last modified file with data flow in azure data factory?
- What is the difference between AWS Glue ETL Job and AWS EMR?
- Pyspark stream kafka debezium topic Error format, ETL
- Why is my SSIS toolbox empty in Visual Studio 2019 community?
- Errors with df.display() and df.show() in Databricks
- Error while trying to migrate data from one table to another in BigQuery
- How to find unique values from set of rows using pentaho kettle?
- Differences and Use Cases for Apache NiFi, Apache Airflow, and Apache Falcon?
- Unable to use both SQL Server and Postgres connection together on the same job - Talend
- SSIS How to get part of a string by separator
- JOLT shift transformation to filter values in array
- Pick the latest file based on datestamp provided in the filename
- Pass parameters from SQL Server Agent job to SSIS Package on Step "set value"
- How can I connect python to a database using sqlalchemy?
- Access to previous row in Kettle
- Using Multiple Linked Services in a Data Flow, Azure Data Factory
- Talend : How to fix the code of method is exceeding the 65535 byte limit
- How to use minimum number of web activities to send notifications in a ADF pipeline?
- Airflow: Failing to push data back into the pipeline
- How to ETL my PostgreSQL data into a ClickHouse datawarehouse?
- How can I overcome AWS Glue's extreme memory limitations?
- BCP Inputting Incorrect Integer Data
- Move on statically allocated containers benefit
- Azure data factory data flow test connection Spark job failes
- Azure data factory edit data flow button does not work?
- Can a Superset dataset use multiple data sources?
- Creating a data model from scratch: Adding a Foreign Key in PostgreSQL