Octopai’s automates Metadata Management for Microsoft BI

Octopai has announced the availability of its cloud-based metadata management automation to enable Microsoft users to locate crucial data and track its movement process across the entire Microsoft business intelligence stack.

One of the biggest challenges for any organisation directly impacting business intelligence users is discoverability. The inability to find, understand and discover where relevant data is located, and furthermore, understand its movement process within the entire Microsoft stack, including SSIS, MS-SQL, Tabular, OLAP, SSRS and PowerBI hinders BI users from producing accurate reports quickly.

Microsoft users are often forced to compromise on resources and quality of delivery in order to meet business deadlines because current metadata management solutions are either designed to be on-premises and/or require a high level of customisation, causing these solutions to both lack agility and be very costly.

Octopai provides exactly the opposite. The company’s cloud-based solution offers Microsoft customers the ability to discover data and visualise complete data lineage in 5 seconds with a single click of a button. Requiring less than 1 hour for setup, Octopai offers customers actionable insights into the Microsoft BI Stack in under 24 hours.

The new release dramatically increases productivity of day to day operations by providing advanced visibility across the entire BI landscape. To help BI professionals and business users understand and gain notable insight into their metadata, Octopai enables users to perform:

  • Horizontal Lineage: Microsoft users will be able to understand the data flow as it moves and transforms throughout the SSIS, MS-SQL, Tabular, OLAP, SSRS and PowerBI in one click. This lineage can be from any point to any point and can be shared and socialised with the different stakeholders that participate in the data management efforts.
  • Vertical Lineage (Column-to-Column): enables users to drill down into ETL processes and Stored Procedures to get unprecedented visibility into data lineage. For the first time, users can visualize source to target, travel upstream and downstream across the ETL, jump from one database package to another, and even from a database package to a stored procedure and vice versa.
  • Impact analysis: By reverse engineering the data flow, Microsoft users who want to make a change to an SSIS package or a stored procedure from SQL server, can understand the full impact of any changes required in the design phase before going live to production.


“One of the greatest barriers for BI is the lack of agility and amount of time it takes to get current tools up and running,” said Amnon Drori CEO of Octopai. “Our cloud-based solution allows BI professionals to integrate on Monday and see meaningful results by Wednesday.”

Octopai adds its Microsoft full stack service to its already existing full service for Oracle, as well as IBM, SAP, and Informatica tools. The company’s Microsoft solution is available on the Microsoft Azure Marketplace and can be hosted either on the cloud or as an on premise solution.