Adding Up to Three Additional Data Sources to the Star Database

Previous TopicNext TopicContents

If you need additional data sources, the Star database allows you to add up to three data sources by default. If you add three data sources and want to add more, see Adding More than Three Data Sources to the Star Database.

Note: Before adding any of these data sources, ensure that all of the P6 Publication services have been run on each data source.

To add data sources:

  1. Validate that Oracle Partitioning is running for your instance. Run this command:

    select * from V$OPTION

  2. Verify this line in the staretl.properties shows "true":

    db.star.partitioned=true

    Note: Run the following steps as the Star user.

  3. Create a DB link for the new data source:

    Caution: Do not use the global domain name (i.e., us.oracle.com) if you are using Microsoft SQL server. Using the global domain name will break the ETL process.

    CREATE DATABASE LINK DSLINK#
    CONNECT TO "pxrptuser" IDENTIFIED BY "pxrptuser"
    USING '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=hostname)(PORT=portnumber))(CONNECT_DATA=(SERVICE_NAME=servicename)))'

    where hostname, portnumber, and servicename are specific to your environment and # corresponds to number for the data source (for example, DSLINK02). The connection should be to the P6 EPPM database where you will pull data.

    Notes:

  4. Verify DB link is working by running the following command:

    select * from project@dslink#

    where # is the number that corresponds to the data source. For example, DSLINK02.

  5. Run the ETL process for the new data source:

    staretl.bat "-s#"

    where # is the number that corresponds to the data source. For example, "-s2".

  6. Verify the row counts by running the following command:

    select count(*) from w_project_ds

  7. Repeat these steps for each additional data source you want to add. (You can add up to three).
  8. Continue to Updating the Data Source.

Related Topics

Multiple Data Sources in the Star Database

Updating the Data Source

Adding More than Three 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