How to implement Automatic Custom Code Upload using API?

Prerequisites

Implementing automatic Custom Code upload consists of the following steps:

  1. Configure Oracle Wallet
  2. Create the program executable
  3. Create a concurrent program with the relevant parameters
  4. Link the concurrent program to the relevant Request Group
  5. 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 -

  1. Create a new wallet in the default location ($ORACLE_HOME/wallets/) named as the RDBMS owner

  2. Upload ithe CER to the Oracle Wallet 

  3. Save and give it a password (a1234567 for example) and checked the "auto login"

  4. 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

To get your ErpID, contact Panaya Support

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
emea.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)