Hello,
I'm tryng to automate process to insert and update entries in RDM by JSON import.
I have issues with SAP GUI AddOn because I can create the connection but the configuration seems to be in the
"AddOn": {
"CompressedProperties": "................................."
}
Is there some documentation about this field or is there a way to setup SAP GUI connection in the JSON or XML with uncompressed or unencrypted fields?
RDM version is 2025.2.14.0.
Regards
Alessio
Hello,
This is not an easy task since it's using our legacy add-on structure with dynamic fields compression. I will verify if it's possible to access those fields with PowerShell, but I'm not even sure that it's supported.
Regards
David Hervieux
Hi,
I have used Get-RDMEntry to retrieve sap gui entry, and i Addon filed there is field Properties with XML configuration of entry and looks like:
Properties : <?xml version="1.0" encoding="utf-8"?>
<SAPGuiConfiguration>
<AutomationCommand />
<AutomationTitle />
<CustomLogonGroup />
<CustomSapRouterString />
<CustomServer>hostxxx</CustomServer>
<CustomSID>PRD</CustomSID>
<CustomSystemNr>00</CustomSystemNr>
<CustomUseLogonGroup>false</CustomUseLogonGroup>
<CustomWAN>false</CustomWAN>
<EncryptedPassword>**************</EncryptedPassword>
<IsCustomConnection>true</IsCustomConnection>
<LogonClient />
<LogonLanguage />
<LogonTracelevel />
<LogonUserName>admin</LogonUserName>
<MaximizeGui>false</MaximizeGui>
<SapConnectionName />
<SapConnectionTag>0</SapConnectionTag>
<SapLogonConnectionInternalName />
<SapLogonIniFile></SapLogonIniFile>
<ShowCommandLine>false</ShowCommandLine>
<SncName />
<SncOptions />
</SAPGuiConfiguration>
I have additional question is it possible to decrypt from xml field "EncryptedPassword" or retrieve password other way from SAP GUI entries in PowerShell?
PS. With Convert-XMLToPSCustomObject it is possible to convert xml to PSObject change/set values and than using Convert-PSCustomObjectToXML convert back to xml. Example:
$entry=Get-RDMEntry -ID "<<GUID>>" $fromxml = $sap.AddOn.Properties|Convert-XMLToPSCustomObject $fromxml.SAPGuiConfiguration.CustomServer='<<new host name>>' $xml= $fromxml|Convert-PSCustomObjectToXML $entry.AddOn.Properties=$xml.OuterXml Set-RDMEntry $entry