🎉 🎉 RAPIDMINER 9.10 IS OUT!!! 🎉🎉
Download the latest version helping analytics teams accelerate time-to-value for streaming and IIOT use cases.
Importing XML data from a database
Sorry if this is a repost, but I could not find the information.
I have an oracle database at hand, which I want to import. In my database, there is actually a very simple table, with some columns with metadata, and in one data column an xml structure is present, with in it all kind of information on which I want to mine after the data import.
I see that there is a read database service in rapidminer. In this service I can define a query to extract my data. I believe I can not use the read database service, as it extracts attributes 'directly' from the tables using the query. I saw that there is also a Read XML service, that allows you to use xpath to extract attributes from XML structures. This service uses a file as input, not a database. So my question is, how does the process look like in rapid miner that extracts an xml from the database, and then extracts the attributes out of the xml? Directly connecting the read database with the read xml gives 'Expected FileObject but received ExampleSet', which makes sense.
Thanks for your answer!