Export XML data to MS SQL database

[tzjamani]

Hi wakuu,

Nahitaji msaada wenu. I am planning to create a simple Java program ( .jar ) which will store its data in XML format.

I would like to access some data from XML file and export to the say MS SQL database or any other program which will be easy to make analyses of the data.
for example exporting userID, timestamp when the user logged into the system and changes made into data.
Hoping to make analyses of frequency of system access in a month, ......

Thanks for your support.

 

[kotinkarwak]

google is your best techy friend. Always do an initial search and if need further help, drop your query here....

mssql xml - Re: Storing XML files into Database (MSSQL)

You might have to stage the data first to MySQL and then migrate it into MSSQL as in following article

MySQL :: Using XML in MySQL 5.1 and 6.0


Try Kirix Strata, A data analysis/reporting tool (30 Days Full Trial). Can import xml directly if you need to skip the steps above. Has a nice timer operator that you would program to generate periodic reports depending on the data feed.

http://www.kirix.com/

 

[Kang]

Unaweza ukatengeneza program in java ambayo itaparse hiyo XML na kuspit out cvs file. Pia manually unaweza ukaimport XML file ndani ya Excel spreadsheet na kisha ukaisave kwa format yoyote unayotaka cvs etc. Kisha cvs nadhani inakuwa rahisi kuiimport into any DB.