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

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

CSV and XML "Databases" [message #658643]

Wed, 09 March 2011 06:14

Eclipse User

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

Eclipse User

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:

-=] Back to Top [=-

Current Time: Tue Jul 08 14:55:37 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter