I would like to know if it is possible to run Connect SQL against an external database without having a class that is mapped to that database. In other words, is it possible to specify which Database rule Connect SQL runs against? So far it seems that if it is in a class that maps to a table in the Pega database, it automatically uses the connection to that database. If it is in a class mapped to an external database, then is uses the Database rule that was used to map that class. My end goal is to be able to retrieve sequence values from an external database without having to map to a table in that database.
Thank you for posting your query in the PSC. This looks like an inactive post and hence, we suggest you create a new post for your query. Click on the Write Post button here. Once created, please reply back here with the URL of the new post.
You may also refer this discussion link as a reference in the new thread.