Data Integration

Get Involved. Join the Conversation.

Posts

  • 1-9 of 9
  • Subrahmanyam Vempati
    ODI-Read files from SFTP Server25.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
  • Nathaniel Vadde
    How to Integrate two instances on Oracle Cloud2
    Topic posted September 5, 2019 by Nathaniel Vadde, tagged Tip 
    Title:
    How to Integrate two instances on Oracle Cloud
    Summary:
    How to Integrate two instances on Oracle Cloud
    Content:

    We have two instances on Oracle Cloud, on one instance we have linux and Oracle database installed on it, and on the other instance we installed Windows Server. We are not able to communicating between linux instance and windows server instance in Oracle Cloud. We are successfully communicating between On-Premise Oracle database using RMI with other application installed on Windows Server. But the same thing is not happening on Oracle Cloud.

    Both Linux Instance and Windows Server instance are in the same region and same Virtual Cloud Network (VCN). The public IP and Private IP's of these two instances are different.
    We have defined ingress rules with source IP and destination port. 

  • David Tran
    Can OIC poll for file creating in FTP directory?5
    Topic last edited March 11, 2019 by Arijit ChakrabortyBronze Trophy: 5,000+ 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!

  • Swathi gogula
    Delete archive option1
    Topic last edited November 13, 2018 by Arijit ChakrabortyBronze Trophy: 5,000+ 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

     

     

  • Lavanya Kumar K
    Any sample HDL data on Goal AlignmentAnswered15.0
    Topic last edited October 22, 2018 by Arijit ChakrabortyBronze Trophy: 5,000+ 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

  • Nagesh Nadimatla Ext
    Redshift Data server connectivity issue with standalone...85.0
    Topic last edited August 23, 2018 by Arijit ChakrabortyBronze Trophy: 5,000+ 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.

  • Vasanth Mareedu
    When ODICS certification will be released?15.0
    Topic last edited July 31, 2018 by Arijit ChakrabortyBronze Trophy: 5,000+ Points, 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?

  • Ramprasad Nomula
    ODI Package14.0
    Topic last edited July 31, 2018 by Arijit ChakrabortyBronze Trophy: 5,000+ 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
    Audit Logs14.0
    Topic last edited July 12, 2018 by Arijit ChakrabortyBronze Trophy: 5,000+ 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