Second Tutorial: What is VDC module in Drupal7

Most of the time we may connect to External database with Drupal 7, but how we can utilize the data of External database in the project.

Here the steps follow to achieve the same.

1. Go to Url : https://www.drupal.org/project/views_database_connector and download the module.
2. Install the module as usual.
3. go to settings.php file and add external database credentials as i explained in my previous tutorial.
4. Go to View and click on add New views.
5. Under Show drop down , we will get list of external database tables which we added using settings.php follow by VDC as prfix.
6. Now we can Manipulate the data's with Views options, all options of views are suits for the selected table.

Cool,, now we know what is VDC module in Drupal7.

Questions and thoughts on this tutorial are welcome to make this more Meaning and useful for Drupal developers.

How to Connect External Database in Drupal7

We have seen lots of tutorial which will explain a features as story and make us sleep before complete half of the article or blog, but in my tutorials I am going to follow only important notes and hints, also if any user have doubt after reading completely my tutorial they can rise a questions on  the same.

In this tutorial we are going to learn how to connect drupal7 with external database, in next tutorial i will introduce what we can do with external database data's.

Steps to be followed to achieve the task.

1. Install fresh drupal7 or we can use already installed drupal7. I am going to skip this process coz tons of tutorial already available for the same.
2. After installed open settings.php file from below path using any favorite text editor,
    path: www\your_site_name\sites\default
3. Go to line 215 in your settings.php file copy from line 216 to 228 and paste the same next to line 228 , do not forget to enter ',' at end of line 228.
4. First line of copied text ie: 'default' is user defined , so we can change the same as you wish. eg: blahblah.
5. From 5th line of copied text, you can change the credentials of external database and save the file to apply the changes.
6. Go to your drupal7 site and clear cache to affect the changes as we know and done tons of time.

Screen shot below after above steps completed

 

Here we go, we have successfully connected to external database in drupal7.

Questions are welcome...

Ebisites.

Ebisites step in Website Development World on 2014 even it was in development stage from 2010. Even we are newly developing Start-up Company our Projects and products will result in High Quality and fulfil Top most requirement of our Clients. Assuring that we produce a Products to our clients which will be designed and developed in latest and High Technologies of updated ones.