Solved

JSON to Oracle 12c

Posted on 2013-11-08
7
993 Views
Last Modified: 2013-11-18
I have a json feed, that i would like to import into my oracle DB.

Is there a way of doing this natively with oracle 12c?

Thanks
0
Comment
Question by:FutureDBA-
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
7 Comments
 
LVL 74

Expert Comment

by:sdstuber
ID: 39634560
There is no direct json to table import method.

However, if you can convert to xml, you can use oracle's XDB functionality to read and parse it.
0
 

Author Comment

by:FutureDBA-
ID: 39634656
i can get the data in xml as well
0
 

Author Comment

by:FutureDBA-
ID: 39634667
can XDB get the xml feed from a url ?
0
Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

 
LVL 74

Accepted Solution

by:
sdstuber earned 500 total points
ID: 39634705
yes, simplest form would be do something like...


select httpuritype('http://some.domain.com/interesting_file.xml').getxml() from dual

which would read the file into an xmltype column

if you need authentication, or schema validation or service interaction then you'll need to use some of the packages to negotiate the communication.
0
 

Author Comment

by:FutureDBA-
ID: 39634718
sdstuber, yeah. before i read this i had just gotten there.

I do need to authenticate with the server.

When i used the above method. I got

ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1817
ORA-29024: Certificate validation failure
ORA-06512: at "SYS.HTTPURITYPE", line 41
29273. 00000 -  "HTTP request failed"
*Cause:    The UTL_HTTP package failed to execute the HTTP request.
*Action:   Use get_detailed_sqlerrm to check the detailed error message.
           Fix the error and retry the HTTP request.

Open in new window


Can you point me in the right direction? thanks as always
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 39634747
I can't help with the authentication piece.

As far as parsing a JSON format into Oracle, I posted this a while back.  It's not pretty but it worked in that case:
http://www.experts-exchange.com/Database/Oracle/Q_28241626.html#a39499591
0
 

Author Comment

by:FutureDBA-
ID: 39634800
both feeds json or xml would require authentication, i am looking to oracle wallet manager now to get certificates installed.
0

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
JavaScript can be used in a browser to change parts of a webpage dynamically. It begins with the following pattern: If condition W is true, do thing X to target Y after event Z. Below are some tips and tricks to help you get started with JavaScript …
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
Suggested Courses

617 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question