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

Previous TopicNext TopicContents

If your primary data source is on a Microsoft SQL Server database:

  1. Run the staretl for your additional data sources that are also on the Microsoft SQL Server 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 Oracle database and finish the configuration.
  5. Open the re-created star.properties file and verify that the PxRptUser now points to the Oracle 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 Oracle data source (for example, staretl "s2").
  7. Switch back to the star.properties file for the Microsoft SQL Server database.
  8. Run the staretl "s#" file for your Microsoft SQL Server 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 an Oracle Database



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

Last Published Friday, January 31, 2014