Prerequisites
- .NET Framework, version 4.6.2 and above
Implementing automatic Custom Code upload consists of the following steps:
- Configure Oracle Wallet
- Create the program executable
- Create a concurrent program with the relevant parameters
- Link the concurrent program to the relevant Request Group
- Save the Panaya Shell Script under your custom top folder (/bin)
Step 1 - Configure Oracle Wallet
Follow these instructions to extract the Panaya certificate from your browser, then -
-
Create a new wallet in the default location ($ORACLE_HOME/wallets/) named as the RDBMS owner
-
Upload ithe CER to the Oracle Wallet
-
Save and give it a password (a1234567 for example) and checked the "auto login"
-
Change this 2 lines in the script to align with your Oracle Wallet definition
Step 2 - Create the program executable
|
Activity Field |
Value you should choose |
Panaya Recommended Value |
|---|---|---|
|
Executable |
Any executable User name you choose |
XXPAN : Automatic ETL Upload |
|
Short Name |
Any executable Short name you choose |
XXPAN_AUTO_ETL_UPLOAD |
|
Application |
Custom application |
|
|
Description |
Any executable Description you choose |
XXPAN : Automatic ETL Upload |
|
Execution Method |
Host |
Host |
|
Execution File Name |
Xxpanuploadetl |
XXPANuploadETL |
Step 3 - Create a concurrent program with the relevant parameters
|
Activity Field |
Value you should choose |
Panaya Recommended Value |
|---|---|---|
|
Program |
Any concurrent program name you choose |
XXPAN : AUTOMATIC ETL UPLOAD |
|
Short Name |
Any concurrent program short name you choose |
XXPAN_AUTO_ETL_UPLOAD |
|
Application |
Custom application
|
|
|
Description |
Any concurrent program description you choose |
XXPAN : AUTOMATIC ETL UPLOAD |
|
Executable Name |
|
XXPAN_AUTO_ETL_UPLOAD |
Parameter Table
|
Parameter |
Description |
Enable |
Value Set |
Default Type |
Default Value |
Required |
Prompt |
|---|---|---|---|---|---|---|---|
|
Panaya_User |
Panaya user |
✓ |
100 Characters |
Constant |
Panaya account user |
✓ |
Panaya user |
|
Panaya_Password |
Panaya password |
✓ |
100 Characters |
Constant |
Panaya account password |
✓ |
Panaya password |
|
ErpId |
Erp id |
✓ |
100 Characters |
Constant |
Panaya system id |
✓ |
ERP ID |
|
FilePath |
File path |
✓ |
100 Characters |
Constant |
Where the ETL jar file is located |
✓ |
file path |
|
Apps_Pass |
Apps password |
✓ |
100 Characters |
Constant |
Apps schema password |
✓ |
apps password |
|
System Pass |
System User assword |
✓ |
100 Characters |
Constant |
System DB schema password |
✓ |
system user password |
|
panaya_site |
Panaya site |
✓ |
100 Characters |
Constant |
my.panaya.com |
✓ |
Panaya site |
Step 4 - Link the concurrent program to the relevant Request Group
Step 5 - Save the Panaya Shell Script under your custom top folder (/bin)