Pentaho offers JNDI connection configuration for local DI to avoid continuous running of application server during the development and testing of transformations.  Edit the properties in jdbc.propertiesfile located at...\\data-integration-server\\pentaho-solutions\\system\\simple-jndi.