Data Integration

Get Involved. Join the Conversation.

Posts

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

  • Mark Hamilton
    DIPC Remote Agent RegistrationAnswered5
    Topic posted August 16, 2019 by Mark HamiltonGreen Ribbon: 100+ Points, tagged DIPC, ODI, Provisioning 
    Title:
    DIPC Remote Agent Registration
    Summary:
    Problem with Registration
    Content:

    Hi,

    I am trying to setup Data integration Platform Cloud.

    I am following the guide which instructs me to download the agent package from the platform. I have done this for windows.

    When I run the dicloudConfigureAgent.bat or .sh for Linux file, I am prompted for some parameters. I could not see how to add the parameters into the file, as mentioned in the guide. I enter them and the program creates an agent instance. When I go into this instance domain / folder I only see one sub-folder called, Conf, but there should be a bin sub-folder with the startAgentinstance.bat file within it. This has not been created. I expect that I have not entered some parameters properly. One guide mentions that a cloud username and password is required but I am not asked for those from the program. Please can you help? 

    Kind Regards,

    Mark

    Version:
    DIPC current Cloud version
  • Raghavendra Manchigiah
    Integration Usecase3
    Topic posted May 9, 2019 by Raghavendra Manchigiah, tagged Data Transformation, DIPC, ODI, On-Premise 
    Title:
    Integration Usecase
    Summary:
    On Prem DB to SaaS Integration
    Content:

    Dear Experts,

    We are evaluating PaaS offerings to implement the following Integration use case :

    Integrate transactional data from an On-Prem MS SQL Server DB to Fusion Cloud ERP. We expect the load to be heavy ( 150K transactions daily) and are considering ODICS to implement it . Additional requirements include field level validations before submitting payload to Fusion webservice.

    Is this doable in ODICS or is OIC recommended( There may be a need for certain amount of orchestration)

    Kindly advise

    Regards,

    Raghvendra

     

     

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

  • Mark Hamilton
    DIPC Starting Agent - Trust Store Password Issue2
    Topic posted August 19, 2019 by Mark HamiltonGreen Ribbon: 100+ Points, tagged Cloud, DIPC, GG, ODI 
    Title:
    DIPC Starting Agent - Trust Store Password Issue
    Summary:
    Error about Trust Store Password Missing
    Content:

    Hi

    When i run the start agent file command in Linux I am getting this message:

    GGCC-20046: Trust store password does not exist, use createTrustStoreUnlockPassword.

    I wonder if this is possibly a missing property or if i need to install something relating to certiificates. 

    Please can you help? Happy to raise support tickets if that is best,

    Thanks,

    Mark

    Version:
    DIPC agent download on Linux
  • Kingsley
    Can ODICS Connect to Fusion Cloud2
    Topic posted March 19, 2019 by KingsleyRed Ribbon: 250+ Points, tagged Data Replication, Data Transformation, ODI 
    Title:
    Can ODICS Connect to Fusion Cloud
    Summary:
    Connecting ODICS to Fusion Cloud
    Content:

    Hello Experts!!

    I am trying to move data from fusion cloud to PaaS DBCS. We are currently using BICC and Datasync. Can ODICS do the same? 

     

    Thanks

  • 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:
  • Dvi Chauhan
    DIPC vs ODIcs1
    Topic posted August 5, 2019 by Dvi Chauhan, tagged DIPC, ODI 
    Title:
    DIPC vs ODIcs
    Summary:
    Difference between DIPC and OCIcs
    Content:

    Hello Folks,

    Is DIPC a new way of having ODI in cloud? IS ODIcs still available to be installed in PaaS provisioned JCS?

    What is the high level difference between DIPC and ODIcs?

    Thanks

    Dvi