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

/wp-content/uploads/2014/07/1_502421.png

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.

/wp-content/uploads/2014/07/2_502423.png

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. /wp-content/uploads/2014/07/3_502428.png


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.

/wp-content/uploads/2014/07/3_1_502425.png

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

/wp-content/uploads/2014/07/4_502429.png


Data foundation is multisource-enabled


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

/wp-content/uploads/2014/07/5_502436.png

Click the browse button in the Connection text box. A dialog box lists the available connections.
/wp-content/uploads/2014/07/6_502437.png

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

/wp-content/uploads/2014/07/7_502438.png

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

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

  1. Steven Gray

    I followed your steps, however when I refresh the structure it it saying all my tables are missing. FYI, this is a multi-source universe.

    (0) 

Leave a Reply