I want to retrieve a list of products from an external oracle database and show it in my drupal site as a catalog. But the problem is that, how can I make the connection to oracle db from a drupal 7 site. Please any suggestion on how to perform this operation is highly welcome. Thanks!


1 Answer 1


I recommend separate this from Drupal. I mean if you just want a list of products so write an external application to prepare a xml format of this list and feed it to Drupal.

You need install PHP PDO_OCI to make connection from PHP application into Oracle.

Drupal has an Oracle Driver but I recommend external application instead

  • Thanks for your suggestion, not did it only help me to solve my problem but by using xml file I have taken away my Dbase online.Something I knew that was not secure to connect the production dbase online but was trying to find out an efficient solution... Commented Jul 19, 2012 at 2:35
  • So you need web service which you have authentication rules Commented Jul 20, 2012 at 8:21

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.