With the release of SSAS 2012 Microsoft has introduced a new BI storage engine. In addition to the traditional OLAP engine you now have the option to build your BI models on top of the new Vertipaq engine (This is the same engine used by PowerPivot.) To use the new Vertipaq engine you build a Tabular data model. A new query language DAX (Data Analysis Expressions) is used to query the data, create calculations, measures, and KPI’s. DAX is similar to the expression language used in excel and it should be easier to use than MDX and appeal to a broader audience.This webinar is designed to introduce you to the process of building a tabular model in SQL Server Data Tools (BIDS rebranded). We will import data from a SQL Server relational database into a tabular model project and create relationships between the tables. We will use DAX to create and manage calculations, measures, and Key Performance Indicators. We will then test and explore the model using the Analyze in Excel feature in SQL Server Data Tools.
LegiTest is compatible with Visual Studio 2013 or later. We recommend Visual Studio 2015 or later for the best experience.
LegiTest is licensed per user, per machine where it is used. LegiTest Server is licensed per server instance, with unlimited client access licenses. Please contact [email protected] for more information.
DTS xChange is licensed per package conversion. Please contact [email protected] for more information.
DBA xPress is licensed per user, per machine where it is used. Please contact [email protected] for more information.
BI xPress is licensed per user, per machine where it is used. BI xPress Server is licensed per server instance with 5 client access licenses included. A client access license is assigned to a single user. Additional client access licenses can be purchased. Please contact [email protected] for more information.
Task Factory is licensed per server instance. There is no license necessary to use Task Factory in the Integration Services development environment (Visual Studio, SQL Server Data Tools, or Business Intelligence Developer Studio). Please contact [email protected] for more information.
DOC xPress is licensed per user, per machine where it is used. DOC xPress Server is licensed per server instance with 5 client access licenses included. A client access license is assigned to a single user. Additional client access licenses can be purchased. Please contact [email protected] for more information.
Yes, DOC xPress supports SSIS projects and ISPAC that encrypt passwords. It also supports encrypted SSIS packages.
Yes, but in order to continue using the Salesforce features, you must upgrade to the latest version of Task Factory. Click here for more information on Salesforce's upgrade to TLS 1.2.
Most testing software only tests certain aspects of data-centric development. LegiTest allows testing across all aspects of your development lifecycle, providing validation at each stage of development
Yes. LegiTest easily integrates with existing systems. It can be incorporated into build processes such as MSBuild, TFS, TeamCity and much more.
Testing your data ensures you catch bugs early, reduce delivery time, reduce the cost of testing and provides provable assurances of the validity of the data. But most of all, testing just works. Testing ensures accurate code, and more importantly accurate data.
DTS xChange only does conversions for SSIS 2005 or 2008.
In many cases it can, however it is dependent upon the contents of the existing DTS package.
DTS xChange uses proprietary rule based engine to migrate DTS Packages to SSIS by applying best practices of SSIS. So by using DTS xChange you not only get higher migration success rate but you also get new features supported by SSIS (e.g. Event Handlers, Logging, XML Configuration Files etc.)
DBA xPress is a suite of tools designed to aid the DBA with the management of their SQL Servers and data. BI xPress Pro includes DBA xPress with it.
You can! Click here to download a sample document. Having trouble viewing CHM files? Click here for instructions on how to view them.
DOC xPress Server makes it easier to share and explore documentation across the enterprise. It eliminates the need to install DOC xPress Pro to view documentation, do lineage analysis, and update data dictionaries.
The DOC xPress and DOC xPress Server templates are used to lend form and reason to the output. They are fully customizable and control what information is included in the documentation. For more information, click here.
There are a number of functions available with Task Factory. Click here to view a complete list.
Yes, Task Factory components can be used with Azure databases.
BI xPress comes bundled and there is no way to only sell one feature of the product.
Yes, you can designate the reason for the message to go out and make your own custom message that you can share with others.
BI xPress Server provides the ability to monitor SSIS package execution as well as Reporting Services, making it easier to provide access to this information without the need to install the full BI xPress Pro software.