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 11:14 Go to next message
akoeck is currently offline akoeckFriend
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?
Re: CSV and XML "Databases" [message #659067 is a reply to message #658643] Thu, 10 March 2011 20:57 Go to previous message
Linda ChanFriend
Messages: 845
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
Previous Topic:New Connection Profile Type
Next Topic:How can I import ModelBase package into my own application?
Goto Forum:
  


Current Time: Thu Nov 27 09:36:50 GMT 2014

Powered by FUDForum. Page generated in 0.03727 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software