Managing Private Data Sources

Data model developers can create and manage private JDBC, OLAP, Web service, and HTTP data source connections without having to depend on an Administrator user. However, Administrator users can still view, modify, and delete private data source connections, if needed.

Private data source connections are identified by the word (Private) appended to the end of the data source name. For example, if you create a private JDBC connection called My JDBC Connection, it is displayed as My JDBC Connection (Private) in the data source drop-down lists.

If your user has the Administrator role, you can only create public data sources, even if you create the data source from the Manage Private Data Sources page. For more information about private data source connections, see About Private Data Source Connections in Administrator's Guide for Oracle Business Intelligence Publisher.

For more information on setting up the data source types, see Setting Up Data Sources in Administrator's Guide for Oracle Business Intelligence Publisher.

To create a private data source connection:

  1. From the data model editor toolbar, click Manage Private Data Sources.
  2. Select the connection type tab, and click Add Data Source as shown below.


    If you are logged in as an Administrator, all data source connections will display for you in this dialog; however, you can only create or modify JDBC, OLAP, HTTP, and web service data sources from this dialog.

  3. Enter the private connection name, and the connection information.
  4. Click Test Connection. A confirmation is displayed.
  5. Click Apply. The private data source connection is now available for use in your data sets.