This video goes over all connectivity components required to set up a MicroStrategy Environment.
Creating ODBC DSN to metadata and data warehouse
Define and create a server definition
Configure three-tier project sources
Understanding four-tier environments
Create database instance to connect projects to data warehouse.