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