Doctrine connection with db

I develop a multi-database sf2 app with doctrine2 orm mapping.

We use intellectsoft-uk/MssqlBundle

Our configuration is:

config.yml

# Doctrine Configurationdoctrine:    dbal:        default_connection: acme_mysql        connections:            acme_mysql:                host: %acme_mysql_database_host%                port: %acme_mysql_database_port%                dbname: %acme_mysql_database_name%                user: %acme_mysql_database_user%                password: %acme_mysql_database_password%                charset:  UTF8            acme_slqsrv:                driver:         sqlsrv                driver_class:   \Realestate\MssqlBundle\Driver\PDODblib\Driver                host: %acme_slqsrv%                port: %acme_slqsrv%                dbname: %acme_slqsrv%                user: %acme_slqsrv%                password: %acme_slqsrv%                charset:  UTF8orm: #optional if you want to map some entity in doctrine2    auto_generate_proxy_classes: %kernel.debug%    default_entity_manager: acme_mysql    entity_managers:        em_mysql:            connection: acme_mysql            mappings:                AcmeMysqlBundle: ~        em_sqlsrv:            connection: acme_sqlsrv            mappings:                AcmeSqlSrvBundle: ~

This configuration permit you to take a connection instance in a controller/service and use it for access database and execute stored procedures and so on...

Hope this help