Data Integration

Get Involved. Join the Conversation.

Posts

  • 1-6 of 6
  • Frank Cruz
    Error while trying to create a connection to an oracle data...1
    Topic posted August 30, 2019 by Frank CruzRed Ribbon: 250+ Points, tagged Cloud, Data Transformation, GG, ODI, Provisioning 
    Title:
    Error while trying to create a connection to an oracle data integrator cloud service agent
    Summary:
    When trying to save a database connection associated with a data preparation agent, the following error occurs: Unable to update Oracle DB Client in GG instance with SID information.
    Content:

    After creating an instance of oracle integration cloud service 

    When trying to save a database connection associated with a data preparation agent, the following error occurs:

     In the agent log it shows the following:

    ERROR Unable to process message. The plugin ( ggmon ) which can handle this message was not configured or null on the agent. The received message is : oracle.dicloud.agent.mediator.dto.AgentMessageDTO@3c53288e : {
      "payloadType" : "oracle.dicloud.platform.common.agent.goldengate.mgmt.GGSIDConnectionPayload",
      "payload" : "{\"type\":\"goldengate\",\"name\":\"DBCLOUD\",\"host\":\"132.145.108.235\",\"port\":\"1521\",\"sid\":\"ORCL\"}",
      "msgId" : "76685cfd-d0ab-4699-8b75-4b86984309bd",
      "lastUpdateTime" : 1567179466907,
      "agentId" : "34f75c36-9643-4500-9bc7-d0f6e1167107",
      "agentInstanceId" : null,
      "msgType" : "goldengate".

    Is it necessary to have an instance of OGG to perform this configuration?

    My version is trial.

     

     

    Version:
    Oracle Data Integration Cloud Service
    Image:
  • Dragos Vilcu
    question on ODI from marketplace1
    Topic posted July 25, 2019 by Dragos VilcuRed Ribbon: 250+ Points, tagged Data Replication, Data Transformation, ODI 
    Title:
    question on ODI from marketplace
    Summary:
    multiple agents possible ?
    Content:

    as I understand ODI from marketplace comes with its own embedded repository (which is not Oracle database, but mysql).

    in such a case  is it possible to install multiple agents in various other compute instances, but using the same repository ? if yes, how exactly ?

    thank you

  • Raghavendra Manchigiah
    Integration Usecase3
    Topic posted May 9, 2019 by Raghavendra Manchigiah, tagged Data Transformation, DIPC, ODI, On-Premise 
    Title:
    Integration Usecase
    Summary:
    On Prem DB to SaaS Integration
    Content:

    Dear Experts,

    We are evaluating PaaS offerings to implement the following Integration use case :

    Integrate transactional data from an On-Prem MS SQL Server DB to Fusion Cloud ERP. We expect the load to be heavy ( 150K transactions daily) and are considering ODICS to implement it . Additional requirements include field level validations before submitting payload to Fusion webservice.

    Is this doable in ODICS or is OIC recommended( There may be a need for certain amount of orchestration)

    Kindly advise

    Regards,

    Raghvendra

     

     

  • Kingsley
    Can ODICS Connect to Fusion Cloud2
    Topic posted March 19, 2019 by KingsleyRed Ribbon: 250+ Points, tagged Data Replication, Data Transformation, ODI 
    Title:
    Can ODICS Connect to Fusion Cloud
    Summary:
    Connecting ODICS to Fusion Cloud
    Content:

    Hello Experts!!

    I am trying to move data from fusion cloud to PaaS DBCS. We are currently using BICC and Datasync. Can ODICS do the same? 

     

    Thanks

  • David Tran
    Can OIC poll for file creating in FTP directory?5
    Topic posted February 15, 2019 by David TranRed Ribbon: 250+ Points, tagged Cloud, Data Transformation, Tip 
    Title:
    Can OIC poll for file creating in FTP directory?
    Summary:
    Trying to poll a directory in an FTP for new files
    Content:

    Hello All!

    I need to trigger an integration for when a new file is uploaded into an FTP directory. Is this possible?

    Any help will be appreciated.

    Thanks!

  • Nirmal Kumar
    Pull data from on-premise Oracle DB into PaaS database using...3
    Topic posted January 16, 2019 by Nirmal KumarRed Ribbon: 250+ Points, tagged Cloud, Data Transformation, On-Premise 
    Title:
    Pull data from on-premise Oracle DB into PaaS database using DB link
    Summary:
    Pull data from on-premise Oracle DB into PaaS database using DB link
    Content:

    Hi All,

    Please advise how to Pull data from an on-premise Oracle DB having DB link into Oracle PaaS database.

     

    Thanks,

    Nirmal