Connect SQL to external database
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.