SAP Knowledge Base Article - Public

1218321 - How to change the Data Connection used by a Data Foundation in the Business View Manager?

Symptom

  • How to change the Data Connection used by the Business View?
  • How do you change the Data Connection of an existing Data Foundation to another Data Connection?

Environment

  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
  • SAP Crystal Reports 2020
        
  • SAP BusinessObjects Business Intelligence Platform 4.1
  • SAP BusinessObjects Business Intelligence Platform 4.2
  • SAP BusinessObjects Business Intelligence Platform 4.3

Resolution

  • To change the Data Connection of an existing Data Foundation:
      
    1. Start the Business View Manager, and open the Data Foundation.
       
    2. In the Object Explorer on the left side, right-click on Tables, and select "Set Table Location..."
        
    3. In "Set Table Location", click on the button: "Add Connection..."
        
    4. In "Choose a Data Connection", select the new Data Connection from the repository, and click "OK"
        
    5. Back to the window "Set Table Location", select the new Data Connection, and click on the button "Set"
        
    6. When the following message displays, click "Yes"

      "Table location set successfully. Would you like to verify database to
        update for any table schema changes?" 

    7. If the database schema is the same, then it will display:

        Verify database complete."
        
    8. Click "OK"
         
    9. Save the Data Foundation.
       
             
  • Notes:
    • If there are Business Elements and Business Views that rely on the updated Data Foundation, the 'Save and Reload Dependent Objects' dialog box appears after setting the table location.
        
    • The 'Save and Reload Dependent Objects' dialog box provides you with the options to save a list of elements and business views, and reload them after saving. All the objects that are dependent on the foundation can be updated. When the elements and business views are saved and reopened, they will use the updated Data Foundation.

Keywords

REPOSITORY DATA FOUNDATION CHANGING DATA CONNECTION SWITCH SET DB LOCATION Crystal Enterprise Configuring the data foundation Changing the datasource location Business views and elements , c2016850 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To

Product

SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports 2020