Leveraging ATP adapter in OIC to connect ATP Cloud

By -



This article will guide you to configure ATP(Autonomous Transaction Processing Cloud) in the OCI instance and how leveraging ATP adapter we can connect to the ATP cloud database in the OIC instance. 








Log in to OCI Account and follow the navigation depicted in the below screenshot 


Oracle Database -->Autonomous Transaction Processing







Choose Compartment --> Create Autnomous Datbase 






               1. Provide Database Name 
               2. Provide ADMIN Password
               3. Create Autonomous  Database





After clicking on Create Autonomous Database button, ATP Database will be created. 




To access ATP database, click on Tools and then click on Open Database Actions



Provide Username as ADMIN and Password which we have just set 


 SQL Worksheets will be open and that enables you to create database objects such as Tables, PLSQL Packages, Database View, etc.,



ATP database has been created, now if we want to access this database in the Oracle Integration Cloud service then we have to follow certain steps 


The first step is to Download Client Credentials (Wallet) by providing a  password. Once the password created , zip file will be generated.



This Wallet enables wallet owners to manage and edit the security credentials in their Oracle wallets. A wallet is a password-protected container used to store authentication and signing credentials, including private keys, certificates, and trusted certificates needed by SSL.

Wallet file will be downloaded as ZIP  which will contain below files 
  • tnsnames.ora and sqlnet.ora: Network configuration files storing connect descriptors and SQL*Net client-side configuration.

  • cwallet.sso and ewallet.p12: Auto-open SSO wallet and PKCS12 file. The PKCS12 file is protected by the wallet password provided while downloading the wallet.

  • keystore.jks and truststore.jks: Java keystore and truststore files. They are protected by the wallet password provided while downloading the wallet.

  • ojdbc.properties: Contains the wallet related connection property required for JDBC connection. This should be in the same path as tnsnames.ora.

  • README: Contains wallet expiration information and links for Autonomous Database tools and resources.





Now Wallet downloaded, now let's create connection in OIC to connect ATP Cloud instance. Follow the steps depicted in screenshots. 



Select the ATP adapter 


Enter Name for the Connection 



Upload the recent download WalletZip file and provide wallet user name and password 



The next step is to enter the service name without which we cannot proceed further. Service Name can be found from tns.ora in the Wallet zip which we have downloaded recently. Follow the steps depicted in screenshots 





Provide the service name and enter Database ADMIN as user name and password of it. 
Click on Test to validate the connection. 


Connection is successful ! 

 

Pranay is a versatile Oracle Technical consultant. Adept in Oracle ERP development, SDLC management, design, and architecture. He has 11 years of extensive experience in Oracle Apps implementation engaged in technical development areas of Oracle Applications 11i/R12 E-Business Suite. He possesses sound knowledge in technologies like OAF, ADF, J2EE, MSCA, Oracle PaaS Cloud, Java Cloud services, ADF & XML Publisher. Currently, he is working for BirlaSoft Inc. USA. Being a Consistent solution provider in Oracle Developer Community forums earned him the title of "Technology Master”, Currently he holds 3rd position globally for providing a solution in Oracle Developer Community for the OAF Workspace. He has also authored several articles on ADF Technology, Fusion Financials, OAF & PaaS Cloud. He successfully presented the case study in Oracle Collaborate event forum on "How optimizing the Oracle Mobile App Solution Helped in Boosting the Productivity of a Warehouse."

Comments

Post a Comment

Popular posts from this blog

Sample HZ API's script to Create Contacts and Contact Points in Oracle

By -
1. Below Code will create Contact Point in Oracle . DECLARE    P_CONTACT_POINT_REC   HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;    P_PHONE_REC           HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;    P_EDI_REC_TYPE        HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE;    P_EMAIL_REC_TYPE      HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;    P_TELEX_REC_TYPE      HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE;    P_WEB_REC_TYPE        HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE;    X_RETURN_STATUS       VARCHAR2 (1000);    X_CONTACT_POINT_ID    NUMBER;    X_MSG_COUNT           NUMBER;    X_MSG_DATA            VARCHAR2 (1000); BEGIN    P_CONTACT_POINT_REC.CONTACT_POINT_TYPE := 'EMAIL';    P_CONTACT_POINT_REC.OWNER_TABLE_NAME := 'HZ_PARTIES';    P_CONTACT_POINT_REC.OWNER_TABLE_ID := 150336; ---L_ORG_PARTY_ID; commented by  pranay tiwari on 05-Jun-2014    P_CONTACT_POINT_REC.CREATED_BY_MODULE := 'TCA_V2_API';    ----email    P_EMAIL_REC_TYPE.EMAIL_FORMAT := 'MAILHTML';  
Read more

REST integration built-in OIC to read Large files with size more than 10MB

By -
Image
Processing large files in any integration requires a lot of effort and complex coding. Every integration platform has a limit size to read a file, similarly, the OIC service provides a limit of 10MB to read the file, if the size exceeds, then the below error will be encountered  Error Reason: Translation Error. Translation Error. Error while translating message to native format. Please make sure that the payload for the outbound interaction conforms to the schema and payload size does not exceed threshold. Error occured as File size exceeds maximum threshold size of 10 MB : Application Error Error Summary: ICS runtime execution error  In this article, we will learn how to read the big-size file in OIC.  Note only XML and CSV formats are supported for larger file read operations.  Here we will build an integration with a source FTP connector to read files containing sizes more than 10 MB  &  read them through the "Read File in Chunks" features and create multiple files  at
Read more