Data Integration

Get Involved. Join the Conversation.

Posts

  • Mohd Shahnawaz Mohd Merajuddin
    Creating Part of file while sFTP file transfer is in...
    Topic posted October 28, 2019 by Mohd Shahnawaz Mohd Merajuddin, tagged Cloud 
    Title:
    Creating Part of file while sFTP file transfer is in progress.
    Summary:
    Part files while file transfer is in process in paaS(MFT and DBCS)
    Content:

    Hi All, 

    Unlike we have a sFTP feature in HCM SaaS, where you can select an option to create a part file while sFTP file transfer is in progress, do we some a similar kind of feature in PaaS DBCS or Oracle managed file transfer.

     

    Thanks,

    Shahnawaz

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

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

  • 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