DAC Setup View

DAC Setup View Tabs

 Setup View: In the Setup view, you are able to set DAC system properties, Informatica server connection information and physical data source connection information for all source and target databases.

Parent Pane Tab:

DAC System Properties – Modify DAC server properties.

Child Pane Tabs:

Edit – Modifies the property value.

Description – Contains an overview of the properties.

 

Parent Pane Tab:

Informatica Servers– Enables the Informatica repository and integration services.

Child Pane Tabs:

Edit – Contains the name, type, integration server/host, max session, and other various Informatica component properties. The login user name and password will be used to run the workflows.

Parent Pane Tab:

Physical Data Sources – Create, modify and delete physical data source connections.

Child Pane Tabs:

Edit – Contains the name, connection information, source type, default index location and data source number

Refresh Dates – A list of tables and their last refresh and analyze date. The refresh dates are used for delta comparison in incremental loads.

Parent Pane Tab:

Email Recipients – List of the recipients who will receive emails about ETL status changes.

Child Pane Tabs:

Edit – Contains the name, email address and notification level of each recipient.

 

Functions of DAC Setup View

 

1. To configure DAC system properties

2. To establish Informatica connections

3. To define data source connection information

4. To notify DAC administrators of execution plan status

 

To configure DAC system properties:

1.Click on the “DAC System Properties” tab in the parent pane.

2.Highlight the property you would like to modify.

 

3.Click on the “Edit” tab in the child pane, and enter the values for each property.

4.Click save.

 

To establish Informatica connections:

 

1.Click on the “Informatica Server” tab in the parent pane.

2.Highlight the type of Informatica connection to modify.

3.In the “Edit” tab, enter in the required values.

 

4.Click on the “Test Connection” button to validate the modifications.

 

To define data source connection information:

 

1.Click on the “Physical Data Sources” tab in the parent pane.

2.Select the data source to modify.

3.In the “Edit” tab, enter or modify the type and connection type. Pending the connection type, enter the TNSNAMES or DB Host and Port.

4.Provide the table owner, table owner password, and data source number.

 

5.In the “Edit” tab, click on the test connection button to validate changes.

To notify DAC administrators of execution plan status:

1.Select the “Email Recipients” tab in the parent pane.

2.In the parent pane, click on the “New” button.

3.Using the “Edit” tab in the child pane, enter in a name, an email address and the notification level.