1. Miguel Alzate
  2. PowerServer 2020 or older (Obsolete)
  3. Saturday, 6 May 2023 20:31 PM UTC

Greetings to the entire community!

I have a web application on PS2020 that receives as arguments the parameters of the database to which the application must connect. The database may vary depending on the scenario from which the application is invoked. The question is:

Considering that they can be different, which database will the application connect to: the one that is sent in the arguments or the one assigned to the application in AEM?

Note: Of course, both DB parameters (arguments' and AEM's) are assigned to SQLCA.

In advance, thank you very much for your help.

Accepted Answer
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Saturday, 6 May 2023 21:07 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # Permalink

Hi Miguel;

  The PS middle tier is doing all the DBMS connectivity and basically ignores all your SQLCA settings. What it will check for though is in your DBParm setting for the keyword "CacheName=xxxxxxx". 

  The CacheNames is PS are then each mapped to a specific DB instance. Thus, your App can have each App User instance connect to it's dependant DB instance by setting the CacheName value accordingly.  HTH

Regards ... Chris 

  1. Miguel Alzate
  2. Saturday, 6 May 2023 21:42 PM UTC
Hello, Chris. Thanks for you answer!

In what you mentioned in you reply, does the 'xxxxxxx' value of the CacheName correspond to a name of a Data Source in AEM?
  1. Helpful
  1. Chris Pollach @Appeon
  2. Saturday, 6 May 2023 22:26 PM UTC
  1. Helpful
  1. Miguel Alzate
  2. Saturday, 6 May 2023 23:05 PM UTC
Great! Thanks again.
  1. Helpful 1
There are no comments made yet.

There are replies in this question but you are not allowed to view the replies from this question.