This is simple. If the Odi 12c is installed on linux system, then open the terminal and navigate to odi/studio path and run ./odi.sh script.
Steps with screenshots:
This is simple. If the Odi 12c is installed on linux system, then open the terminal and navigate to odi/studio path and run ./odi.sh script.
Steps with screenshots:
Usecase: Here, we will create an object storage rest connection and using that connection, we will create an app driven integration, configure rest call to object storage and get the file from object storage.
Implementation Steps:
Step1: Create Rest connection.
Oracle home >> Integrations >> Connections >> Create >> Rest
Provide rest API base URL
How to create a OCI object storage bucket, how to get Tenancy OCID, User OCID, API private RSA key and finger print and Namespace, everything mentioned in the previous blog. Pleae check below link.
https://soalicious.blogspot.com/2022/08/oic-how-to-use-oci-object-storage-from.html
UseCase: Here, we will create a OCI object storage bucket. From OIC, read a file and put that file to bucket using Rest connection.
Step 1 : Create a bucket in OCI object storage
In the Oracle console >> Storage >> object storage & Archive storage >> select the required compartment >> create bucket
Step 2 : Create a Object storage Rest connection
To create a Rest connection , we need to collect the following information:
Connection type : REST API Base URL
Connection URL : https://objectstorage.<region>.oraclecloud.com
My case, region is: us-ashburn-1
Securtity: OCI Signature Version 1
Tenancy OCID and Object storage Namespace: get the Tenancy OCID from the OCI console on the Tenancy Details page.
Search Tenancy in the search box
Here we also got the Object storage namespace.
User OCID : get the user's OCID in the console on the User details page.
Profile >> User Settings
Private Key & FingerPrint:
Profile >> User settings >> API Keys >> Add API Key >> download private key >> add >> note the fingerprint.
Oracle home >> Integrations >> Connections >> Create >> Rest
Step 3: Create the Integration
Integration flow:
Save, Add Tracking and activate and test
See the below file uploaded to object storage bucket.
Note: Private key downloaded from the Oracle Cloud Infrastructure Console are in PKCS8 format. The OCI Signature version 1 security policy available with the Rest adapter only supports reading of the private key in RSA format(PKCS1) format.
If you receive the following error, you must convert the private key from PKCS8 to RSA(PKC1) format:
oracle.cloud.connector.impl.rest.security.signature.signatureException: java.lang.ClassCastException: org.bouncycastle.asn1.pkcs.PrivateKeyInfo can not be cast to org.bouncycastle.openssl.PEMKeyPair.
Convert the private key with the following command:
openssl rsa -in private_key_in_pkcs8_format.pem -out new_converted_file.pem
We can also convert it using online availavle site like below:
https://8gwifi.org/pemconvert.jsp
Reference:
OIC interview Q & A:
1. FBDI approach with an example
https://soalicious.blogspot.com/2022/02/oic-erp-supplier-bulk-import-and.html
2. OIC FTP vs OIC File adapter
Answer: https://soalicious.blogspot.com/2021/05/oic-file-adapter-vs-ftp-adapter.html
3. ERP events callback or subscription.
Answer:https://soalicious.blogspot.com/2023/03/erp-register-csf-key.html?m=1
4. Gen1 vs gen2 OIC pack
https://soalicious.blogspot.com/2022/03/oic-gen-1-vs-gen-2-benefits-of-oic.html
5. OIC Agents
https://soalicious.blogspot.com/2020/10/oic-connectivity-agent.html
https://soalicious.blogspot.com/2020/11/oic-connectivity-agent-part-2.html
https://soalicious.blogspot.com/2022/05/oic-install-connectivity-agent-in.html
6. How to handle large file in OIC
https://soalicious.blogspot.com/2021/05/oic-how-to-handle-more-than-10-mb-file.html
7. OIC error handling:
https://soalicious.blogspot.com/2021/12/oic-ootb-error-handling-in-easy-steps.html
8. OIC Integration pattern/ Styles
https://soalicious.blogspot.com/2019/11/oracle-cloud-integrationoic-introduction.html
9. OIC migration from one instance to higher one.
https://soalicious.blogspot.com/2022/02/oic-migration-of-integration-from-one.html
10. What issues you observed in OIC ERP.
https://soalicious.blogspot.com/2021/03/oic-synchronous-integrations.html
11. Can file adapter and ftp adapter support high availability mode using connectivity agent?
https://soalicious.blogspot.com/2023/07/oic-can-file-server-and-ftp-server.html
12. Maximum duration for integration flows | time out time for OIC services | Service limit for Scheduled orchestration or Async or Sync service
https://soalicious.blogspot.com/2023/06/oic-maximum-duration-for-integration.html
13. Why to avoid creating too many scheduled integrations
https://soalicious.blogspot.com/2021/07/oic-why-to-avoid-creating-too-many.html
14. How many different scheduled integrations can run in parallel in Oracle Integration | Decoupled scheduler and Business Logic pattern.
Why we need tracing:
If we choose the Integration level tracing, we can enbale or disable the tracing at individual integration level following below steps:
Go To Integrations Page >> select actions >> Tracing >> Enable Tracing & Include Payload >> Save
Usecase: Here, we will create a sub integration which will take a request id and check if ESS job status, if its succceeded, it will download the report and move the file to desired mail dl or sftp directory.
HighLevel steps:
Request payload:
{
"RequestId":"",
"directoryAdapter":"",
"sourceFileName":"",
"targetDirectory":""
}
Implementation logic steps:
1. Export 11g OSB code and import in 12c Jdeveloper. Steps to import OSB project in Jdeveloper: File⇾Import⇾Service Bus Resources⇾ Se...