| Need help regarding specifying database usename and password in template(URGENT) [message #118706] |
Fri, 27 January 2006 09:02  |
Eclipse User |
|
|
|
Originally posted by: er.vikas.rediffmail.com
hi all,
We are using birt report engine to generate the reports. We have
deployed report engine in jboss server. We created some design templates
using eclipse BIRT designer and are using these templates for the report
generation. Before giving the template to the BIRT report engine we need
to change the database username and password programmatically.
The database username and password
and other information is read from the configuration file. We are creating
a temporary design file from the original template that will contain the
database information read from the config file. This temp design is going
to the BIRT report engine for the report generation.We are able to replace
the information related to the database except the password as it is
encrypted.
So we now need to encrypt the password according to the BIRT algorithms.
Are there some api's by which we can get the enrypted password so that we
can replace it in the design template.
It is very urgent, please provide any solution ASAP.
Thanks in advance,
Regards,
Vikas
|
|
|
| Re: Need help regarding specifying database usename and password in template(URGENT) [message #119105 is a reply to message #118706] |
Fri, 27 January 2006 14:26  |
| Eclipse User |
|
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_033F_01C62334.78B558A0
Content-Type: multipart/alternative;
boundary="----=_NextPart_001_0340_01C62334.78B558A0"
------=_NextPart_001_0340_01C62334.78B558A0
Content-Type: text/plain;
charset="iso-8859-15"
Content-Transfer-Encoding: quoted-printable
Vikas,
See if these posts answers your questions.=20
regards,
--=20
Gary Xue
Actuate Corporation - Product Development
BIRT Committer
"Vikas" <er.vikas@rediffmail.com> wrote in message =
news:99596c4635c565605883ee80e8a6b795$1@www.eclipse.org...
> hi all,
> We are using birt report engine to generate the reports. We have=20
> deployed report engine in jboss server. We created some design =
templates=20
> using eclipse BIRT designer and are using these templates for the =
report=20
> generation. Before giving the template to the BIRT report engine we =
need=20
> to change the database username and password programmatically.=20
> The database username and =
password=20
> and other information is read from the configuration file. We are =
creating=20
> a temporary design file from the original template that will contain =
the=20
> database information read from the config file. This temp design is =
going=20
> to the BIRT report engine for the report generation.We are able to =
replace=20
> the information related to the database except the password as it is=20
> encrypted.
>=20
> So we now need to encrypt the password according to the BIRT =
algorithms.=20
> Are there some api's by which we can get the enrypted password so that =
we=20
> can replace it in the design template.
>=20
> It is very urgent, please provide any solution ASAP.
>=20
> Thanks in advance,
>=20
> Regards,
> Vikas
>=20
>
------=_NextPart_001_0340_01C62334.78B558A0
Content-Type: text/html;
charset="iso-8859-15"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-15">
<META content=3D"MSHTML 6.00.2800.1528" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV><FONT face=3DArial size=3D2>Vikas,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>See if these posts answers your =
questions.=20
</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>regards,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT><BR><FONT face=3DArial =
size=3D2>-- <BR>Gary=20
Xue<BR>Actuate Corporation - Product Development<BR>BIRT =
Committer</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>"Vikas" <</FONT><A=20
href=3D"mailto:er.vikas@rediffmail.com"><FONT face=3DArial=20
size=3D2>er.vikas@rediffmail.com</FONT></A><FONT face=3DArial =
size=3D2>> wrote in=20
message </FONT><A=20
href=3D"news:99596c4635c565605883ee80e8a6b795$1@www.eclipse.org"><FONT =
face=3DArial=20
size=3D2>news:99596c4635c565605883ee80e8a6b795$1@www.eclipse.org</FONT></=
A><FONT=20
face=3DArial size=3D2>...</FONT></DIV><FONT face=3DArial size=3D2>> =
hi all,<BR>>=20
We are using birt report engine to generate the reports. We have =
<BR>>=20
deployed report engine in jboss server. We created some design templates =
<BR>> using eclipse BIRT designer and are using these templates =
for the=20
report <BR>> generation. Before giving the template to the BIRT =
report engine=20
we need <BR>> to change the database username and password =
programmatically.=20
<BR>>=20
&=
nbsp; & nbsp; & n=
bsp; &n bsp; &n b=
sp;=20
The database username and password <BR>> and other information is =
read from=20
the configuration file. We are creating <BR>> a temporary design file =
from=20
the original template that will contain the <BR>> database =
information read=20
from the config file. This temp design is going <BR>> to the BIRT =
report=20
engine for the report generation.We are able to replace <BR>> the =
information=20
related to the database except the password as it is <BR>> =
encrypted.<BR>>=20
<BR>> So we now need to encrypt the password according to the BIRT=20
algorithms. <BR>> Are there some api's by which we can get the =
enrypted=20
password so that we <BR>> can replace it in the design =
template.<BR>>=20
<BR>> It is very urgent, please provide any solution ASAP.<BR>> =
<BR>>=20
Thanks in advance,<BR>> <BR>> Regards,<BR>> Vikas<BR>> =
<BR>>=20
</FONT></BODY></HTML>
------=_NextPart_001_0340_01C62334.78B558A0--
------=_NextPart_000_033F_01C62334.78B558A0
Content-Type: message/rfc822;
name="Re_ BIRT connection handling during deployment.nws"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
filename="Re_ BIRT connection handling during deployment.nws"
Path: utils.eclipse.org!not-for-mail
From: "Gary Xue" <gxue@actuate.com>
Newsgroups: eclipse.birt
Subject: Re: BIRT connection handling during deployment
Date: Fri, 20 Jan 2006 12:26:36 -0800
Organization: Actuate
Lines: 48
Message-ID: <dqrgvb$hjt$1@utils.eclipse.org>
References: <63e9823a793e111d451a72f810385002$1@www.eclipse.org>
NNTP-Posting-Host: 65.213.51.218
X-Trace: utils.eclipse.org 1137788715 18045 65.213.51.218 (20 Jan 2006 20:25:15 GMT)
X-Complaints-To: news@utils.eclipse.org
NNTP-Posting-Date: Fri, 20 Jan 2006 20:25:15 +0000 (UTC)
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1506
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506
Xref: utils.eclipse.org eclipse.birt:4918
I have a couple of suggestions:
(1) Externalize the connection information. The idea is to store the
connection info in an external data store (a properties file, environment
variables, registries, Java system properties etc. etc.). In your BIRT
report, override the runtime connection properties using either Data Source
property binding (which binds connection properties to Javascript
expressions that are hooked up to your custom code to read the values from
the external file/store), or use BIRT scripting (where you override the
connection properties in the beforeOpen event of the data source). The
advantage here is that you can deploy identical reports to all sites,
assuming that only connection info differs among them.
(2) Write a batch program to do the update. It's quite straighforward to use
the BIRT Design Engine (DE) API to open report designs and update connection
property values.
If none of these works well for you, feel free to file a Bugzilla
enhancement to explain your exact use case and what you see as the best way
to meet the needs.
regards,
--
Gary Xue
Actuate Corporation - Product Development
BIRT Committer
"Aric" <acraciun@everstream.com> wrote in message
news:63e9823a793e111d451a72f810385002$1@www.eclipse.org...
> Hello again, Folks -
>
> I have a question about recommended ways to deploy BIRT Reports for
> multiple customers. What I'd like to do is have an easy way to change the
> connection information depending on what customer I'm deploying to without
> having to manually go into each rptdesign file to change that (or though
> the developer tool in eclipse) as we have hundreds of sites.
>
> For example, Cognos has a screen that lets you change the connection
> information for each report deployment in a single spot for the whole
> group of reports.
>
> So here are my questions:
> 1.) Is there a recommended way for achieving something like this.
> 2.) If not, are there any plans to build this sort of functionality?
> should I log an enhancement request?
>
------=_NextPart_000_033F_01C62334.78B558A0
Content-Type: message/rfc822;
name="Re_ Storing DB password outside .rptdesign file.nws"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
filename="Re_ Storing DB password outside .rptdesign file.nws"
Path: utils.eclipse.org!not-for-mail
From: "Gary Xue" <gxue@actuate.com>
Newsgroups: eclipse.birt
Subject: Re: Storing DB password outside .rptdesign file
Date: Tue, 17 Jan 2006 17:41:59 -0800
Organization: Actuate
Lines: 40
Message-ID: <dqk6am$aaq$1@utils.eclipse.org>
References: <dqjsj8$t1u$2@utils.eclipse.org>
NNTP-Posting-Host: 65.213.51.218
X-Trace: utils.eclipse.org 1137548438 10586 65.213.51.218 (18 Jan 2006 01:40:38 GMT)
X-Complaints-To: news@utils.eclipse.org
NNTP-Posting-Date: Wed, 18 Jan 2006 01:40:38 +0000 (UTC)
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1506
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506
Xref: utils.eclipse.org eclipse.birt:4758
For question (1) - you can use Scripting to supply the DB password for a
JDBC data source at runtime. The script code (it can be in Java or
Javascript) you provide can read the password from any external file or data
store. To do this, first define the data source (use an empty or dummy
password). Then provide either a Java or Javascript implementation for the
data source's beforeOpen() event. In the script handling code, set the
extersion property named "odaPassword" to the externally read password
value.
For question (2) - the out-of-the-box ODA-JDBC driver does not support using
JNDI data sources. However it should not be difficult for one to write a ODA
driver (which extends the ODA-JDBC driver) to use a customer JDBC data
source. There is an entry in the BIRT World blog that's a pretty good
tutorial on this:
http://birtworld.blogspot.com/2005/12/using-supplied-connect ion-with-birt.html
regards,
--
Gary Xue
Actuate Corporation - Product Development
BIRT Committer
"Calin Medianu" <user@example.net> wrote in message
news:dqjsj8$t1u$2@utils.eclipse.org...
> Hello,
>
> 1) When using a JDBC data source, is it possible to store the DB
> password in a properties file instead of the .rptdesign file?
>
> 2) When using the web viewer is it possible to use a JNDI pooled
datasource?
>
>
> Thanks,
>
> Calin
------=_NextPart_000_033F_01C62334.78B558A0--
|
|
|
Powered by
FUDForum. Page generated in 0.06850 seconds
Home