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:
select * from V$OPTION
db.star.partitioned=true
Note: Run the following steps as the Star user.
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:
select * from project@dslink#
where # is the number that corresponds to the data source. For example, DSLINK02.
staretl.bat "-s#"
where # is the number that corresponds to the data source. For example, "-s2".
select count(*) from w_project_ds
Related Topics |
Legal Notices
Copyright © 1999, 2014,
Oracle and/or its affiliates. All rights reserved.
Last Published Friday, January 31, 2014