Establishing Connection B/W Mstr & DB

1. We have to create DNS. We can create DNS using Mstr connectivity      wizard (or) odbc data sources.
2. We need login for the database , login credentials must have executable permissions on the particular     database.
3. We have to create database instance, we can create this using database instance wizard / right click on the folder    administration -> configuration managers - > database instances folder
4. Once we have completed, then configure a project and select database instances and add the created database instance wizard    then we will get the tables and data from those connected database.
5. Once we created the DB instance, now we have to specify the DB instance to the particular project. Now right click on any    project and select configuration of the project.
6. Select SQL data sources and add the newly created db instance, so now we are able to use the particular db tables and data .