How to integrate Microsoft SQL Server Analysis Services (SSAS) in Heroku Postgres
Discover how to integrate Microsoft SQL Server Analysis Services (SSAS) and Heroku Postgres and instantly get access to your data.
About Microsoft SQL Server Analysis Services (SSAS)
Microsoft SQL Server Analysis Services, SSAS, is an OLAP and data mining tool in Microsoft SQL Server. SSAS is used by organizations as a tool to analyze and understand information that may be spread across multiple databases or in different tables or files. Analysis Services provides a group of OLAP and data mining functions.
About Heroku Postgres
Heroku Postgres provides a SQL database-as-a-service based on PostgreSQL. Besides the database Heroku Postgres delivers an additional toolset consisting of the possibility to fork the database to clone it with a single command for running test on the clone, read-only replicas of the database, continuous protection and mutli-ingress to access the database from anywhere on the internet.
What is Data Virtuality?
Data Virtuality enables companies to build an agile BI stack in 1 day. It connects to Microsoft SQL Server Analysis Services (SSAS), Heroku Postgres and more than 200 other databases and cloud services. All connected data sources can be directly queried with SQL and data can be moved into any analytical database. Customers of the Data Virtuality Logical Data Warehouse are digital businesses with the highest flexibility needs.
IMMEDIATE ACCESS TO DATA
Connect over 200+ databases, cloud services and files (XML, CSV, etc.) in minutes. Query data with your favorite analysis tools.
CENTRAL DATA MODEL
Set uniform definitions for their data and apply them to their analysis tools, regardless of the underlying data source.
ALL QUESTIONS IN SQL
With Data Virtuality you can query all data sources with SQL. NoSQL, CSV or XML File: We transform any connected data source in SQL.
REAL TIME REPORTING
Data Virtuality controls the exchange of data between all databases, cloud services, and analysis tools to help everyone in their organization get the information they need.