Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » CSV and XML "Databases"
CSV and XML "Databases" [message #658643] Wed, 09 March 2011 06:14 Go to next message
akoeck is currently offline akoeck
Messages: 62
Registered: December 2010
Member
Hi there,

I want to know how this is working with Flat File Sources (CSV) and XML Data Sources. When I add a source, do I also get a list in the DSE with the Tables, Columns and so on?

Will I be also able to generate the DDL for the tables?


Must the CSV and XML Files follow a specific format, or can I choose this on my own?

Report message to a moderator

Re: CSV and XML "Databases" [message #659067 is a reply to message #658643] Thu, 10 March 2011 15:57 Go to previous message
Linda Chan
Messages: 840
Registered: July 2009
Senior Member
DTP supports CSV and XML data sources through the use of the ODA framework. ODA data providers support read-only access to the data; i.e. no DDL generation support.
The XML ODA provider allow users to specify the xsd of a XML data file, and will flatten selected elements into a tabular result set. The CSV one basically expects comma-separated data.
You can try them out with an ODA consumer application, such as BIRT (http://www.eclipse.org/birt).

Linda

Report message to a moderator

Previous Topic:New Connection Profile Type
Next Topic:How can I import ModelBase package into my own application?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun May 26 03:17:25 EDT 2013

Powered by FUDForum. Page generated in 0.01618 seconds