Posts

Posts

  • Arunkumar
    Oracle DBaaS Adopter to ATP Adopter MigrationAnswered105.0
    Topic posted August 6, 2019 by ArunkumarRed Ribbon: 250+ Points, tagged Adapters, Database in Integration > Integration public
    Title:
    Oracle DBaaS Adopter to ATP Adopter Migration
    Summary:
    Oracle DBaaS Adopter to ATP Adopter Migration
    Content:

    Hi All,

     

    We are in the process of Upgrading the Classic Database to ATP Cloud Service. In this DB, we have an OIC Integrations Tracking tables.

    Now we have connected to ATP through ATP adopter. change in the adopter requires all integration to be rebuilt.

    Is there any alternative solution to migrate the integration without changing the mapping for the Oracle DBaaS adopter to ATP adopter?

    Thanks in Advance.

    Arun

     

     

    Version:
    Autonomous Oracle Integration Cloud Service
  • Karthik Ramachandran
    Run a select clause in ATP database with 'in'...45.0
    Topic posted August 5, 2019 by Karthik RamachandranRed Ribbon: 250+ Points, tagged Database, Integration, PaaS, REST in Integration > Integration public
    Title:
    Run a select clause in ATP database with 'in' Operator using OIC ATP Adapter
    Summary:
    Run a select clause in ATP database with 'in' Operator using OIC ATP Adapter
    Content:

    Hi,

    RestAPI structure : 

    {

    'accountNum' : '123456'

    'product' : ['abc','def','ghi']

    }

    I can receive multiple product name in rest api, i need to concatenate the array like this ('abc','def';'ghi') and which i was able to do using XSL concat & create-delimited-string function. i can see the same when i log the same function in logger. But when i pass that variable the ATP adapter to run a query like this.

    Select accountid, accountName, productid, price from producttable where productname in #productname

    it should work similar to below query which i run in ATP db directly

    Select accountid, accountName, productid, price from producttable where productname in ('abc','def';'ghi')

    But it is not retrieving any record. same query work fine in ATP database but it doesn't work from OIC. Do OIC doesn't support 'in' operator in select statement?

  • Ziv Rubin
    Browser Crashed While Trying to Load 20K Rows From External...11
    Topic posted August 4, 2019 by Ziv RubinBronze Medal: 1,250+ Points, tagged Business Objects, Database, Groovy, REST, Web in Application Development > Visual Builder public
    Title:
    Browser Crashed While Trying to Load 20K Rows From External REST API
    Content:

    Hi All,

    While trying to load data from a rest API to a Business Object, it suddenly crashes - probably because I was trying to load 20K rows.

    Does anyone know a better way to load data from external REST API to my VBCS BO?

    Thanks,

    Ziv

  • Mohana Gopal Selvam
    DBCS - Connection12
    Topic posted July 31, 2019 by Mohana Gopal SelvamSilver Crown: 22,500+ Points, tagged Adapters, Connection, Database in Integration > Integration public
    Title:
    DBCS - Connection
    Content:

    Hi,

    We have tried to connect the Oracle Database Cloud Service using 'Oracle Database' adapter. But it is error out. How to create connection for DBCS.

    Thanks,

    Mohan

    Image:
  • Mohana Gopal Selvam
    Integration ApporachAnswered85.0
    Topic posted July 31, 2019 by Mohana Gopal SelvamSilver Crown: 22,500+ Points, tagged Database, REST in Integration > Integration public
    Title:
    Integration Apporach
    Content:

    Hi,

    Our customer have DB Cloud, OIC (Oracle Integration Cloud), JCS (Java Cloud Service) and Fusion Cloud (SaaS). We have tried to integrate the third party system from our CRM fusion application. We have built some pages using DCS - VBCS (Digital Customer Service - Visual Builder Cloud Service), based on some event in the screen the data from DB cloud needs to push to third party system. (Data resides in multiple tables. We have to build some complex joins) 

    We have identified two approach.

    1. Create custom java program in JCS, it will fetch the data from DBCS and form the request which is requested by third party system and call the third party API. This custom program deployed as Rest API. We will invoke this API from our VBCS screen.

    2. Create API using ORDS (DBCS). Create connections of ORDS API & third party API. Create one integration to integrate ORDS API & third part API in OIC. We will invoke OIC API from our VBCS screen.

    Let me know which one is best approach. 

    Thanks,

    Mohan

  • Karthik Ramachandran
    Run a select clause in ATP database with 'in'...
    Topic posted July 26, 2019 by Karthik RamachandranRed Ribbon: 250+ Points, tagged Database, Integration, REST in Integration > Integration public
    Title:
    Run a select clause in ATP database with 'in' Operator using OIC ATP Adapter
    Summary:
    Run a select clause in ATP database with 'in' Operator using OIC ATP Adapter
    Content:

    Hi,

    RestAPI structure : 

    {

    'accountNum' : '123456'

    'product' : ['abc','def','ghi']

    }

    I can receive multiple product name in rest api, i need to concatenate the array like this ('abc','def';'ghi') and which i was able to do using XSL concat & create-delimited-string function. i can see the same when i log the same function in logger. But when i pass that variable the ATP adapter to run a query like this.

    Select accountid, accountName, productid, price from producttable where productname in #productname

    it should work similar to below query which i run in ATP db directly

    Select accountid, accountName, productid, price from producttable where productname in ('abc','def';'ghi')

    But it is not retrieving any record. same query work fine in ATP database but it doesn't work from OIC. Do OIC doesn't support 'in' operator in select statement?

     

     

     

     

  • Karthick S
    How to Insert multiple values in Business Object in VBCS3
    Topic posted July 25, 2019 by Karthick SRed Ribbon: 250+ Points, tagged Action Flows, Business Objects, Database in Application Development > Visual Builder public
    Title:
    How to Insert multiple values in Business Object in VBCS
    Summary:
    How to Insert multiple values in Business Object in VBCS
    Content:

    Hi Team,

    My goal is to insert all table data into a business object.

    How to achieve this.

    Could you please help me to solve this.

    Thanks,

    Karthick

  • David Tran
    how to update database with the database adapter?2
    Topic posted July 24, 2019 by David TranRed Ribbon: 250+ Points, tagged Adapters, Database, Integration, Mapping, Orchestration, PaaS, Process in Integration > Integration public
    Title:
    how to update database with the database adapter?
    Summary:
    need to update rows based on a value found in one of the fields
    Content:

    Hello Gurus,

    I'm processing data from a database using the DB adapter. I'm able to get data from the database.

    after processing that data, i want to use the primary key from that row of data to update a field value.

     

    the workflow is:

    Get data from DB
         for each row
              process data
              update a field in db to know its been processed.
         end loop
    end orchestration

     I tried the the update option in the connection configuration, but I can only map data, I'm guessing this will perform an update on the entire field vs updating the field where the primary key is found.

    I want something closer to:

    update tablename
    set field1="value"
    where field2 = key;

    such that key is a value I'm getting from iterating over the data in the orchestration.

    How can I do this using the DB adapter?

     

    Thank you in advance.

  • Karthick S
    How to join two tables in vbcs?5
    Topic posted July 23, 2019 by Karthick SRed Ribbon: 250+ Points, tagged Business Objects, Database in Application Development > Visual Builder public
    Title:
    How to join two tables in vbcs?
    Content:

    How to create realationship in BO between two Tables.

    For example: 

    I have two tables.
     Employee Table.  Primary Key: Request_Num
     Course Reference Table. Foreign Key: Request_Num
     
     Common column in both tables: Request_Num
     
    I want to create relationship between two tables based on Request_Num.

    Version:
    19.1.3
  • Karthik Ramachandran
    Oracle Integration Cloud running SQL statement in Oracle ATP11
    Topic posted July 23, 2019 by Karthik RamachandranRed Ribbon: 250+ Points, tagged Connection, Database, Integration in Integration > Integration public
    Title:
    Oracle Integration Cloud running SQL statement in Oracle ATP
    Summary:
    Getting error when I ran sql statement in ATP using oracle integration cloud
    Content:

    Hi,

    I am executing sql statement using oracle integration cloud in ATP database. While adding connection and validating the SQL itself i am getting the error.

    SQL> 

      SELECT CITY, POSTAL_CODE, STATE_CODE, COUNTY
      FROM zeb_vertex_lookup
    WHERE NVL(POSTAL_CODE,0)   = NVL(#postalcode, NVL(POSTAL_CODE,0))
       AND NVL( STATE_CODE,0)      = NVL(#statecode , NVL( STATE_CODE,0)  )
       AND NVL( CITY ,0) = NVL(#city , NVL( CITY ,0))
    AND NVL( COUNTY,0) = NVL(#county , NVL( COUNTY,0))

    I have to use variable name with '#' so that it get displayed in the mapping. if I use ':' sql it is getting validated but i don't see it in the mapping.

    kindly please help.. 

    More Info on requirement -

    My SQL statement where clause should have search condition only if parameter has a value , if it null it should skip it.

    for example refer this pseudo code : 

    var a = select * from address 

    var b = where 1 = 1;

    if (postalcode is not null)

    b = b + 'postal_code =  ' + Postalcode + '

    if (city is not null)

    b = b + 'city = ' + City + '

     

     

     

     

    Image: