Eclipse Community Forums: DTP » CSV and XML "Databases"

Help

Home

Home » Eclipse Projects » DTP » CSV and XML "Databases"

Show: Today's Messages :: Show Polls :: Message Navigator

CSV and XML "Databases" [message #658643]

Wed, 09 March 2011 11:14

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 20:57

Linda Chan

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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jun 20 08:07:28 GMT 2018

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter