Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: MongoDB to Oracle

  1. #1
    Join Date
    Nov 2015
    Posts
    11

    Default MongoDB to Oracle

    i have a document structure in MongoDB with nested array of objects
    {
    "_id" : ObjectId("564f9ca55fc3ca3cad383de4"),
    "deviceId" : "deviceId",
    "deviceType" : "CM",
    "cmMacAddress" : "00:00:00:00:00:00",
    "portCapacity" : 0.0,
    "make" : "CISCO",
    "model" : "CI123",
    "activationStatus" : "READY",
    "service" : [
    {
    "serviceId" : "serviceId",
    "rateCode" : "1AA",
    "type" : "DATA",
    "rank" : "1",
    "activationStatus" : "READY"
    },
    {
    "serviceId" : "serviceId",
    "rateCode" : "1AB",
    "type" : "DATA",
    "rank" : "1",
    "activationStatus" : "READY"
    }
    ]
    }


    my requirement is to update rows on oracle table . for each such document there will one entry in the device table and one or more entries in the service table. Any suggestions how to achieve the second part that is split the service array into individual objects which can be inserted into oracle SERVICE table.

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default I have a dream

    What if we invent a webservice that takes some cleverly chosen words, crawls the web, and returns links to pages that are relevant to my problem?
    There might be big money in it.

    PS: Damn it - someone already did exactly that

    So long, and thanks for all the fish.

  3. #3
    Join Date
    Nov 2015
    Posts
    11

    Default

    thanks for the link
    Last edited by sourav11b; 11-25-2015 at 02:50 PM.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.