4.4 Configuring Passwords for Oracle BI Publisher Data Sources

The passwords for all data sources in the datasources.xml file are not migrated during the migration. You must manually enter and save the password for each data source using the Administration page in BI Publisher.

To set the passwords:
  1. Sign in to the BI Publisher Enterprise.
  2. Configure each data source, such as JDBC, JNDI, File, LDAP, OLAP, Web Service, and HTTP connections under Administration.
  3. Enter the details in the Database Driver Class, Connection String, Username, and the Password fields while configuring each data source and click Apply.
  4. Update the Database Driver Class and the Connection String details for the following data source entries:
    • SQLSERVER2012
    • SQLSERVER2008
    • SQLSERVER2005