Eclipse Community Forums: DTP » Flat files in DTP?

Help

Home

Home » Eclipse Projects » DTP » Flat files in DTP?

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

Flat files in DTP? [message #45955]

Mon, 30 June 2008 17:47

Tom Brander

Messages: 30
Registered: July 2009

Member

Just within the DTP environment, I was trying to connect to a flat file
(CSV, txt) to eventually import it to a MYSQL database. The wizard
specified the folder, but never a file.. yet it said a ping succeeded... I
have what appears to be a connection but no expansion below for a file or
better yet file contents. In looking though the newsgroups and
documentation I think I'm at a non-existing path? or is there something I
can do from here? I am in a project that already has a good connection
that shows my MYSQL database...

Report message to a moderator

Re: Flat files in DTP? [message #45977 is a reply to message #45955]

Tue, 01 July 2008 22:35

Linda Chan

Messages: 845
Registered: July 2009

Senior Member

Tom,

The ODA flat file data source type defines a folder as its data source, and
a flat file as its data set. The wizard you are referring to is for
defining a data source only. With that said, I'm afraid the Flat File data
source does not support defining a data set in the DSE. It supports data
retrieval from a data set (i.e. a flat file) by an ODA-compliant consumer
application, such as BIRT. I'm not aware of an ODA consumer application
that retrieves data from an ODA data source for import to a DBMS. This
feature would be a nice contribution, if you so incline :-)

Linda

Report message to a moderator