Changing connection in the data foundation

[former_member4998]

Hi All

I am explaining below step by step process for changing the connection in data foundation.

Changing the connection in the data foundation, connection must be a relational connection and for multi-source enabled data foundations the connections must also be secured(.cns).

Take an example of Sales Universe_Test , it’s related project have the below objects. 

• Data Foundation: Sales DF
• Business Layer: Sales_BL
• Connection: Sales_Connection

Before changing the connection, must create the local connection or connection shortcut (Sales_Change Connection. cnx) in the local project where the data foundation is stored.

Double-click the data foundation (Sales_DF.dfx) name in the local project to open the Data Foundation Editor.

In the Data Foundation Editor, click the Connections tab, and then In the "Connections" pane, right-click the connection, and select Change.

To select a new connection, process depends on data foundation type.

Data foundation type is single source

After selecting change, the change connection dialog box lists all available connections and it display the currently defined connection too.

Select the connection you want to change, and click finish button.

Save the data foundation by clicking the Save icon in the main tool bar.

To Cross check, click on the data foundation and check new connection (Sales_Change Connection) is linked to the data foundation (Sales_DF.dfx).

Data foundation is multisource-enabled

Once you select the change connection, it displays the connections properties for the currently defined connections.

Click the browse button in the Connection text box. A dialog box lists the available connections.

Select the connection you want to change to, and click Finish.

Save the data foundation by clicking the Save icon in the main tool bar.

Once the change connection is completed, need to check the followings.

• On the Toolbar click Refresh Structure  (no tables should be missing).
• The Ownername.tablename.columnname (Schema Name, Table Name, Field Name) should be same for new connection from Data base.
• Run the Integrity checker and Export to the repository if no errors are encountered.
• Check associated new data source without breaking any Webi Reports.

Hope this helpful.

Thanks

Sreeni