Data Integration

Get Involved. Join the Conversation.

Posts

  • Dvi Chauhan
    DIPC vs ODIcs1
    Topic posted August 5, 2019 by Dvi Chauhan, tagged DIPC, ODI 
    Title:
    DIPC vs ODIcs
    Summary:
    Difference between DIPC and OCIcs
    Content:

    Hello Folks,

    Is DIPC a new way of having ODI in cloud? IS ODIcs still available to be installed in PaaS provisioned JCS?

    What is the high level difference between DIPC and ODIcs?

    Thanks

    Dvi

  • 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
    Load into Fusion applications1
    Topic posted July 15, 2019 by Raghavendra ManchigiahBlue Ribbon: 750+ Points, tagged Cloud, DIPC, ODI 
    Title:
    Load into Fusion applications
    Summary:
    Using ODI to load data in Fusion
    Content:

    With reference to a previous post - would like to clarify if ODI / DIPC can be used to create files in FBDI / HDL etc...compliant format , placed in a UCM location and trigger an ESS job

    https://blogs.oracle.com/dataintegration/oracle-data-integrator-odi-to-load-into-fusion-applications-oracle-erp-cloud

    Above post refers to such a use case - However all the research that we have done points to the fact that target web service execution is not supported in DIPC

    What is the solution then? use ODI - on Prem? Is ODI - CS still offered as a service or is the same product now called DIPC ? Please help clear the ambiguity.

    Thanks

    Raghvendra

  • Gleb Otochkin
    DIPC for Big Data cannot see the running manager2
    Topic posted May 16, 2019 by Gleb OtochkinGreen Ribbon: 100+ Points, tagged Big Data / Data Lake, Data Replication, DIPC 
    Title:
    DIPC for Big Data cannot see the running manager
    Summary:
    Trying to run replication to Kafka connect and getting an error
    Content:

    When I try to run replication task from Oracle db to Kafka topic I am getting error in DIPC

    "GoldenGate manager is not running for agent, ogghost1.c.myhostname.internal:7005. Start the GoldenGate manager for the agent"

    The agent shows the manger is on and when I go to the host where agent runs I see the manager is online:

    GGSCI (ogghost1) 2> info all

    Program     Status      Group       Lag at Chkpt  Time Since Chkpt

    MANAGER     RUNNING                                           
    JAGENT      STOPPED                                           
    PMSRVR      RUNNING                                           


    GGSCI (ogghost1) 3> 

     

    Have anybody had the same issue? 

    Thanks,

    Gleb

    Version:
    18.4.3
  • 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

     

     

  • Dragos Vilcu
    web services as source for DIPC6
    Topic posted April 19, 2019 by Dragos VilcuRed Ribbon: 250+ Points 
    Title:
    web services as source for DIPC
    Summary:
    web services as source for DIPC
    Content:

    Hello ,

    can DIPC (not DIPC - Classic) use web services as a source ? it seems not, as per "ODI Execution" certification matrix .

    Thank you

     

  • Dragos Vilcu
    using ODI Studio with DIPC ?9
    Topic posted April 12, 2019 by Dragos VilcuRed Ribbon: 250+ Points, tagged DIPC 
    Title:
    using ODI Studio with DIPC ?
    Content:

    while in DIPC - C (Classic) it was possible , by connecting through SS tunneling to some instance with ODI Studio ,  to use ODI Studio and connect to DIPC - C repository , according to the documentation there is no such option anymore for  DIPC  : " You won't have access to the database and storage associated with your instance."

    in such conditions, what are the options of developing an ELT for DIPC ? I couldn't find any documentation on this fundamental problem . the only thing I found in the documentation was "If you need ODI Studio, run it from a user-managed instance or on-premises, and then import/export the design work. You won't have access to WebLogic Server to fix an ODI data source. Instead, you must file a report to the operations team." ,  but that phrase is hardly sufficient to understand how can it be really done in practice... any other documentation available on this topic ? 

     

     

  • siddharth Dang
    DIPC Connection to remote informix1
    Topic posted April 4, 2019 by siddharth DangGreen Ribbon: 100+ Points, tagged DIPC, EDQ, ODI, On-Premise 
    Title:
    DIPC Connection to remote informix
    Summary:
    In the oracle open world presentation, oracle states that DIPC can connect to Informix. But as per the documentations, informix is not yet supported. Is there any other way that i am missing.
    Content:

    In the oracle open world presentation, oracle states that DIPC can connect to Informix. But as per the documentations, informix is not yet supported. Is there any other way that i am missing.

    Also EDQ still does not support informix as a source. how can we perform EDQ use cases on informix source.

    Version:
    DIPC 18.4.3
  • 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!