How to programmatically change username and password of data connection
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':
When I opened this topic:
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:
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
Ted Ueda replied
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.