Different Datasource Possibilties

Hello,

i would like to use BIRT to generate Reports. I have to use some data fields from some databases.

The problem is, that the current software architecture is based on CORBA. Within from CORBA there are complex SQL-Querries integrated with logic to the database. The way over a JDBC database-connection is therefore unsuitable.

In CORBA there are connection-interfaces implemented, in order to connect to the database. That is the only usefull way to connect the db.

My question is, how can i use this corba connection in BIRT? Which possibities exist to connect a system (except JDBC in my case)? Is it possibe to programm my own corba driver?

It would be a pleasure hearing from you some hints.

Thank you
Martin

Find more posts tagged with

Comments

Virgil Dodson

Hi Martin,<br />
<br />
BIRT supports all sorts of data sources out-of-the-box, like JDBC, flat files, XML, web services, ... and one called scripted data source. This scripted data source allows you to connect to anything you could normally connect to in Java. There a several examples in the DevShare on BIRT Exchange if you search for <a class='bbc_url' href='http://www.birt-exchange.org/devshare/?filtercontent=scripted&contenttype=-1&date=-2year&rating=0&results=10&cid=0'>'scripted'</a><br />
<br />
If you plan to do this more than a couple times... or you want to provide a better interface or data browser for others to create reports from your data, then you can create a custom data driver for BIRT. BIRT uses the Open Data Access (ODA) framework which exposes extension points for you to add your own data connector plug-in into BIRT. There are project wizards to create a new ODA plug-in.