Combining Data Sources if the Primary Data Source is on an Oracle Database
If your primary data source is on an Oracle database:
- Run the staretl for your additional data sources that are also on the Oracle database.
- Make a backup copy of the star.properties file.
- Run the configStar file.
- When prompted, change the database for the PxRptUser so it points to the Microsoft SQL Server database and finish the configuration.
- 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.
- Run the staretl "s#" file for your Microsoft SQL Server data source (for example, staretl "s2").
- Switch back to the star.properties file for the Oracle database.
- Run the staretl "s#" file for your Oracle data sources (for example, staretl "s2").