Modifying Connections

Modify a private connection. You can modify a private connection to change the server, application, or database information for all data providers associated with the connection.

The connection information can be changed whether you are connected or not.

For example, you may be working in a test environment using a private connection. When you are ready to move to a production environment, you change the server information for that private connection to access the new environment.

This procedure is described in Modifying Private Connections.

Modify the connection information for individual entities within a document. You can modify the connection information for individual entities within a document using the Document Contents panel. You can change connections per sheet. Or, in a sheet containing multiple entities, you can change the server connection for one or more of the individual entities.

For example, while connected to Oracle BI EE, you may have inserted a compound view containing 10 graphs. Now you would like to pull data from a different Oracle BI EE server for three of the graphs. Using the Document Contents panel, you can modify the connection information s for the each of the three graphs to point to the newOracle BI EE server.

This procedure is described in Modifying Connections within an Office Document.