Adding More than Three Data Sources to the Star Database

Previous TopicNext TopicContents

Determine how many data sources to use before running the staretl. You must edit scripts and rerun the ETL processes for each data source.

Caution: Before editing the scripts, manually backup the history data. When you add more data sources, the staretl.bat "-r" file will rebuild all tables and remove all existing activity level history. If you don't backup your history data, it will be lost.

If you want to manually add more than three data sources, follow the steps below.

Notes:

  1. Back up your history data.

    Note: You can use the Configuration Utility to add data sources.

  2. Run the staretl.bat "-r."
  3. Run all your other data sources. For example:
  4. Run the additional data sources you just created. For example:
  5. Locate the W_PROJECT_D table and verify that there is a datasource_id =4 (as well as additional data sources if you created them) and that the other datasource_id's exist for 1, 2, and 3.

Related Topics

Multiple Data Sources in the Star Database

Adding Up to Three Additional Data Sources to the Star Database

Adding Codes from Multiple Data Sources into a Star Database

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



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

Last Published Friday, January 31, 2014