Latest Ambience 2020+ ETL Cookbook topics

Topic	Views	Activity
Welcome to the Ambience/Repertoire 2020+ ETL Cookbook! repertoire-202x This is the Ambience/Repertoire ETL Cookbook! The purpose of this forum is to publicize quick demos and snippets of code to enable you to do common and specialized tasks using Ambience/Repertoire 202x’s ETL module. Thi…	588	July 26, 2021
Sample ETL Chainset to Insert Dynamic Excel Formulas into Rendered XLSX cells cookbook	20	August 24, 2026
Updating Embedded Charts in DocX templates repertoire-202x	17	July 6, 2026
ETL Workflow to Calculate Future Date Based on Number of Days, Excluding Weekends & Public Holidays ambience-202x , etl , cookbook	59	June 16, 2026
Sample ETL Chainset to Render rml Template to AWS S3 Bucket repertoire-202x , cookbook	47	May 26, 2025
How to run a Bash Script and Schedule it as a job in Ambience 202x	544	November 1, 2022
Sample ETL Chainset for Batch Report Generation ambience-202x , repertoire-202x , cookbook	113	May 27, 2025
Generating Activity Logs ambience-202x	51	May 7, 2025
Send an Email notification including the error information in ETL Chainset repertoire-202x , ambience-202x	75	August 29, 2024
Send Notification using Chain If Else step in ETL	271	January 30, 2024
[ETL]: Extract Audit Logs ambience-202x	67	August 8, 2024
ETL Steps to Read Configuration Details cookbook , repertoire-202x	184	March 25, 2024
ETL Chain to Send Email alert based on script output	257	March 6, 2024
Configuring SFTP connectivity for ETL on Ambience/Repertoire Servers ambience-202x , repertoire-202x , cookbook	215	February 6, 2024
ETL to Write Data to a File with Timestamp in file name repertoire-202x , cookbook	257	February 5, 2024
ETL to Write Data to a File with Timestamp and Parameterized file name repertoire-202x , cookbook	218	February 5, 2024
Define Fields / Columns Name and Exclude Column in XLSX using ETL repertoire-202x , ambience-202x	194	January 16, 2024
Render RML Template using ETL cookbook , repertoire-202x	198	January 12, 2024
Render RML Template with Parameter using ETL repertoire-202x	232	January 12, 2024
Importing Bulk Users from an external file cookbook , repertoire-202x	268	October 26, 2023
Run SQL Update through an ETL Chain cookbook , repertoire-202x	235	October 25, 2023
Update database table using JDBC Updater ambience-202x , cookbook , repertoire-202x	219	October 18, 2023
Create an ETL Chain to read an XLSX File cookbook , repertoire-202x	298	October 13, 2023
Run Job Files using the ETL Module ambience-202x , repertoire-202x	419	August 10, 2023
Merging two PDF files using the ETL Module repertoire-202x , cookbook	471	August 11, 2023
ETL Log Reading	411	December 14, 2022
Beginner Recipe: Using Array Paginate cookbook , beginner	645	September 29, 2021
Intermediate Recipe: Using a Function Mechanism	523	March 9, 2022
Beginner Recipe: Preparing an XLSX Download endpoint , cookbook , beginner	532	February 15, 2022
Intermediate Recipe: Using the Atomic Integer ETL Step	720	September 7, 2021

Welcome to the Ambience/Repertoire 2020+ ETL Cookbook!

repertoire-202x

This is the Ambience/Repertoire ETL Cookbook! The purpose of this forum is to publicize quick demos and snippets of code to enable you to do common and specialized tasks using Ambience/Repertoire 202x’s ETL module. Thi…

0

588

July 26, 2021

Sample ETL Chainset to Insert Dynamic Excel Formulas into Rendered XLSX cells

cookbook

0

20

August 24, 2026

Updating Embedded Charts in DocX templates

repertoire-202x

0

17

July 6, 2026

ETL Workflow to Calculate Future Date Based on Number of Days, Excluding Weekends & Public Holidays

ambience-202x , etl , cookbook

0

59

June 16, 2026

Sample ETL Chainset to Render rml Template to AWS S3 Bucket

repertoire-202x , cookbook

0

47

May 26, 2025

How to run a Bash Script and Schedule it as a job in Ambience 202x

0

544

November 1, 2022

Sample ETL Chainset for Batch Report Generation

ambience-202x , repertoire-202x , cookbook

0

113

May 27, 2025

Generating Activity Logs

ambience-202x

0

51

May 7, 2025

Send an Email notification including the error information in ETL Chainset

repertoire-202x , ambience-202x

0

75

August 29, 2024

Send Notification using Chain If Else step in ETL

0

271

January 30, 2024

[ETL]: Extract Audit Logs

ambience-202x

0

67

August 8, 2024

ETL Steps to Read Configuration Details

cookbook , repertoire-202x

0

184

March 25, 2024

ETL Chain to Send Email alert based on script output

0

257

March 6, 2024

Configuring SFTP connectivity for ETL on Ambience/Repertoire Servers

ambience-202x , repertoire-202x , cookbook

0

215

February 6, 2024

ETL to Write Data to a File with Timestamp in file name

repertoire-202x , cookbook

0

257

February 5, 2024

ETL to Write Data to a File with Timestamp and Parameterized file name

repertoire-202x , cookbook

0

218

February 5, 2024

Define Fields / Columns Name and Exclude Column in XLSX using ETL

repertoire-202x , ambience-202x

0

194

January 16, 2024

Render RML Template using ETL

cookbook , repertoire-202x

0

198

January 12, 2024

Render RML Template with Parameter using ETL

repertoire-202x

0

232

January 12, 2024

Importing Bulk Users from an external file

cookbook , repertoire-202x

0

268

October 26, 2023

Run SQL Update through an ETL Chain

cookbook , repertoire-202x

0

235

October 25, 2023

Update database table using JDBC Updater

ambience-202x , cookbook , repertoire-202x

0

219

October 18, 2023

Create an ETL Chain to read an XLSX File

cookbook , repertoire-202x

0

298

October 13, 2023

Run Job Files using the ETL Module

ambience-202x , repertoire-202x

0

419

August 10, 2023

Merging two PDF files using the ETL Module

repertoire-202x , cookbook

0

471

August 11, 2023

ETL Log Reading

0

411

December 14, 2022

Beginner Recipe: Using Array Paginate

cookbook , beginner

0

645

September 29, 2021

Intermediate Recipe: Using a Function Mechanism

0

523

March 9, 2022

Beginner Recipe: Preparing an XLSX Download

endpoint , cookbook , beginner

0

532

February 15, 2022

Intermediate Recipe: Using the Atomic Integer ETL Step

0

720

September 7, 2021