Thread: Convert an XML database
I want to set up a new PostgreSQL database from an XML database file. It seems like there should be an obvious way to dothis but I can't seem to find any directions anywhere. How is this sort of thing normally done? The database is available to the public here: http://www.drugbank.ca/downloads#full -- Aram
On 5/20/2014 9:16 PM, Aram Fingal wrote: > I want to set up a new PostgreSQL database from an XML database file. It seems like there should be an obvious way todo this but I can't seem to find any directions anywhere. How is this sort of thing normally done? you'd need some sort of tool that could parse the XSD schema definition and generate SQL create table commands, then read the XML data and insert it into the database. a generic ETL (extract, transform, load) tool that supports XML and postgresql should be able to do it, but its not something built into postgresql as-is. I can't recommend any specific ETL tool to do this as I've never needed to do this exactly. there's some ETL tools listed here, http://en.wikipedia.org/wiki/Extract,_transform,_load -- john r pierce 37N 122W somewhere on the middle of the left coast
> > a generic ETL (extract, transform, load) tool that supports XML and postgresql should be able to do it, but its not somethingbuilt into postgresql as-is. I can't recommend any specific ETL tool to do this as I've never needed to do thisexactly. Thanks. That at least tells me that I am not missing something which would make this really easy. -Aram
On 05/21/2014 08:03 AM, Aram Fingal wrote: >> >> a generic ETL (extract, transform, load) tool that supports XML and postgresql should be able to do it, but its not somethingbuilt into postgresql as-is. I can't recommend any specific ETL tool to do this as I've never needed to do thisexactly. > > Thanks. That at least tells me that I am not missing something which would make this really easy. The other thing to keep in mind is this note at the link you provided: "The XML schema is currently in beta and is likely to change in the coming weeks." > > -Aram > -- Adrian Klaver adrian.klaver@aklaver.com