Data Integration

Get Involved. Join the Conversation.

Posts

  • Gleb Otochkin
    DIPC for Big Data cannot see the running manager2
    Topic posted May 16, 2019 by Gleb Otochkin, 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 18, 2019 by Dragos VilcuGreen Ribbon: 100+ 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 VilcuGreen Ribbon: 100+ 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!

  • 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

  • Swathi gogula
    Delete archive option1
    Topic posted September 26, 2018 by Swathi gogulaBlue Ribbon: 750+ Points, tagged Tip 
    Title:
    Delete archive option
    Summary:
    Delete archive functionality in HCM Extract
    Content:

    Hi ,

     

    Does any one used delete archive option on HCM extracts to improve performance?

    Can you help me with the steps to do so.

     

    Thanks,

    Swathi

     

     

  • Rashmi Rao
    SFTP Delivery option in HCM Extracts4
    Topic posted September 14, 2018 by Rashmi RaoBronze Trophy: 5,000+ Points 
    Title:
    SFTP Delivery option in HCM Extracts
    Summary:
    I have developed a custom HCM Extract and want to deliver it to the client's SFTP Server.
    Content:

    Business requirement is to create a custom HCM Extract and deliver it to the SFTP Server.I have added the SFTP details in the the BI Publisher Administration option but now how to use it with my custom extract.