Data Integration

Get Involved. Join the Conversation.

Posts

  • 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

  • Gunapareddy Kishore
    While Loading assignment details through HSDL we are getting...65.0
    Topic posted August 30, 2018 by Gunapareddy KishoreBronze Medal: 1,250+ Points 
    Title:
    While Loading assignment details through HSDL we are getting error
    Summary:
    Error: Work terms records are required when you create or update assignments
    Content:

    Hi,

    We are trying to update the assignment details through HSDL we have added the required columns but while it's importing the data we are getting the below error

     

    Error:Work terms records are required when you create or update assignments
     

    Regards,

    Kishore

    Image:
  • 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

  • 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

  • Kmgrime
    HCM tiles/homepages copying over to Campus Solutions3.5
    Topic posted January 17, 2018 by Kmgrime  
    Title:
    HCM tiles/homepages copying over to Campus Solutions
    Summary:
    HCM tiles/homepages copying over to Campus Solutions
    Content:

    Why do my tiles carry over from HCM to Campus Solutions in the 8.55 environment? What permissions allow seeing these tiles and how can I take them off? Also the tiles do not work in Campus Solutions and not in HCM. Why is this?

  • Lavanya Kumar K
    Any sample HDL data on Goal AlignmentAnswered15.0
    Topic posted August 28, 2018 by Lavanya Kumar KGold Medal: 3,500+ Points, tagged Tip 
    Title:
    Any sample HDL data on Goal Alignment
    Summary:
    Any sample HDL data on Goal Alignment
    Content:

    Can anyone please provide sample HDL data on goal alignment

  • Ankur Agarwal
    Load Pending Worker through HDL15.0
    Topic posted September 7, 2018 by Ankur AgarwalBronze Crown: 15,000+ Points 
    Title:
    Load Pending Worker through HDL
    Summary:
    Load Pending Worker through HDL
    Content:

    Hi All,

    Can anyone send me the sample HDL dat file to upload pending worker in Fusion?

    Thanks,

    Ankur

     

     

    Version:
    Fusion R13
  • Vivek R S
    Import Questions via HDL15.0
    Topic posted August 28, 2018 by Vivek R SBronze Medal: 1,250+ Points 
    Title:
    Import Questions via HDL
    Summary:
    Import Questions via HDL
    Content:

    Hi,

     

    Can someone please help on how to upload Questions (For Questionnaire) through HDL in Fusion?

     

    Regards,

    Vivek R S

  • 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.

  • Athena Chou
    Request a sample script to import data into ERP CLOUD from...15.0
    Topic posted August 14, 2018 by Athena Chou, tagged Cloud, On-Premise 
    Title:
    Request a sample script to import data into ERP CLOUD from On-Premise EBS
    Summary:
    Request a sample script to import data into ERP CLOUD from On-Premise EBS
    Content:

    Hi,

    Could you provide a very simple script or store procedure to show how to call webservice to import data into ERP Cloud from EBS?

    For example, user maintain supplier master data in EBS, and we would like to sync this data to ERP Cloud.

    Another question, is there any extra configration for EBS if we use store procedure to call WebService?

    Thank you

    Athena

     

    Code Snippet: