Oracle Applications E-Learning Lab

 

Data transformation is another crucial step in integrations. we quite often discuss transformation logic during integration design.  Well, every integration tool or service provides the mechanism to implement data transformations, likewise, OIC also provides lookups where you can create a mapping for the data transformation. Lookups can be used for static values, if you want to derive values based on certain calculations or dynamic values then javascript can be used to perform the transformation logic Here in this case study, we will read data from the database and transform the column values while publishing the final API call  We will design an integration to read data from the database and transform the column values of Designation  Database Value     Transformed Value ITA                       IT Administrator Let's create a table in the On-Premise database instance  CREATE TABLE xx_emp_job_description (     id          NUMBER,     first_name  VARCHAR2(100),     last_name   VAR

This tutorial will emphasize creating REST API within OIC to read CSV files from the FTP server. To proceed with the use case, we need to first create a connection using an FTP adapter, Below article guide you to create   FTP Connection Here is the sample file which is located on FTP Server, now we will develop an integration to read this file and generate JSON payload through REST.  We have a sample file already located in the FTP server, now let's hop into the workspace to create an integration Select App Driven Orechestration  Fill the Name, Identifier and provide the package information for the better practice Drop the REST Trigger on the pallette Fill the endpoint Name Provide the resource URI name and endpoint action as "GET" provide a sample JSON file as shown in the screenshot Here is the sample payload  [ {"id":"", "firstname":"", "lastname":"", "designation":"", "email":&qu