topic Re: SAS Metadata Server connection Update in Administration and Deployment

SAS Metadata Server connection Update

411752 — Wed, 31 May 2023 18:02:11 GMT

I have a requirement to update metadata from the Server information option in connections, this need to be switched back and froth due to maintenance , is there any code/automatic option for this , that I can schedule on the required time?

Re: SAS Metadata Server connection Update

gwootton — Wed, 31 May 2023 18:58:37 GMT

Yes, you could write code to modify a servers connection information in Metadata rather than editing the values manually in SAS Management Console if that's what you mean. I don't know that such code already exists. Can you be more specific about what it is you're trying to change?

Re: SAS Metadata Server connection Update

411752 — Wed, 31 May 2023 19:13:50 GMT

@gwootton : Yes, thats the code I am looking for.

I wanted to change the database connection server information from below window under the Server Manager->Database servers->Connection ->options

Re: SAS Metadata Server connection Update

gwootton — Thu, 01 Jun 2023 20:58:19 GMT

That information (Host, Server, Port) for a Sybase IQ connection is held in Property objects associated with the connection. So for a server called "Sybase IQ 1", the URI for those properties would be:

obj="omsobj:Property?Property[@Name='Connection.DBMS.Property.SERVER.Name.xmlKey.txt'][AssociatedObject/SASClientConnection/Source/ServerComponent[@Name='Sybase IQ 1']]";
obj="omsobj:Property?Property[@Name='Connection.DBMS.Property.HOST.Name.xmlKey.txt'][AssociatedObject/SASClientConnection/Source/ServerComponent[@Name='Sybase IQ 1']]";
obj="omsobj:Property?Property[@Name='Connection.DBMS.Property.NPORT.Name.xmlKey.txt'][AssociatedObject/SASClientConnection/Source/ServerComponent[@Name='Sybase IQ 1']]";

You could use METADATA_SETATTR to update the DefaultValue attribute for these objects to change them.

METADATA_SETATTR Function
https://go.documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/lrmeta/n0t9rzceun8o14n0zi8a1hfls9h7.htm

Re: SAS Metadata Server connection Update

411752 — Thu, 01 Jun 2023 21:45:17 GMT

@gwootton : Thank you!. I have updated the 'Sybase IQ 1' to my server, host and port numbers and used metadata_getattr function but they are returning "-3" , is there any other steps, I need to take care to be able to find them?.

I see these entries in the PROP dataset from metadata server repository which are matching with the information I have updated.

Re: SAS Metadata Server connection Update

gwootton — Fri, 02 Jun 2023 14:43:12 GMT

You would change "Sybase IQ 1" to the name of your Sybase server in Metadata for all three queries. You would not put the host or port there. This URI translates as the property called "Connection.DBMS..." that is associated with the connection that is associated with the server called "Sybase IQ 1".

A -3 means the URI does not return any results.

Re: SAS Metadata Server connection Update

411752 — Mon, 05 Jun 2023 18:47:44 GMT

Thank you @gwootton : It worked for me. I also have Authdomain, can you also suggest the URI to use for AuthDomain update?.

Re: SAS Metadata Server connection Update

gwootton — Mon, 05 Jun 2023 19:02:47 GMT

An authentication domain is an association instead of a property so you'd need to use METADATA_SETASSN to set the association to one authentication domain versus another. In this case you would need two URIs, the URI of the AuthDomain and that of the connection to associate.

The URI of the connection:
omsobj:SASClientConnection?SASClientConnection[Source/ServerComponent[@Name='Sybase IQ 1']]"

The URI of the AuthDomain:
omsobj:AuthenticationDomain?AuthenticationDomain[@Name='DefaultAuth']

You'd use the REPLACE mod for METADATA_SETASSN on the Domain association of the connection URI.

METADATA_SETASSN Function
https://go.documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/lrmeta/p1pt2ddn2xhmaen1p5whdq58ithh.htm