I have an outside database called "panels" that stores our company articles/blog posts/products etc... in it. Is there a good module to use, or I could write a custom module to hook into the outside database to display these content types? All changes would be done through our in house system, I am only looking to display them onto the drupal site we made for our store front.
-
Just for clarification, so you have two databases? One which contains Drupal for your store front and the other outside one?– No SssweatMay 12, 2015 at 23:59
-
Or do you have 1 database that you want to be in a different location from your files folder, php, mysql etc..– No SssweatMay 13, 2015 at 0:08
-
I have 2 databases. One which is the drupal site/store front as we refer to it and the other that is separate and holds our company content that feeds 4 sites. We have the non drupal sites displaying our content, just trying to find out the best way for my drupal stores to display them.– Ben AndersonMay 14, 2015 at 0:29
-
I guess what I'm saying is one database is for products, and is the drupal store database, the other database never saves into a node but only displays, like a feed.– Ben AndersonMay 14, 2015 at 20:35
-
For anyone else interested in using an outside source to display info but not have it save in the Drupal database the best solution I found was to write your own hooks and use Views/Page Manager to display the info.– Ben AndersonMay 17, 2015 at 17:17
2 Answers
You may have some success with Migrate which will enable you to import data from an external source into a Drupal content type. You could set up a cron task to run the migration on a regular basis.
-
This seems promising, as all I really need it to do is take the data I pull into a block and then display control where it outputs through page manager or contexts. May 14, 2015 at 0:31
Maybe consider the Forena module? It is built of the idea of using SQL to get data out of a database and use XHTML and CSS to format it into web reports. Visit the Forena HowTos page for some links (near the bottom) to some live demo / showcase links.
DBMSs that are supported are the Drupal DB itself (of course), but also MySQL, Oracle, MS SQL, Postgress, Sqite, anything PDO compliant.
Disclosure: I'm a co-maintainer of Forena,
I hope this does not violate the site's policy on self-promotion.
-
Forena is something I am looking into and it may serve my needs. I will research more into this module and Migrate and see what fits our needs. May 14, 2015 at 0:32