Automatic Oracle Custom Code Upload via API
- 1 Minute to read
- Print
- DarkLight
- PDF
Automatic Oracle Custom Code Upload via API
- 1 Minute to read
- Print
- DarkLight
- PDF
Article Summary
Share feedback
Thanks for sharing your feedback!
Prerequisites
.NET Framework, version 4.6.2 and above
Configuring 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 the CER to the Oracle Wallet
Save and give it a password (a1234567 for example) and check the "auto login"
Change the following 2 lines in the script to align with your Oracle Wallet definition
Creating Program Executable
Create the program executable as described below.
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 |
Creating a Concurrent Program
Create a concurrent program with the relevant parameters as described below.
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_Access Token | Panaya Access Token | ✓ | 150 Characters | Constant | Panaya Access Token | ✓ | |
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 |
Linking the concurrent program
Link the concurrent program to the relevant Request Group.
Saving in a Custom Top Folder
Save the Panaya Shell Script under your custom top folder (/bin).