CAST AIP Technologies
Page tree

Versions Compared

Old Version 3

changes.mady.by.user James Hurrell

Saved on

compared with

New Version 4

changes.mady.by.user James Hurrell

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Find the section rem Database parameters = Access to the database hosting the Siebel PeopleSoft repository:

rem for Oracle : oracle
rem for DB2 : db2
SET DBTYPE=<PARAM>

You must set this option to match the target RDBMS. For example for Oracle Server:

SET DBTYPE=oracle

rem either a host or an IP
SET SERVER_NAME=<PARAM>
SET PORTNUMBER=<PARAM>
SET DATABASE_NAME=<PARAM>

Enter the three fields, for example, for Oracle Server:

SET SERVER_NAME=MY_HOST
SET PORTNUMBER=1521
SET DATABASE_NAME=MY_DB

Hints:

  • SET SERVER_NAME - enter an IP address or host name
  • SET PORTNUMBER:
    • DB2 = 50000
    • Oracle = 1521 (as per the Tnsname.ora file)
    • Microsoft SQL Server = 1433
  • SET DATABASE_NAME:
    • DB2 = The DB2 database name
    • Oracle =  Either the Service name as per the Tnsname.ora file, or the SID (System ID) as per the Tnsname.ora file
    • Microsoft SQL Server = The instance name
rem <CHOOSE> %JDBC_URL_ORACLE_SID% or %JDBC_URL_ORACLE_SERVICE%
SET JDBC_URL_ORACLE=%JDBC_URL_ORACLE_SID%

When targeting an Oracle Server, you must choose one parameter or the other. E.g. if you define a Service name in SET DATABASE_NAME, you should change the line to:

SET JDBC_URL_ORACLE=%JDBC_URL_ORACLE_SERVICE%

...

SituationMessageWhat should you do?
When the execution is successful.Extraction was successful !Nothing.
When an error is identified, the return code of the extraction is interpreted and a functional message ERROR_MESSAGE is displayed.

Error while extracting Siebel PeopleSoft Project : %ERROR_MESSAGE%

  • 1000: Missing configuration file %CONFIG_FILE%.
  • 1001: Check the log file %EXECUTION_LOG_FILE%.
  • 2000: Unable to establish a connection. Check the log file %EXECUTION_LOG_FILE%.
  • 2001: Error during the extraction. Check the log file %EXECUTION_LOG_FILE%.
  • Other: Java error. Contact CAST Support.
  • Please checks the logs, fix the configuration and retry the extraction.
  • If the issue is not a configuration issue, please contact the CAST Support.

...

  • The name of the Vanilla application or Analysis schema
  • Definition of Siebel PeopleSoft specific rule contextual parameters

...

Code Block
<PeoplesoftProjectConfig vanillaApplication="[application_name_or_analysis_schema_name]">
	<SiebelApplication<PeopleSoftApplication name="[siebelpeoplesoft_app_name]" vanillaName="[app_name_in_vanilla]"/>
	<QualityRule id="[rule_id]">
		<Parameter name="[parameter_name]" value="[parameter_value]"/>
	</QualityRule>
	<QualityRuleGroup name="companyPrefix" active="[true_or_false]">
		<QualityRule id="[rule_id]" active="[true_or_false]">
			<Parameter name="[parameter_name]" value="[parameter_value]"/>
		</QualityRule>
	</QualityRuleGroup>
</PeoplesoftProjectConfig>

...