Database
Discussion List
-
Not able to fetch the REST API generated by OIC in OCEContent Hi, We are trying to fetch the REST API which is successfully generated by the OIC. (REST API is generated by fetching the Data from Oracle Database and OIC is g…
-
Object(global) of class cannot be converted toContent Hi, While integrating OIA with Oracle database in Oracle Integration Cloud(OIC), as we mapped global(id) of OIA a default parameter to a primary key id of Oracle…
-
Getting a list of errors while Integrating OIA with Oracle DBContent Hello, While integrating OIA with Oracle DB, as we activate the integration and insert values from OIA UI to the Oracle DB to store inside the database, below ar…
-
GET/POST operation to make a REST API put values onto a UIContent What operation should we use in the REST API to put values to a UI , as we are trying to push the values from one component (OIA interview) to (OCE) through OIC.…
-
How to sort records in OICSummary How to sort records comin from source based on a field valueContent Hi Team, We are trying to processing the records after we sort them. We are getting data from…
-
How to connect Snowflake databse in OICSummary How to connect Snowflake databse in OICContent Hi All, How to connect Snowflake database in OIC if we can able to connect, please suggest what adapter we can use…
-
Simple type deserialization issue while upserting data to Salesforce Custom ObjectSummary Simple type deserialization issue while upserting data to Salesforce Custom Object thorough OICContent Hi Team, We are trying to upsert data from DB to Salesforc…Jagadeesh Kumar Thontapaka 7 views 0 comments 0 points Started by Jagadeesh Kumar Thontapaka Integration
-
Is that TRUNCATE query not supported?Summary Is that TRUNCATE query not supported?Content Hi, When I am using the TRUNCATE query in Run on SQL Statement, OIC is showing SQL statement syntax is not supported…
-
Reading a DB column containing a JSON string and passing it to a third party APIContent Hi everyone, we are storing a JSON string in a DB column, and we would like to parse it in OIC and sending it to a third party API using the Rest Adapter. How ca…
-
Database Adapter - Issue with datetime datatype of Database columnSummary Issue with datetime datatype of Database columnContent Hi Everyone, We are connecting to on-premise database and issuing insert statement. The insert statement c…Karthick Rajarathinam 11 views 1 comment 0 points Most recent by Hemanth Lakkaraju-Oracle Integration
-
Oracle Database Adapter - SQL IssueSummary Issue while trying to create a SQL queryContent Hello guys, i'm trying to implement a simple query as code snippet but i'm receiving the following error: Error: …
-
Oracle Integration Cloud running SQL statement in Oracle ATPSummary Getting error when I ran sql statement in ATP using oracle integration cloudContent Hi, I am executing sql statement using oracle integration cloud in ATP databa…
-
DB Adapter reflects new columnSummary DB Adapter DOES Not reflects new columnContent When we add a new column in table, in OIC we have to delete the whole mapper which comes along with the adapter. I…
-
OIC IBM DB2 Adapter & AS400Summary DB2 AdapterContent Hello All, I understand OIC has a prebuilt IBM DB2 adapter which allows to perform CRUD operations for DB2. However another Document Doc ID 24…
-
Using OIC to Make JDBC calls to AS400Summary JDBC Calls using OICContent Hello Everyone, We have a requirement where we need to intergrate AS400 DB to OIC. AS400 supports JDBC calls. Is there a way we can u…
-
Information about MuleSoftContent I am currently working as an OIC Developer with 2 years of experience in IT Industry. I came to know about MULESOFT from one of my colleagues. Is it worth to hav…
-
Avoid DBCS in OICSummary Store in variable to use in Multiple processContent Hi Gurus, I have a integration which is dependant on diffrent callback responses. The flow is as below. a) I …
-
we are trying Enqueing operation in AQ adapterSummary We are trying Enqueing XML Payload as a Data into Queue Table. For that we selected Queue Details in AQ adapter and structure of the payload is NO (we selected O…
-
We are trying to write json file into stage file and we able to write. now we are trying to read samSummary We are trying to write json file into stage file and we able to write. now we are trying to read same json file in other integration with filename and directory.…
-
How can we use 'request is html form' in REST adapterSummary How can we use 'request is html form' in REST adapterContent How can we use 'request is html form' in REST adapter. I have configured REST Adapter Resuest payloa…
-
We are getting Time out Error while JS Function running (java script is running too long (15000ms).Summary We are getting Time out Error (java script is running more the 15s).Content Hi, We are generating JWT Token using JavaScript in OIC and Script is taking 12s to e…
-
Using ATP Database with DB AdapterContent Hi Team, I am looking for an option to move from DB System to ATP. We have integrations built with DB Adapter and now when I want to move to ATP, it would take a…
-
How to use sequence without a databaseSummary We need to make a unique msg_id from a sequenceContent We need to make a unique msg_id from a sequence without having acces to a database. Is it possible i OIC. …
-
fetch refresh token in REST callSummary How to fetch refresh token in OIC REST callContent Hi All, We have configured REST OAUTH as Resource owner password credential with access token URI in connectio…Sumanth Kunimakki-236116 25 views 5 comments 0 points Most recent by Sumanth Kunimakki-236116 Integration
-
how can we read the data of pdf file from Stage File ReferenceSummary we have Base64Encode value of pdf file and we have to store those pdf file into AWS s3 bucket.Content Hi, we have Base64Encode value of pdf file and we have to s…
-
Select records in Batches from DB.Content We have a requirement to pull records from DBCS. The data/volume is very high and its required to pick records in batches. Example we have 200K rows of data in a…
-
Deploy NodejS AngularJs with Mysql on Compute InstanceContent Hello, i have an application, done with nodejs Angularjs and Mongodb and i want to deploy it on oracle. But i want to deploy it on my compute instance and have a…
-
How can we Store PDF file in AWS S3 using OIC REST ADapterSummary we have requirement for file should stored in S3 as pdf fileContent HI, we have requirement for file should stored in S3 as pdf file we have s3 rest url awsXXXXX…
-
Efficiently Handling DB Insert/Update Activity in OIC w/ No Response PayloadSummary DB Insert/Update Operations in OIC don't have a RESPONSE Payload confirming if the operation successfully applied to the DB, requiring special handling.Content H…
-
Error IN/OUT Paraamter in DBaaS adapterContent Hey, I'm using a dbaas adapter to perfom a query on a database. I will get this error currently: Error message is - DBReadInteractionSpec Execute Failed Exceptio…