Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » Flat files in DTP?
Flat files in DTP? [message #45955] Mon, 30 June 2008 17:47 Go to next message
Tom Brander is currently offline Tom BranderFriend
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...
Re: Flat files in DTP? [message #45977 is a reply to message #45955] Tue, 01 July 2008 22:35 Go to previous messageGo to next message
Linda ChanFriend
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
Re: Flat files in DTP? [message #46103 is a reply to message #45977] Wed, 02 July 2008 16:41 Go to previous message
Tom Brander is currently offline Tom BranderFriend
Messages: 30
Registered: July 2009
Member
Thanks for the reply, I'm just a real newbie so just trying to figure a
lot of the stuff out, not yet ready to try making code additions!
Re: Flat files in DTP? [message #591634 is a reply to message #45955] Tue, 01 July 2008 22:35 Go to previous message
Linda ChanFriend
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
Re: Flat files in DTP? [message #591670 is a reply to message #45977] Wed, 02 July 2008 16:41 Go to previous message
Tom Brander is currently offline Tom BranderFriend
Messages: 30
Registered: July 2009
Member
Thanks for the reply, I'm just a real newbie so just trying to figure a
lot of the stuff out, not yet ready to try making code additions!
Previous Topic:did DTP updated to ganymede?
Next Topic:[ODA Ecore]How to sort query
Goto Forum:
  


Current Time: Sun Dec 21 05:29:47 GMT 2014

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

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