Eclipse Community Forums: DTP » SQL Editor using ODA conx

Help

Home

Home » Eclipse Projects » DTP » SQL Editor using ODA conx - 1 attachment

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

SQL Editor using ODA conx - 1 attachment [message #40655]

Sun, 20 January 2008 16:18

Eclipse User

Originally posted by: none.none.com

Hi, All-

I'm new to DTP, and I've set up some sample Flat and JDBC ODA connections,
which all ping fine. But the SQL Editor won't allow me to select any ODA
connection to use for running an ad hoc query.

I've reviewed all the "intro" docs I can find relating to DTP, and I can't
find any info one way or the other concerning whether this should be
possible, or if not, then why.

I'm running Europa (3.3.1.1) on XP pro. Attaching a screecap of my plug-in
versions. Would someone kindly advise this newbie?

Best regards,
Elliott Wade

Attachment: dtpvers.JPG
(Size: 185.59KB, Downloaded 288 times)

Report message to a moderator

Re: SQL Editor using ODA conx - 1 attachment [message #40846 is a reply to message #40655]

Fri, 25 January 2008 00:00

Linda Chan

Messages: 845
Registered: July 2009

Senior Member

Elliott,

The SQL Editor is, as implied by its name, specific for relational databases
and SQL statements. Thus it consumes the Database (JDBC) connection profile
type only (i.e. those listed under the "Databases" category folder in the
Data Source Explorer view) .
The ODA framework is for heterogenous data sources, which are not
necessarily SQL-based.
BIRT (www.eclipse.org/birt) on the other hand is an ODA consumer
application, and thus supports any DTP ODA provider. We are adding
integration in Ganymede (DTP 1.6) to allow an ODA consumer application to
consume the "Databases" connection profile type as well.

Linda

Report message to a moderator