Orion Governance Supports Microsoft

Microsoft Description:

Orion supports a number of Microsoft technologies to meet your business intelligence, database, ETL, and file format requirements. From PowerBI and SSRS to SSRS and MS Excel, we support all these technologies and more. To know how we can help you, visit our Microsoft FAQ section.

Microsoft Support Includes:

  • Excel – File
  • Word – File
  • Microsoft SQL – Database
  • Microsoft SSAS – Reporting
  • Microsoft SSIS – ETL
  • Microsoft SSRS – Reporting
  • PowerBI – Reporting

Orion Governance and Microsoft FAQs

Orion EIIG supports several Microsoft platforms and some of them are listed below:

  • Microsoft SQL Server
  • Microsoft SQLServer
  • Integration Services
  • Microsoft SQLServer Analysis Services
  • Microsoft SQL Server Reporting Services
  • Microsoft Power BI

Yes, Orion EIIG supports parameterized jobs as well. The user needs to import the parameter file along with the input files to replace the right value for the parameter which was used in a job.

Yes, users can import metadata of multiple databases from a single server and see the lineage.

Orion EIIG users can see the impacted metadata/systems in a graphical view in the User Interface. This allows users to identify the impacted systems and the impacted metadata from a specific system.

Orion EIIG can display the quality score of the metadata. This functionality also covers the score of policy violation, prevalence, frequency, DQP confidence, etc.

Yes, Orion EIIG supports different hierarchy levels that include:

  • Enterprise
  • Legal Entity
  • Line of Business
  • Organization
  • Application
  • System

Users can see the connectivity at all levels based on their requirement.

Yes! By integrating Microsoft SQL Server Integration Services (SSIS) into our data governance platform – Enterprise Information Intelligence Graph (EIIG), we can examine, cleanse, load, transform, aggregate, merge and extract data with ease from various data sources/systems/files.

“Tool has very good capabilities, and can work on many different types of code. We use it on PL1, Cobol and SQL. What we like best is the wide range of code it can work on.”

CTO, Banking Industry

Have Questions about Microsoft and Orion Governance?

Recent Content