Is SMTP server etc. of EmailSender dynamically configurable on CloverETL server? How?

jzhu

• September 01, 2016 00:00

• Answered

Follow

I use EmailSender in JobFlow for Email notification of some particular errors/issues/scenarios. I need its parameters such as SMTP server to be configurable on the CLoverETL server -- when the JobFlow is triggered through event listener / scheduling, or just use the email configured in CloverETL server setup. It is because the production and non-production server use different SMTP server.
Is this possible? And how?

I found the SMTP server parameter seems to take strings only, and does not seem to be able to take any values from the JobFlow parameters or dictionary etc.

• 

  Pedro Vazquez Rosario

  • September 06, 2016 14:37

  0

  Comment actions Permalink

  Hi,
  
  You can use a Jobflow to trigger a graph (simple graph with EmailSender) based on if its the production or non production server. If for example you are using Scheduling you will Start a Jobflow and add a Parameter (we will call it Environment) that will be sent to the said Joblow. Please see below screenshot:
  
  emailSender.PNG
  
  We will use Environment Parameter to determine which graph will be executed (Production or Non Production). Each graph will have it own set of Parameters Files which will have the SMTP credentials (e.g. SERVER, USERNAME, PASSWORD). You will need access these Parameters and use them in the EmailSender component (e.g. ${SERVER}).
  
  I have taken the liberty of attaching a sample project with this exact use case.

  • emailSender.PNG
  • EmailSender.zip
• 

  jzhu

  • September 12, 2016 14:08

  0

  Comment actions Permalink

  Thanks, Pedro.
  
  That is a solution, which will do for now.
  But it is really inconvenient -- We'll have to create a few extra jobflows just for the SMTP server settings of EmailSender, for production/non-production and various local test environment. Hope it is better in the future.

Please sign in to leave a comment.