Sitemap
BIRT Guides, Examples and Tutorials by the BIRT community for the BIRT community. Learn how to produce great looking, web based business intelligence reports for free with open source BIRT.
BIRTReporting.com
Unit 268
372 Old Street
London
EC1V 9AU
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.
Download this guide from the members area
You need to be a member of BIRTReporting.com to download this guide.
Help us to keep producing great content
Please help promote BIRTReporting.com by Tweeting or adding a Facebook status update about us. By doing this you will be helping us to continue producing great BIRT guides and Tutorials.