Step 1 :
Activate the integration and click on endpoint.
Copy the Endpoint URL.
Step 2 :
Open SoapUI tool and click on REST and paste the above copied endpoint URL and click ok.
map the different terms used to describe the same item across your
applications. Lookups are exact same as Data
Value Map(DVM) in SOA.
Lets see how to define a Lookup in OIC with an example :
Use Case :-
Inside this blog, we see will define a lookup for Country Code & Country Name. For a specific Country Code we will assign one unique Country Name.
|
Country_Code
|
Country_Name
|
|
USA
|
United States of America
|
|
IS
|
Israel
|
development Steps in detail :
– Advertisement –
In the previous blog we have seen how to define Lookups in OIC. In this blog we will use that defined lookups in an Integration.
STEP 1 : create a App Driven Orchestration
Enter Below details and click Create :
*what do you want to call your Integration : Country code to
Country Name (you can give any meaningful name)
– Advertisement –
Overview : In the previous blog ( click to see the blog ) we have learned basics about OIC Connectivity Agent and the steps to install it in a local machine (personal laptop) Now in this blog we will create an integration to insert records into a database using the installed connectivity Agent. *Make sure your system
Whether you are a developer, a DBA, a data scientist, an educator, or just curious about databases, Oracle Database 18c Express Edition (XE) is the ideal way to get started. It is the same powerful Oracle Database that enterprises rely on worldwide, packaged for simple download, ease-of-use, and a full-featured experience. You get an Oracle Database to use in any environment, plus the ability to embed and redistribute – all completely free!
– Advertisment –
One case scenario describe through below diagram :
OIC Connectivity Agent High-Level Installation Steps :
- Create an Agent Group in the OIC Console
- Download the Connectivity Agent zip file from the OIC Console
- Unzip the contents of the zip file on the on-premise agent machine
- Update the InstallerProfile.cfg with the details of the OIC environment and on-premise network
- Run the agent using java -jar connectivityagent.jar
In this blog we will see the signup steps for Free Oracle Cloud Account and in the next blog will see steps to provision Free OIC Instance for 1 month. Approach: First create Free Oracle Cloud Account Second when the Once Oracle Cloud Account is fully provisioned will Create OIC Instance (in next blog) *Note : Oracle
Knowledge : 👀 Extension libraries provide a means to register and organise javaScript for use in integrations.Library functions are automatically available for you to drag from the Actions palette to your orchestration integrations. – Advertisement – In this blog we will see how to define custom function in OIC and then use it inside our
USE CASE : In this blog we will see how to READ a csv file records from FTP server directory. Inside this POC we will develop an integration which will take two INPUTS → File_Name, Directory_Path and will give file records as OUTPUT. INPUT : FTP .CSV FILE : OUTPUT : Lets see the development
Use case : In this blog we will see how to perform Write operation using FTP adapter in OIC. In this POC we will develop an integration which will take some Inputs and that inputs will get saved as .csv file in remote FTP location. Knowledge : 👀 Click to know about basics of FTP