Compartilhar via


Business Intelligence in SQL Server 2014 - SQL Server Data Tools (SSDT)

 

Updates to Design Tool installation


 

SQL Server Data Tools for Business Intelligence (SSDT BI), previously known as Business Intelligence Development Studio (BIDS), is used to create Analysis Services models, Reporting Services reports, and Integration Services packages. In this pre-release version of SQL Server 2014, SQL Server Setup no longer installs SSDT BI. The Visual Studio 2012 version of SSDT BI is now available as a web download from the Microsoft Download center.

If you have a prior version of SSDT BI or BIDS installed on your computer, the newer version is installed side-by-side with the previous version. It's common to run newer and older versions of the design tools on a single workstation so that you can modify projects and solutions tied to specific versions of the server.

New Project templates in SSDT

See more information here: https://msdn.microsoft.com/en-us/library/bb522628(v=sql.120).aspx

   - Ninja Ed

Comments

  • Anonymous
    January 01, 2014
    Great news about Analysis Services and BI. Thanks for sharing!

  • Anonymous
    January 28, 2014
    You're welcome, Durval!

  • Anonymous
    March 27, 2014
    Will this be available at RTM of SQL Server 2014 next week?

  • Anonymous
    March 29, 2014
    Steve, yes. SSDT-BI

  • Anonymous
    April 05, 2014
    Thanks for the information Ed. Also in the download manager i have checked that the Business tools are only for X86 processor. Any idea where i can get the tools for X64 processor.

  • Anonymous
    June 19, 2014
    Saurabh, Sorry, I don't know. You can try asking in the forums. Thanks!

  • Anonymous
    July 22, 2014
    Saurabh, BIDS, SQL Server Data Tools, Visual Studio have always only been 32-bit (x86).  You can run those tools on 64-bit processors (x64).  It will be nice when MS ever updates Visual Studio to 64-bit so we can end the 32-bit development of SSIS and deploy to 64-bit server and all the data driver issues that introduces.

  • Anonymous
    September 04, 2014
    Thanks, Steven!

  • Anonymous
    September 28, 2014
    I have developed an SQL database running on sql server 2014. How can I generate reports from the database. Someone assist please?

  • Anonymous
    September 29, 2014
    Samm, that's great! Please ask in the SQL Server DB forum. Thanks!

  • Anonymous
    September 29, 2014
    Samm, also, this is a very open-ended question. Please take a look at SQL Server Reporting Services. Thank you!

  • Anonymous
    November 19, 2014
    how to add business intelligence features in sql server 2014?? please

  • Anonymous
    November 19, 2014
    how to add business intelligence features in SQL server 2014??

  • Anonymous
    December 08, 2014
    Hi Iqbal, has your question been resolved?

  • Anonymous
    January 08, 2015
    Iqbal, please ask your question in the SSRS and SQL Server forums. This information is specific to SSDT in SQL Server 2014. Thanks!

  • Anonymous
    June 14, 2015
    Hi, Do we need a buy share point licenses for sql server 2014 BI implementation?

  • Anonymous
    September 14, 2015
    The comment has been removed

  • Anonymous
    October 12, 2015
    Naser and Steve, I'm not sure. Did you try the SQL Server forums or your account manager at Microsoft?

  • Anonymous
    January 27, 2016
    This link take me to download Microsoft SQL Server Data Tools - Business Intelligence for Visual Studio 2012 ???

  • Anonymous
    January 27, 2016
    Hossam, yes the first link is for access to the 2012 tools. The second link goes to the full library of release information: msdn.microsoft.com/.../bb522628(v=sql.120).aspx

  • Anonymous
    January 31, 2016
    Computers Today (part 1 of 6) blogs.msdn.com/.../computers-today.aspx ..... CS SPOTLIGHT: Girls in computer programming... why it matters!!! blogs.msdn.com/.../cs-spotlight-girls-in-computer-programming-why-it-matters.aspx ... Computational Thinking - Videos & Papers by Jeannette Wing blogs.msdn.com/.../computational-thinking-videos-amp-papers-by-jeannette-wing.aspx

  • Anonymous
    February 09, 2016
                  joio

  • Anonymous
    February 09, 2016
    Jojo indeed.

  • Anonymous
    March 02, 2017
    The comment has been removed