To create a connection cache to connect to your DB, you must go in AEM and map it to the transaction object in AEM > Application Properties >  Transaction Objects > [your application].

For more information please refer to Appeon Help - Appeon Server Configuration Guide for .NET/J2EE - AEM User Guide - Server - resource - Connection cache