Defining Analysis Services Dimensions - SQL Server Analysis Services 2012 Cube Development - page 16

3. The Connection Manager allows us to choose a .NET or OLE DB provider,
which we want to use for connecting to the relational data source.
4. Click on the Provider dropdown to see the list of available providers. You
have a number of choices out of the box; you could source data from the SQL
Server, Oracle, Access, or SQL Server Compact databases, among others.
5. The Connection Manager will show more options if you install additional
drivers (for example, Sybase or Teradata driver), which aren't included with
the default Analysis Services installation. Note that you have several options
for connecting to SQL Server data sources, including the SQL Server Native
Client or OLE DB provider. For this exercise, let's use the OLE DB provider
for the SQL Server.