Data Integration

Get Involved. Join the Conversation.

Posts

  • 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

  • Bjain
    Merge datapump files5.0
    Topic posted February 5, 2018 by Bjain  
    Title:
    Merge datapump files
    Summary:
    Merge datapump files
    Content:

    Hi ,

    I have a requirement to export and later import table partitions using dbms_datapump API. Going by the standard process, this will create separate .dmp and .log files for each partition.

    However, we want all these partitions to be created in a single .dmp and .log file. For example:

    Table T1 has partitions P1, P2 and P3

    Normal approach --> dbms_datapump API call ---> P1.dmp, P2.dmp and P3.dmp (corresponding log files as well)

    To be achieved ---> dbms_datapump API calls ----> Consolidated one dump file for (P1,P2,P3) and one log file.

    I tried EXCLUDE partitions as well, but that also did not work.

    Any helpful tips/leads are welcome.

    Thanks

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