Data server

[former_member331439]

Hello

I would know if anybody know the encryption algorithm of password field in table XMII_SERVERPROP (root database of MII instance)

I would create a data server connection dynamically and I'm thinking to change the data of a temporary connection in this table on the fly.

Is this the right/only possible way or not?

Thank you a lot

Best regards.

Fabio

ps: I'm using MII 12.2 sp5

[rutika_bodas]

Hi Fabio,

This is not a valid and good approach to follow.

MII caches the data server details and only updates the cache when you update the details in the data server screen or if the server is restarted. That means the changes done in the DB Table will not trigger the cache updation.

I tried this:

I created a PCo Server and saved it. Now the entries for the server details got saved in the XMII_SERVERPROP table. Server is in Green state.

Now I updated this PCo server details in the XMII_SERVERPROP table and now the status of the server should be red as I gave a wrong URL for the PCo server.

But still the server was in green state though in the server details section of the data server screen it was reflecting the changes I had manually done in the data server details.

Regards,

Rutika

[jcgood25]

I agree with you - attempting to back door the configuration database is something I'm sure everyone from solution management, to development, to global support would frown upon.

Fabio - perhaps there are some options to consider if you shared more details concerning the data server itself and what it is you're trying to do.  There are plenty of options when connecting to a database for issuing fully qualified queries, and programmatic ways to use Param.x to reformat your requests.

Regards,

Jeremy

SAP Rapid Innovation Group - RIG

[former_member331439]

Hello

My goal should be to write a fixed query and to change on the fly target database (server, instance name, username, password).

My user will write these 4 parameters in a web interface and MII will have to run the quary on the specified SQL Server DB.

I would prefer to not fix all the possible data servers in MII settings because it requires my support for each change.

Thank you

Regards

Fabio

PS: As Rutika said, table backdoor doesn't work properly