Data Integration

Get Involved. Join the Conversation.

Posts

  • 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:
  • 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
  • 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:
  • 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
  • Mark Hamilton
    ODICS Linux Cloud Compute Disk Image - ADW/ATP Dataserver...
    Topic posted August 16, 2019 by Mark HamiltonGreen Ribbon: 100+ Points, tagged ODI, Provisioning 
    Title:
    ODICS Linux Cloud Compute Disk Image - ADW/ATP Dataserver Setup
    Summary:
    No Instance List
    Content:

    Hi,

    I am provisioning a ODICS instance from the Cloud Market Place.

    I have created the compute instance disk image with ODI installed on it on a Linux OS.

    I have created a Autonomous Data warehouse to load data into and connected to this with SQL Developer.

    I wish to create a data server to this ADW in ODI.

    I have created a dynamic group and policies on OCI to allow the compartment with the Linux instance to read the data warehouse.

    i am then entering a URL to setup the ADW/ATP Data server via the webapp UI but I am getting no instances to choose from.

    I am using the Linux instane hostname as the <IP address>

    Please can you help?

    I am using this guide.https://docs.oracle.com/en/middleware/fusion-middleware/data-integrator/12.2.1.3/odimp/getting-started-oracle-cloud-marketplace.html#GUID-2FE96CB3-E24A-4B76-A02E-E417B4D027E0

    from the section called, Configuring ODI for Autonomous Data Warehouse (Optional).

    Please can you help?

    Kind Regards,

    Mark

    Version:
    ODICS from the Cloud Marketplace - Linux OCI Compute Disk Image
  • 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
  • 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

  • Dragos Vilcu
    question on ODI from marketplace1
    Topic posted July 25, 2019 by Dragos VilcuRed Ribbon: 250+ Points, tagged Data Replication, Data Transformation, ODI 
    Title:
    question on ODI from marketplace
    Summary:
    multiple agents possible ?
    Content:

    as I understand ODI from marketplace comes with its own embedded repository (which is not Oracle database, but mysql).

    in such a case  is it possible to install multiple agents in various other compute instances, but using the same repository ? if yes, how exactly ?

    thank you