Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to programmatically change username and password of data connection

Hello

Crystal Reports 2008 Dev

Crystal Reports Server 2008

I would like to be able to modify the database username and password of a Data Connection.

This query returns the Data Connection data:

select 
*
from ci_appobjects 
where SI_KIND = 'MetaData.DataConnection'

What I am intereseted in changing are the 'fields':

SI_METADATA_PROPERTIES.SI_METADATA_BVCONN_USERNAME

and

SI_METADATA_PROPERTIES.SI_METADATA_BVCONN_PASSWORD

When I opened this topic:

Link:Automatically assign db logon to DC, DF, BE, BV or LOV

The consensus was that it is possible to write a program that would scan through the repository and change the username and passwords of Data Connections

I have now found this topic:

Link:Change password of Universe connection using Java SDK?

And it seems to says that the 'properties' of the Data Connectons that I need to change are not visible to API, and therefore are only changeable via COM SDK

(on Diamond SDK reference there is no info attached to the COM SDK links - the chm files have nothing in them)

Is it possible to change the data in the USERNAME and PASSWORD fields?

Ideally I would like to do it thru Java, but any method at all would suffice at this stage.

Best regards and thanks

Patrick Coote

replied

Hello Patrick,

Here's more info:

1. The Enterprise Java SDK InfoObject class for the MetaData.DataConnection SI_KIND isn't part of the public API.

2. The Universe Designer SDK (look in http://boc.sdn.sap.com/developer/library) is the COM-based SDK that allows to you configure Connection information for Universes.

3. If you want to modify Connection for Business Views, then there are no public SDKs that will allow you to do that.

Sincerely,

Ted Ueda

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question