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?

  • Subrahmanyam Vempati
    ODI-Read files from SFTP Server75.0
    Topic posted October 17, 2019 by Subrahmanyam VempatiBronze Trophy: 5,000+ Points, tagged Cloud, ODI, Tip 
    Title:
    ODI-Read files from SFTP Server
    Summary:
    ODI-Read files from SFTP Server
    Content:

    Hi ,

    We want to read the files from SFTP server and process in ODI. Is there any way we can read the file content directly , Instead of loading it in local folder and process.

    Thanks,

    Vempati

    Version:
    ODI 12c
  • 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.