I'm trying to connect to an external data source within out intranet site. The database is Intersystems Cache. Our web-servers are running Cent OS 6.4, so I have setup the necessary unixODBC drivers to connect to it and this is successfully working. What I'm struggling to work out is how I access this data from within Drupal.
I know I could just call odbc_connect within my code, but this isn't the Drupal way. I also loose the benefits of Memcached etc.
Would it be possible to use PDO's ODBC driver, which I think Drupal uses anyway?