SQL Server Data Tools (SSDT)Microsoft
|
SSASMicrosoft
|
|||||
Related Products
|
||||||
About
SQL Server Data Tools (SSDT) transforms database development by introducing a ubiquitous, declarative model that spans all the phases of database development inside Visual Studio. You can use SSDT Transact-SQL design capabilities to build, debug, maintain, and refactor databases. You can work with a database project, or directly with a connected database instance on or off-premise. Developers can use familiar Visual Studio tools for database development. Tools such as: code navigation, IntelliSense, language support that parallels what is available for C# and Visual Basic, platform-specific validation, debugging, and declarative editing in the Transact-SQL editor. SSDT also provides a visual Table Designer for creating and editing tables in either database projects or connected database instances. While you are working on your database projects in a team-based environment, you can use version control for all the files.
|
About
Installed as an on-premises server instance, SQL Server Analysis Services supports tabular models at all compatibility levels (depending on version), multidimensional models, data mining, and Power Pivot for SharePoint. A typical implementation workflow includes installing a SQL Server Analysis Services instance, creating a tabular or multidimensional data model, deploying the model as a database to a server instance, processing the database to load it with data, and then assigning permissions to allow data access. When ready to go, the data model can be accessed by any client application supporting Analysis Services as a data source. Models are populated with data from external data systems, usually data warehouses hosted on a SQL Server or Oracle relational database engine (Tabular models support additional data source types).
|
|||||
Platforms Supported
Windows
Supported
Mac
Not Supported
Linux
Supported
Cloud
Supported
On-Premises
Not Supported
iPhone
Not Supported
iPad
Not Supported
Android
Not Supported
Chromebook
Not Supported
|
Platforms Supported
Windows
Not Supported
Mac
Not Supported
Linux
Not Supported
Cloud
Supported
On-Premises
Supported
iPhone
Not Supported
iPad
Not Supported
Android
Not Supported
Chromebook
Not Supported
|
|||||
Audience
Developers requiring a database management and development solution to build, debug, maintain, and refactor databases
|
Audience
Analytical data engine for companies wanting help with decision support and business analytics
|
|||||
Support
Phone Support
Supported
24/7 Live Support
Not Supported
Online
Supported
|
Support
Phone Support
Not Supported
24/7 Live Support
Not Supported
Online
Supported
|
|||||
API
Offers API
Not Supported
|
API
Offers API
Not Supported
|
|||||
Screenshots and Videos |
Screenshots and Videos |
|||||
Pricing
No information available.
Free Version
Not Supported
Free Trial
Supported
|
Pricing
No information available.
Free Version
Not Supported
Free Trial
Not Supported
|
|||||
Reviews/
|
Reviews/
|
|||||
Training
Documentation
Supported
Webinars
Supported
Live Online
Supported
In Person
Supported
|
Training
Documentation
Supported
Webinars
Not Supported
Live Online
Not Supported
In Person
Not Supported
|
|||||
Company InformationMicrosoft
Founded: 1975
United States
docs.microsoft.com/en-us/sql/ssdt/sql-server-data-tools
|
Company InformationMicrosoft
Founded: 1975
United States
docs.microsoft.com/en-us/analysis-services/ssas-overview
|
|||||
Alternatives |
Alternatives |
|||||
|
|
|
|||||
|
|
||||||
|
|
|
|||||
|
|
||||||
Categories |
Categories |
|||||
Integrations
SQL Server
Supported
AnalyticsCreator
Not Supported
Docker
Supported
ER/Studio Enterprise Edition
Supported
Microsoft 365
Supported
Microsoft Azure
Supported
Microsoft Excel
Not Supported
Microsoft Power BI
Not Supported
Nucleon Database Master
Not Supported
Visual Studio
Supported
|
Integrations
SQL Server
Supported
AnalyticsCreator
Supported
Docker
Not Supported
ER/Studio Enterprise Edition
Not Supported
Microsoft 365
Not Supported
Microsoft Azure
Not Supported
Microsoft Excel
Supported
Microsoft Power BI
Supported
Nucleon Database Master
Supported
Visual Studio
Not Supported
|
|||||
|
|
|