If you are into Business Intelligence, you are in luck, this week Microsoft has released a SQL Server 2012 Business Intelligence whitepaper as well as SQL Server Data Tools – Business Intelligence for Visual Studio 2012 (SSDT BI) templates.
The whitepaper is 41 pages and covers Microsoft BI Authentication and Identity Delegation . Here are the contents of the whitepaper
Contents
Introduction
Personal BI Scenarios in Excel
Client/Server Connections to Import Data
Data Sources and their Authentication Methods
Team BI Scenarios in SharePoint
Multi-Tier Application Architecture
Classic-Mode versus Claims-Mode Authentication
Identity Delegation within a SharePoint Farm
Client Authentication Issues
Workbooks as a Data Source
PowerPivot Gallery
Anonymous Users
Mitigating Client Authentication Issues
Backend Authentication Issues
Accessing Relational Configuration, Content, and Service Application Databases
Authentication against External Data Sources
Kerberos Constrained Delegation and Alternatives
Accessing Analysis Services in SharePoint Mode
Corporate BI Data Access Scenarios
Authentication Flows in Native-Mode Reporting Services
Windows User Authentication
Custom User Authentication
Custom Data Source Authentication
Authentication Flows in Analysis Services
Multidimensional and Tabular Data Access
ROLAP and DirectQuery Mode
Client Authentication over HTTP
Custom Analysis Services Authentication over HTTP
Federated BI Scenarios
Multi-Forest Active Directory Environments
Extranet Environments
Cloud Environments
Conclusion
Download the Microsoft BI Authentication and Identity Delegation Word document.
SSDT BI
SQL Server Data Tools – Business Intelligence for Visual Studio 2012 (SSDT BI) templates has been released this week as well. With SSDT BI for Visual Studio 2012 you can develop and deploy SQL Server Business intelligence projects. Projects created in Visual Studio 2010 can be opened in Visual Studio 2012 and the other way around without upgrading or downgrading. You can read more about this and see some screenshots here: http://blogs.msdn.com/b/sqlrsteamblog/archive/2013/03/06/sql-server-data-tools-business-intelligence-for-visual-studio-2012-released-online.aspx
You can download it here: Microsoft SQL Server Data Tools – Business Intelligence for Visual Studio 2012
Denis has been working with SQL Server since version 6.5. Although he worked as an ASP/JSP/ColdFusion developer before the dot com bust, he has been working exclusively as a database developer/architect since 2002. In addition to English, Denis is also fluent in Croatian and Dutch, but he can curse in many other languages and dialects (just ask the SQL optimizer) He lives in Princeton, NJ with his wife and three kids.
