Thursday, January 3, 2013

DAC Email Notification Setup

DAC can be set up to send email in just a few steps.
This is also useful when you want to send only one success email from a number of infomatica workflows which are scheduled to run through DAC.
The DAC server has a built-in login-authentication based email (SMTP) client, which connects to any SMTP login-authenticating server to send emails.

Unlike informatica which needs the outlook client installed on the server, DAC does not.
1. Set up email recipients
2. configure email sender information

1. To set up email recepients:
Launch the DAC client. 

Click Setup on the DAC toolbar, and then click the Email Recipients tab. 
Click New. 
In the Edit tab below, enter the relevant information for the recipient

Referenced Link:
http://download.oracle.com/docs/cd/E12104_01/books/AnyInstAdm/AnyInstAdmWinInstall24.html
http://download.oracle.com/docs/cd/E10783_01/doc/bi.79/e10742/anyinstadmwininstall.htm#i1089967


2. To set up DAC to connect to the email server:
Select Tools --> DAC server setup
Select the tab: Email configuration
Enter the relevant information as the user  who the email should be sent from.
Click Send Test  Email

The email should be sent to the recipient.