Combining Data Sources if the Primary Data Source is on an Oracle Database

Previous TopicNext TopicContents

If your primary data source is on an Oracle database:

  1. Run the staretl for your additional data sources that are also on the Oracle database.
  2. Make a backup copy of the star.properties file.
  3. Run the configStar file.
  4. When prompted, change the database for the PxRptUser so it points to the Microsoft SQL Server database and finish the configuration.
  5. Open the re-created star.properties file and verify that the PxRptUser now points to the Microsoft SQL Server database.

    Note: Keep both copies of the star.properties file, so you can switch between the databases.

  6. Run the staretl "s#" file for your Microsoft SQL Server data source (for example, staretl "s2").
  7. Switch back to the star.properties file for the Oracle database.
  8. Run the staretl "s#" file for your Oracle data sources (for example, staretl "s2").

Related Topics

Combining Data Sources if Using Both Oracle and Microsoft SQL Server Data Sources

Combining Data Sources if the Primary Data Source is on a Microsoft SQL Server Database



Legal Notices
Copyright © 1999, 2014, Oracle and/or its affiliates. All rights reserved.

Last Published Friday, January 31, 2014