Octopai Announces Automated Cloud Solution

Jan 22, 2019

Octopai, a provider of metadata management automation, announced the availability of its cloud-based metadata management automation to finally 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 organization 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 customization, causing these solutions to both lack agility and be very costly.

Octopai’s cloud-based solution offers Microsoft customers the ability to discover data and visualize complete data lineage in five seconds with a single click of a button. Requiring less than one hour for setup, Octopai offers customers actionable insights into the Microsoft BI Stack in under 24 hours.

The new release dramatically increases the 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 socialized 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.

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-premises solution. Recently, the company was chosen by Microsoft to be included in their prestige Scale-Up program.

Related Articles

Varada, a provider of big data inline indexing, announced a $7.5 million seed funding round led by Lightspeed Venture Partners, with participation by StageOne Ventures and F2 Capital.