|db vs oda connectivity for reports [message #589466]
||Thu, 20 December 2007 22:54
| Cameron Taggart
Registered: July 2009
I've been trying to produce reports using BIRT and CR4E (Crystal Reports for Eclipse). Both BIRT and CR4E (as of 1.0.4) |
support establishing database connections through the Data Tools Platform in Eclipse 3.3. I simply want to connect to a
Sybase ASA database via JDBC.
Ideal Use Case:
* Open up the Data Source Explorer
* Select the Data Source Type: JDBC Data Source
* Select JDBC Driver Name: Sybase
(see DbVisualizer's Driver Manager)
* Enter details: Name, Database URL, User Name, Password
* Then in BIRT & CR4E, I could use the data source, selecting it by name.
Current Situation with CR4E:
It appears to be using "org.eclipse.datatools.connectivity.db". In the Data Source Explorer, I right click on
"Databases" and select "New...". After creating a New Connect Profile, I can use it from CR4E. The *blocking* problem
I have right now is the lack of support from Data Source Explorer for getting column information for tables in Sybase
Current Situation with BIRT:
It appears to be using "org.eclipse.birt.report.data.oda". I don't think it can use the data source connection that I
created above. One would think it should be able to. I haven't got this working yet, but I think I have to create a
"BIRT JDBC Data Source", then export the connection profile to an xml file somewhere on the file system (via an absolute
path), then in BIRT's Report Designer, I can create a "Data Source" by specifying the location of the file and
connection profile name in a couple of properties. It would be nice if only the Connection Profile name was needed.
Exporting stuff to a xml file somewhere on the file system seems completely unnecessary.
Why is the difference between the "db" and "oda" packages? Is that now a uniform way for defining JDBC data sources
within the Data Tools Platform?
I would really like to find a fix or work-a-round for the Sybase ASA issue. If any of the DTP folks from Sybase wish to
contact me directly, please do so.
Powered by FUDForum
. Page generated in 0.01426 seconds