Export XML data to MS SQL database | JamiiForums | The Home of Great Thinkers

Dismiss Notice
You are browsing this site as a guest. It takes 2 minutes to CREATE AN ACCOUNT and less than 1 minute to LOGIN

Export XML data to MS SQL database

Discussion in 'Tech, Gadgets & Science Forum' started by tzjamani, Feb 16, 2011.

  1. tzjamani

    tzjamani JF-Expert Member

    Feb 16, 2011
    Joined: Oct 9, 2010
    Messages: 997
    Likes Received: 3
    Trophy Points: 0
    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.
  2. k

    kotinkarwak JF-Expert Member

    Feb 17, 2011
    Joined: Aug 5, 2010
    Messages: 386
    Likes Received: 1
    Trophy Points: 0
    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.

  3. Kang

    Kang JF-Expert Member

    Feb 17, 2011
    Joined: Jun 24, 2008
    Messages: 5,120
    Likes Received: 615
    Trophy Points: 280
    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.