Data Source Provider Type
This field essentially defines what type of database the Data Warehouse is. The three options are MSDAORA where the data source is an Oracle database. OLESQLDB where the data source is a SQL Server database, or MSDASQL to define an ODBC source. The MSDASQL provider type could be used for either Oracle or SQL Server data warehouses, but performance may be compromised. This field is a read only field in the properties screen. Its value is set in the properties of the data source connection.