Change password of Universe connection using Java SDK?

[Former Member]

My database administrators have a requirement that the password on all accounts must be changed every 90 days. I am fairly familiar with the Java SDK but I don't see any classes that allow me to access Universe connections and update the connection details.

Is it possible to do this using the Java SDK? Or will I be forced to write something using the universe designer COM SDK?

[Former Member]

Hi Rakesh:

We has similar requirement. Are you able to retrieve user-name, password and conneciton info. Please let us know.

[Adam_Stone]

When dealing with universes where you need to modify them, you are best to use the COM SDK.

The Java Enterprise SDK, as well as the .NET Enterprise SDK, generally only have read access to some of the properties of the universe.

[Former Member]

I actually don't need to modify a universe, I need to modify the password inside a connection object. From the Designer application, I can do this without opening or accessing any universes so the connection itself is definitely a completely separate entity from the universe.

[ted_ueda]

Hello Derek,

The SI_KIND='MetaData.DataConnection' object isn't part of the public API, unfortunately.

On the other hand, the use of the Universe Designer SDK - COM based - is fully supported.

There's risks in using the non-public API - it can change with any version or hot fix, and behavior isn't guaranteed.

Sincerely,

Ted Ueda

[Former Member]

Ted,

understading the risks of non public API and looking at the looking at the details of 'MetaData.DataConnection' , how can i get the name , Username and service of the connection

i tried to detail out the connection and got this info .

SI_HIDDEN_OBJECT=false

SI_METADATA_PROPERTIES

SI_METADATA_PROPERTIES.SI_METADATA_BVCONN_ATTRIBUTES=<CrystalReports.PropertyBag

xmlns="http://www.crystaldecisions.com/report" xmlns:xsi="http://www.w3.org/200

1/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Cry

stalReports.PropertyBag" version="2"><Property><Name>Connect</Name><Value Varian

tType="String">KEp4RXpMeDN5OHk1eXZ5SnhWeUN5P3o.eWIxelJrQXpDSnEwNXpHeDd5XHpqS3lVe

W5NZHpFeXA9ejZ5Ti15OnpSeXZ5RXkyeFQ3eVRCeW95QWt5MVpgeVN6TC5lelI6emt5RnlfTjUoYXhTe

jF5PXk3eT94Nnk3ek95QXg8VnhGeDt4Ug</Value></Property><Property><Name>NetworkLayer

</Name><Value VariantType="String">Oracle OCI</Value></Property><Property><Name>

Param</Name><Value VariantType="String">KEp4RXpMeDN5OHk1eXZ5R3poYlpweVh5VnleW3le

em1MPnk9bl95Q3pqej4xeVN5Rkx4UXpKeU95NXlveEV5TV95YHhGSVlwelZ5UT54P1tMemB6XXR5Szop

eDJ6cHpEejd6bHhTeWp4MXlzeVVyeXBleDJ6UHkzemJ3ejlbc3lcKHlMelN5MV15cHhEeEV4VnlCemhx

eUZYa3luSj15RXhQem16UXg2eT5XX0B4MmdCeTZ5XXg8eXB6VDB5OHpaelU6eEtQeWl6Vng9c3lbNXg2

R3lUeW41eEdUeVB5Mll5RHpWOVRNeWN5YXozeTVDeFd5M3k3eWdreWp6T3ldeXM8Pyl5W3lWMHlbQno0

eW55THpGej9melB4SXkxelZ5MnpRekx5U1xnMHlReTN2a1F5PHlxel16T3lCeEp6OHpULXprell4Snk.

eTJ6QXpueTp6bHhOeFR5bHhTeEx6ZXlCeER6Yy15VTl6VlB5XXlxeEF6WnlQYHpEeEd6MnlGMHlGMHk5

eEgwek0teDlyeU54N3lLeURjLXlueFAzejZ5Zw</Value></Property><Property><Name>RdmsNam

e</Name><Value VariantType="String">Oracle 10</Value></Property><Property><Name>

UseSSO</Name><Value VariantType="Boolean">0</Value></Property></CrystalReports.P

ropertyBag>

SI_METADATA_PROPERTIES.SI_METADATA_SECURITY_REFCOUNT=1

SI_METADATA_PROPERTIES.SI_METADATA_BVCONN_KIND=7

SI_METADATA_PROPERTIES.SI_METADATA_DATACONNECTION_WITHPASSWORD=0

SI_METADATA_PROPERTIES.SI_METADATA_BVCONN_USERNAME=

SI_METADATA_PROPERTIES.SI_METADATA_LAST_UPDATE_TIME=Wed Oct 01 15:21:47 EDT 2008

SI_CREATION_TIME=Wed Jul 08 14:13:43 EDT 2009

SI_GUID=AWH87B22vjlNtqcmdGmu_uY

SI_APPLICATION_OBJECT=true

SI_KIND=MetaData.DataConnection

SI_SYSTEM_OBJECT=false

SI_RUNNABLE_OBJECT=false

SI_INSTANCE_OBJECT=false

SI_PROGID=CrystalEnterprise.MetaData.DataConnection

SI_RUID=AVV_L4jQ_95JrC9v6zpDv1k

SI_UPDATE_TS=Thu Feb 12 11:06:59 EST 2009

SI_NAME=ORACLE_DOWH02_VOADMD

SI_IS_SCHEDULABLE=false

SI_CHILDREN=0

SI_INSTANCE=false

SI_ID=109532

SI_PLUGIN_OBJECT=false

SI_SENDABLE=false

SI_OWNER=g8unfs

SI_VERSIONS=1

SI_PARENT_FOLDER_CUID=AZVXOgKIBEdOkiXzUuybja4

SI_DESCRIPTION=

SI_METADATA_AUTHOR=

SI_PARENTID=123

SI_OBJECT_IS_CONTAINER=false

SI_TABLE=1

SI_OBTYPE=298

SI_PARENT_FOLDER=123

SI_CUID=AVV_L4jQ_95JrC9v6zpDv1k

SI_FLAGS=10242

SI_PARENT_CUID=AZVXOgKIBEdOkiXzUuybja4

SI_OWNERID=36597

SI_METADATA_CHILDREN

SI_METADATA_CHILDREN.SI_TOTAL=0

SI_CONNUNIVERSE

SI_CONNUNIVERSE.2=109541

SI_CONNUNIVERSE.1=109542

SI_CONNUNIVERSE.SI_TOTAL=2

SI_COMPONENT=false

[ted_ueda]

Hello Rakesh,

Trying to directly interact with the Metadata.DataConnection InfoObject is something I don't recommend at all.

The API isn't public, and what you find of the non-public methods aren't complete and untested, and using them will likely break the Connection object badly.

Speaking from experience.

Sincerely,

Ted Ueda