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

  • 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

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

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

  • Navin Paremalla
    GGCC-20022: Error getting JPS credential store instance
    Topic posted October 23, 2019 by Navin Paremalla, tagged Cloud, DIPC, ODI, On-Premise 
    Title:
    GGCC-20022: Error getting JPS credential store instance
    Summary:
    Error while trying to install DIPC Agent on my linux server
    Content:

    I got all the required details from my DIPC instance and was running the ./dicloudConfigureAgent.sh. While running and after the "Enter agent IDCS Client scope" line I am facing the error GGCC-20022: Error getting JPS credential store instance.

    Code Snippet:
  • Mohan
    How to access RCU in ODI Marketplace?2
    Topic posted October 17, 2019 by Mohan, tagged ODI 
    Title:
    How to access RCU in ODI Marketplace?
    Summary:
    ODI in the marketplace comes with pre-built MySql and WLS. How do we create work repositories in a oracle DBCS.
  • Subrahmanyam Vempati
    How to Provision DIPCS?2
    Topic posted October 7, 2019 by Subrahmanyam VempatiBronze Trophy: 5,000+ Points, tagged DIPC, ODI, Provisioning 
    Title:
    How to Provision DIPCS?
    Summary:
    Provision DIPCS Instance
    Content:

    Hi Team,

    Could anyone please help to share the steps to provision DIPCS Instance.With the changes in the new OCI UI, It is getting difficult to follow oracle documentation.

    Thanks,

    Vempati

  • Frank Cruz
    Error while trying to create a connection to an oracle data...1
    Topic posted August 30, 2019 by Frank CruzRed Ribbon: 250+ Points, tagged Cloud, Data Transformation, GG, ODI, Provisioning 
    Title:
    Error while trying to create a connection to an oracle data integrator cloud service agent
    Summary:
    When trying to save a database connection associated with a data preparation agent, the following error occurs: Unable to update Oracle DB Client in GG instance with SID information.
    Content:

    After creating an instance of oracle integration cloud service 

    When trying to save a database connection associated with a data preparation agent, the following error occurs:

     In the agent log it shows the following:

    ERROR Unable to process message. The plugin ( ggmon ) which can handle this message was not configured or null on the agent. The received message is : oracle.dicloud.agent.mediator.dto.AgentMessageDTO@3c53288e : {
      "payloadType" : "oracle.dicloud.platform.common.agent.goldengate.mgmt.GGSIDConnectionPayload",
      "payload" : "{\"type\":\"goldengate\",\"name\":\"DBCLOUD\",\"host\":\"132.145.108.235\",\"port\":\"1521\",\"sid\":\"ORCL\"}",
      "msgId" : "76685cfd-d0ab-4699-8b75-4b86984309bd",
      "lastUpdateTime" : 1567179466907,
      "agentId" : "34f75c36-9643-4500-9bc7-d0f6e1167107",
      "agentInstanceId" : null,
      "msgType" : "goldengate".

    Is it necessary to have an instance of OGG to perform this configuration?

    My version is trial.

     

     

    Version:
    Oracle Data Integration Cloud Service
    Image: