BIRT Connection Profiles

Business Intelligence and Reporting Tools

A resource for the BIRT user community

The award winning

Dev-Share
Contribution
Award

BIRT for Beginners Readers Area

BIRTReporting Members Area

Change Password

Database connections the easy way!

OK hands up if you have a rubbish memory like me! OK there are a number of things I can remember, like my wifes birthday, our wedding anniversary and other such things that are essential to survival but there are certain things that I simply can’t (or maybe don’t want to) keep in my head.

One example of this is the JDBC connection string for SQL Server databases that I use within my BIRT data sources. You know the thing that looks like this:

jdbc:jtds:sqlserver://server[:port][/database];

Ultimately this means that every time I create a new BIRT report I have to create a new data source and lookup the connection string from one of my own texts on the subject. This makes me feel rather silly and so I eventually resorted to keeping a text file on the desktop of my BIRT machine, containing just the connection string! This way I can easily access the connection string and copy it into my report.

Well, I have found a better way! It’s called Connection Profiles and it allows you to store away connections to all your databases, including the login credentials, in a central location that can be accessed directly from within the BIRT designer whenever you need them.

To access this report with full step by step instructions and screeenshots in downloadable pdf format please signup for your free site membership here.

BIRT Connection Profiles

BIRT Books

Get the most out of BIRT with this fabulous selection of books to help you achieve expert status in no time!

BIRT User Group

Meet us in person and join the community. The BIRT User Group (UK) welcomes all our UK based BIRT users.

Survey

Please take 5 minutes to complete my survey. I will use the responses to improve this web site and make it more relevant to the user community. Your answers will be very valuable in improving this site and your details will not be shared with any third party. I will however publish a summary of the results for all my members to see on this site.