Data Integration

Get Involved. Join the Conversation.

Posts

  • 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

  • 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

     

     

  • 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

  • Ramprasad Nomula
    ODI Package14.0
    Topic posted April 2, 2018 by Ramprasad NomulaGreen Ribbon: 100+ Points, tagged ODI, Tip 
    Title:
    ODI Package
    Summary:
    ODI Package
    Content:

    Hi
    I imported a package in to ODI 11g,while I  am checking I face some issue.Please help me by checking the below Screen shot "Linked objects are missed" All intrefaces and variables available in my Project

     

     

     

    pastedImage_0.png

  • Ramprasad Nomula
    Moving ODI objects15.0
    Topic posted March 29, 2018 by Ramprasad NomulaGreen Ribbon: 100+ Points, tagged ODI 
    Title:
    Moving ODI objects
    Summary:
    Moving ODI objects
    Content:

    Hi All,

    I am trying to  moving interface from one project to another project in ODI 11g.
    Below are the my test cases

    I) i) I  exported interface from new project and deleted from that project

       ii) Imported in to existing project ( but I faced an issue here: instead of importing to existing project again in sits into new project{where from I exported})

     

    2)  i) I  exported interface from new project and deleted from that project

         ii) Directly I tried to move(Drag from new project to existing), here it throws an error "ODI-20057 you cannot move an interface into a folder belonging to another project.

     

    Please help me to solve this

  • Vasanth Mareedu
    When ODICS certification will be released?15.0
    Topic posted March 23, 2018 by Vasanth Mareedu, tagged ODI, Tip 
    Title:
    When ODICS certification will be released?
    Summary:
    When ODICS certification will be released?
    Content:

    Hi,

     

    Could you please let me know the date of ODICS certification available date?

  • Nagesh Nadimatla Ext
    Redshift Data server connectivity issue with standalone...85.0
    Topic posted February 23, 2018 by Nagesh Nadimatla ExtGreen Ribbon: 100+ Points, tagged Big Data / Data Lake, Cloud, ODI, Tip 
    Title:
    Redshift Data server connectivity issue with standalone agent in ODI 12.2.1 on windows server
    Summary:
    Redshift Data server connectivity issue with standalone agent in ODI 12.2.1 on windows server
    Content:

    I have configured Redshift Data server in ODI for this i have copied the suitable JDBC drivers for Redshift in odi installed folder.

    After this when I am trying to test Red shift connection from local agent it is connecting successfully. But trying to test it from standalone agent it is giving below mentioned error.

     

    I have done below changes in Redhsift Dataserver and added the Jdbc drivers in below mentioned paths. Before testing the connection i have restarted Admin server and ODI Agents :

    JDBC Driver:com.amazon.redshift.jdbc42.Driver

    JDBC URL: jdbc:redshift://endpoint:port/database

    pastedImage_2.png

    Path

    C:\Oracle\product\middleware\odi\odi\sdk\lib\RedshiftJDBC42-1.2.10.1009.jar

    C:\Oracle\config\odidev-domain\lib\RedshiftJDBC42-1.2.10.1009.jar

    C:\%APPDATA%\Roaming\odi\oracledi\userlib\RedshiftJDBC42-1.2.10.1009.jar

     

    Error:

    oracle.odi.runtime.agent.invocation.InvocationException: oracle.odi.core.exception.OdiRuntimeException: java.lang.RuntimeException: java.lang.IllegalArgumentException: Could not load JDBC driver class [com.amazon.redshift.jdbc42.Driver]

    at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invoke(RemoteRuntimeAgentInvoker.java:439)

    at oracle.odi.runtime.agent.invocation.support.InternalRemoteRuntimeAgentInvoker.invoke(InternalRemoteRuntimeAgentInvoker.java:162)

    at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invokeTestDataServer(RemoteRuntimeAgentInvoker.java:1118)

    at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.remoteTestConn(SnpsDialogTestConnet.java:664)

    at com.sunopsis.graphical.dialog.SnpsDialogTestConnet$9.doInBackground(SnpsDialogTestConnet.java:622)

    at oracle.odi.ui.framework.AbsUIRunnableTask.run(AbsUIRunnableTask.java:258)

    at oracle.ide.dialogs.ProgressBar.run(ProgressBar.java:961)

    at java.lang.Thread.run(Thread.java:748)

     

    Please guide me to resolve this issue. Thank you in Advance.

  • Ramprasad Nomula
    Audit Logs14.0
    Topic posted February 6, 2018 by Ramprasad NomulaGreen Ribbon: 100+ Points, tagged ODI, Tip 
    Title:
    Audit Logs
    Summary:
    Audit Logs
    Content:

    Hi All,

     

    I want retrieve ODI session/ Audit logs , is there any automation from ODI studio(ODI 11g) to generate logs

     

    Please help me to find out