User name and password on the connection string. Parallel Data Warehouse SQL Authentication Same as SQL Server Relational Engine, except that Windows Authentication is not available. Windows Azure SQL Database SQL Authentication Same as SQL Server Relational Engine, except that Windows Authentication is not available. Third-Party (Oracle, Teradata, User name and Can be accessed through a third-party OLE Sybase, Informix, IBM DB2, and password on the DB or ODBC data provider. others) connection string. Apache Hadoop/Hive or User name and Can be accessed through Microsoft ODBC Windows Azure HDInsight password on the Provider for Hive. connection string. SQL Server Reporting Services Windows Can be accessed via HTTP. It is also possible Authentication to connect to a report as a data feed through the DataFeed provider. Forms Authentication SQL Server Analysis Services Windows Can be accessed through MSOLAP, Authentication and AMO. These data providers support TCP/IP and HTTP connections. HTTP support is provided through IIS and the Analysis Services data pump (MSMDPump). Excel workbooks with Windows Same as Analysis Services. Note that embedded PowerPivot data Authentication SharePoint supports Windows models uploaded to a authentication, authentication, enabled SharePoint farm. and SAML-based authentication, but the Analysis Services data providers only support Windows authentication. Microsoft Access databases Windows Can be accessed through the Microsoft ACE Authentication OLEDB provider. If the database file resides on a file system that requires authentication, such as a local NTFS drive
User name and password on the connection string. Parallel Data Warehouse SQL Authentication Same as SQL Server Relational Engine, except that Windows Authentication is not available. Windows Azure SQL Database SQL Authentication Same as SQL Server Relational Engine, except that Windows Authentication is not available. Third-Party (Oracle, Teradata, Sybase, Informix, IBM DB2, and others) User name and password on the connection string. Can be accessed through a third-party OLE DB or ODBC data provider. Apache Hadoop/Hive or Windows Azure HDInsight User name and password on the connection string. Can be accessed through Microsoft ODBC Provider for Hive. SQL Server Reporting Services Windows Authentication Forms Authentication Can be accessed via HTTP. It is also possible to connect to a report as a data feed through the DataFeed provider. SQL Server Analysis Services Windows Authentication Can be accessed through MSOLAP, and AMO. These data providers support TCP/IP and HTTP connections. HTTP support is provided through IIS and the Analysis Services data pump (MSMDPump). Excel workbooks with embedded PowerPivot data models uploaded to a SharePoint farm. Windows Authentication Same as Analysis Services. Note that SharePoint supports Windows authentication, authentication, and SAML-based authentication, but the Analysis Services data providers only support Windows authentication. Microsoft Access databases Windows Authentication Can be accessed through the Microsoft ACE OLEDB provider. If the database file resides on a file system that requires authentication, such as a local NTFS drive enabled