Integration

Complete Guide to Business Intelligence tools integration

Reading time: 16 minutes

All business operates with data – information generated from your company’s many internal and external sources. And these data channels serve as a pair of eyes for executives, supplying them with the analytical information about what is going on with the business and the market. Accordingly, any misconception, inaccuracy, or lack of information may lead to a distorted view of the market situation as well as internal operations – followed by bad decisions.

Making data-driven decisions requires a 360° view of all the aspects of your business, even those you didn’t think of. But how to turn unstructured data chunks into something useful? The answer is business intelligence.

We’ve already discussed machine learning strategy. In this article, we’ll discuss the actual steps of bringing business intelligence into your existing corporate infrastructure. You will learn how to set up a business intelligence strategy and integrate tools into

Read More

sql server – Visual Studio 2017 does not have Business Intelligence Integration Services/Projects

Information on this will probably get outdated fast because Microsoft is running to complete its work on this, but as today, June 9th 2017, support to create SQL Server Integration Services (SSIS) projects on Visual Studio 2017 is not available. So, you can’t see this option because so far it doesn’t exist yet.

Beyond that, even installing what is being called SSDT (SQL Server Data Tools) in VS 2017 installer (what seems very confusing from Microsoft’s part, using a known name for a different thing, breaking the behavior we expect as users), you won’t see SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS) project templates as well.

Actually, the Business Intelligence group under the Installed templates on the New Project dialog won’t be present at all.

You need to go to this page (https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt) and install two separate installers, one for SSAS and one for SSRS.

Once

Read More