Ecosystem:Business intelligence (BI)

From PostgreSQL wiki
Jump to navigationJump to search

2UDA

  • Provider -- 2ndQuadrant
  • Website -- https://www.2ndquadrant.com/
  • License -- The PostgreSQL Licence
  • Interoperability level -- supports PostgreSQL 9.5 or higher
  • Verified PostgreSQL versions -- https://www.2ndquadrant.com/en/resources/2uda/
  • Last update (YYYY-MM-DD) -- 2020-09-24
  • Description -- 2ndQuadrant Unified Data Analytics (2UDA) is a data analytics application suite that unifies databases, machine learning, data mining, and visualization. The application can be installed using a user-friendly, one-click desktop installer.
  • Additional info -- click here

Chartio

  • Provider -- Chartio
  • Website -- https://chartio.com/
  • License -- proprietary
  • Interoperability level -- explicitly supports PostgreSQL (no specific version is specified)
  • Verified PostgreSQL versions -- didn't actually run the program, but just checked the documentation
  • Last update (YYYY-MM-DD) -- 2018-05-10
  • Description -- Cloud-based data exploration, beautiful charts and interactive dashboards for business and data teams like yours.
  • Additional info -- click here

Crystal Reports

  • Provider -- SAP SE
  • Website -- http://www.crystalreports.com/
  • License -- proprietary
  • Interoperability level -- explicitly supports PostgreSQL 9.2 - 9.5
  • Verified PostgreSQL versions -- didn't actually run the program, but just checked the documentation
  • Last update (YYYY-MM-DD) -- 2018-3-12
  • Description -- With SAP Crystal Reports, you can create powerful, richly formatted, and dynamic reports from virtually any data source, delivered in dozens of formats, in up to 28 languages. SAP Crystal Reports turns almost any data source into interactive, actionable information that can be accessed offline or online, from applications, portals and mobile devices.
  • Additional info -- click here

DaphnaBI

  • Provider -- DaphnaBI
  • Website -- https://www.daphnabi.com/
  • License -- proprietary
  • Interoperability level -- explicitly supports PostgreSQL (no specific version is specified)
  • Verified PostgreSQL versions -- didn't actually run the program, but just checked the documentation
  • Last update (YYYY-MM-DD) -- 2018-3-13
  • Description -- The leader in Visual Intelligence. Create Dashboards, Charts, Reports, and Maps using point-and-click or with full SQL support. Dedicated resources and dedicated url. Business Intelligence Server.
  • Additional info -- click here

DbFace

  • Provider -- DbFace Co, LTD
  • Website -- http://www.dbfacephp.com/
  • License -- proprietary
  • Interoperability level -- explicitly supports PostgreSQL (no specific version is specified)
  • Verified PostgreSQL versions -- didn't actually run the program, but just checked the documentation
  • Last update (YYYY-MM-DD) -- 2018-3-13
  • Description -- A super easy to use, professional report and dashboard builder for SQL databases (MySQL, PostgreSQL, SQL Server, Oracle, DB2, SQLite3 etc.) without coding.
  • Additional info -- click here

JasperReports

  • Provider -- TIBCO Software, Inc.
  • Website -- https://community.jaspersoft.com/project/jasperreports-library
  • License -- open source (LGPLv3)
  • Interoperability level -- interoperable via generic JDBC connection
  • Verified PostgreSQL versions -- didn't actually run the program, but just checked the documentation
  • Last update (YYYY-MM-DD) -- 2018-3-13
  • Description -- The JasperReports Library is the world's most popular open source reporting engine. It is entirely written in Java and it is able to use data coming from any kind of data source and produce pixel-perfect documents that can be viewed, printed or exported in a variety of document formats including HTML, PDF, Excel, OpenOffice and Word.
  • Additional info -- click here

JasperReports Server

  • Provider -- TIBCO Software, Inc.
  • Website -- https://community.jaspersoft.com/project/jasperreports-server
  • License -- open source (AGPLv3) or proprietary depending on the product edition
  • Interoperability level -- interoperable via generic JDBC connection
  • Verified PostgreSQL versions -- didn't actually run the program, but just checked the documentation
  • Last update (YYYY-MM-DD) -- 2018-3-13
  • Description -- The JasperReports Library is the world's most popular open source reporting engine. It is entirely written in Java and it is able to use data coming from any kind of data source and produce pixel-perfect documents that can be viewed, printed or exported in a variety of document formats including HTML, PDF, Excel, OpenOffice and Word.
  • Additional info -- click here

Jedox

  • Provider -- Jedox AG
  • Website -- https://www.jedox.com/en
  • License -- open source (GPLv2) and proprietary
  • Interoperability level -- interoperable via generic JDBC connection
  • Verified PostgreSQL versions -- didn't actually run the program, but just checked the documentation
  • Last update (YYYY-MM-DD) -- 2018-3-13
  • Description -- Jedox corporate performance management software streamlines budgeting, forecasting, and planning across finance, sales, human resources, procurement, and other departments. Integrate financial planning and analysis with operational plans and reporting to optimize processes, boost data quality, and slash planning cycles throughout the organization.
  • Additional info -- click here

Jinfonet JReport Suite

  • Provider -- Jinfonet Software, Inc.
  • Website -- https://www.jinfonet.com/
  • License -- proprietary
  • Interoperability level -- interoperable via generic JDBC connection
  • Verified PostgreSQL versions -- didn't actually run the program, but just checked the documentation
  • Last update (YYYY-MM-DD) -- 2018-3-13
  • Description -- Add rich visualizations, sophisticated reporting, business intelligence and analytics to your application. Let JReport do the heavy lifting while you focus on your business. Easily configure to look and feel like a seamless part of your application. Provide a consistent user experience by invisible white labeling with extensive APIs. Rapidly develop today with high capacity tomorrow. From small instances to clustered servers or multi-tenant environments, the architecture is ready when you are.
  • Additional info -- click here

KeySQL

  • Provider -- K.K. Ashisuto
  • Website -- https://www.ashisuto.co.jp/product/category/bi/keysql/
  • License -- proprietary
  • Interoperability level -- explicitly supports PostgreSQL 8/9
  • Verified PostgreSQL versions -- didn't actually run the program, but just checked the documentation
  • Last update (YYYY-MM-DD) -- 2020-1-2
  • Description -- KeySQL is a tool to enable you to search and update data in databases from Microsoft Excel and LibreOffice Calc that you are familiar with.
  • Additional info -- click here

List & Label

  • Provider -- Combit GmbH
  • Website -- https://www.combit.net/en/reporting-tool/
  • License -- proprietary
  • Interoperability level -- explicitly supports PostgreSQL (no specific version is specified)
  • Verified PostgreSQL versions -- didn't actually run the program, but just checked the documentation
  • Last update (YYYY-MM-DD) -- 2018-3-12
  • Description -- List & Label is the reporting tool of choice for thousands of software developer teams all over the world. Extend your application quickly and easily with powerful reporting functionalities and a wide range of reports! You pass on the report designer (Win/Web) with your application free of charge.
  • Additional info -- click here

Looker

  • Provider -- Looker Data Sciences, Inc.
  • Website -- https://www.looker.com/
  • License -- proprietary
  • Interoperability level -- explicitly supports PostgreSQL (no specific version is specified)
  • Verified PostgreSQL versions -- didn't actually run the program, but just checked the documentation
  • Last update (YYYY-MM-DD) -- 2018-3-16
  • Description -- Looker has harnessed the power of SQL to create a uniquely powerful data analytics platform that helps companies get real value from their data. Now anyone can ask sophisticated questions of the data using familiar business terms.
  • Additional info -- click here

Metabase

  • Provider -- Metabase
  • Website -- https://www.metabase.com/
  • License -- open source (AGPLv3)
  • Interoperability level -- explicitly supports PostgreSQL (no specific version is specified)
  • Verified PostgreSQL versions -- didn't actually run the program, but just checked the documentation
  • Last update (YYYY-MM-DD) -- 2020-1-3
  • Description -- Metabase is the easy, open source way for everyone in your company to ask questions and learn from data. Easily summarize and visualize your data without ever writing a line of SQL or having to wait on a coworker. Browse or search through your tables, then filter things down to find just what you need. Move from your data to beautiful graphs and charts with just a few clicks. When you need to dig into the complicated stuff, Metabase provides a flexible GUI query builder and an elegant SQL interface.
  • Additional info -- click here

MicroStrategy

  • Provider -- MicroStrategy Inc.
  • Website -- http://www.microstrategy.com/
  • License -- proprietary
  • Interoperability level -- explicitly supports PostgreSQL 9.x
  • Verified PostgreSQL versions -- didn't actually run the program, but just checked the documentation
  • Last update (YYYY-MM-DD) -- 2018-3-13
  • Description -- From enterprise reporting and data discovery to mobile productivity and real-time telemetry, only MicroStrategy gives organizations the full breadth of capabilities they need to transform their data into real-world intelligence.
  • Additional info -- click here

OpenRPT

  • Provider -- xTuple
  • Website -- https://xtuple.com/download/openrpt
  • License -- open source (LGPLv2)
  • Interoperability level -- explicitly supports PostgreSQL (no specific version is specified)
  • Verified PostgreSQL versions -- didn't actually run the program, but just checked the documentation
  • Last update (YYYY-MM-DD) -- 2018-3-15
  • Description -- xTuple's Free Open Source SQL Report Writer. Included with all Editions of xTuple. OpenRPT is built with the PostgreSQL database and the Qt GUI client framework. It runs equally well on every operating system.
  • Additional info -- click here

Orange

  • Provider -- University of Ljubljana
  • Website -- https://orange.biolab.si/
  • License -- open source (GPLv3+)
  • Interoperability level -- explicitly supports PostgreSQL 9.5 or higher
  • Verified PostgreSQL versions -- didn't actually run the program, but just checked the documentation
  • Last update (YYYY-MM-DD) -- 2018-3-15
  • Description -- Orange is a component-based data mining software. It includes a range of data visualization, exploration, preprocessing and modeling techniques. It can be used through a nice and intuitive user interface or, for more advanced users, as a module for the Python programming language.
  • Additional info -- click here

Power BI

  • Provider -- Microsoft Corporation
  • Website -- https://powerbi.microsoft.com/
  • License -- proprietary
  • Interoperability level -- explicitly supports PostgreSQL (no specific version is specified)
  • Verified PostgreSQL versions -- didn't actually run the program, but just checked the documentation
  • Last update (YYYY-MM-DD) -- 2018-3-16
  • Description -- Power BI is a suite of business analytics tools that deliver insights throughout your organization. Connect to hundreds of data sources, simplify data prep, and drive ad hoc analysis. Produce beautiful reports, then publish them for your organization to consume on the web and across mobile devices. Everyone can create personalized dashboards with a unique, 360-degree view of their business. And scale across the enterprise, with governance and security built-in.
  • Additional info -- click here

Redash

  • Provider -- Redash
  • Website -- https://redash.io/
  • License -- open source (BSD 2-clause)
  • Interoperability level -- explicitly supports PostgreSQL (no specific version is specified)
  • Verified PostgreSQL versions -- didn't actually run the program, but just checked the documentation
  • Last update (YYYY-MM-DD) -- 2020-1-3
  • Description -- Redash helps you make sense of your data. Connect and query your data sources, build dashboards to visualize data and share them with your company. Redash is our take on freeing the data within our company in a way that will better fit our culture and usage patterns. Prior to Redash, we tried to use traditional BI suites and discovered a set of bloated, technically challenged and slow tools/flows. What we were looking for was a more hacker'ish way to look at data, so we built one. Redash was built to allow fast and easy access to billions of records, that we process and collect using Amazon Redshift ("petabyte scale data warehouse" that "speaks" PostgreSQL). Today Redash has support for querying multiple databases, including: Redshift, Google BigQuery, PostgreSQL, MySQL, Graphite, Presto, Google Spreadsheets, Cloudera Impala, Hive and custom scripts.
  • Additional info -- click here

Slemma

  • Provider -- Slemma
  • Website -- https://slemma.com/
  • License -- proprietary
  • Interoperability level -- explicitly supports PostgreSQL (no specific version is specified)
  • Verified PostgreSQL versions -- didn't actually run the program, but just checked the documentation
  • Last update (YYYY-MM-DD) -- 2018-3-16
  • Description -- Slemma enables IT managers to create dynamic data reports from multiple data sets by writing SQL queries. Integrate seamlessly with over 75 data warehouses, databases and cloud service solutions, including business solutions like Amazon Redshift, PostgreSQL, MySQL, and Oracle.
  • Additional info -- click here

SQL Server Reporting Services

  • Provider -- Microsoft Corporation
  • Website -- https://docs.microsoft.com/en-us/sql/reporting-services
  • License -- proprietary
  • Interoperability level -- interoperable via generic ODBC connection
  • Verified PostgreSQL versions -- didn't actually run the program, but just checked the documentation
  • Last update (YYYY-MM-DD) -- 2018-3-16
  • Description -- SQL Server Reporting Services is a solution that customers deploy on their own premises for creating, publishing, and managing reports, then delivering them to the right users in different ways, whether that’s viewing them in web browser, on their mobile device, or as an email in their in-box.
  • Additional info -- click here

Tableau Desktop

  • Provider -- Tableau Software
  • Website -- https://www.tableau.com/products/desktop
  • License -- proprietary
  • Interoperability level -- explicitly supports PostgreSQL 8.3 or higher
  • Verified PostgreSQL versions -- didn't actually run the program, but just checked the documentation
  • Last update (YYYY-MM-DD) -- 2018-3-16
  • Description -- Leave chart builders behind. Live visual analytics fuel unlimited data exploration. Interactive dashboards help you uncover hidden insights on the fly. Tableau harnesses people’s natural ability to spot visual patterns quickly, revealing everyday opportunities and eureka moments alike.
  • Additional info -- click here

Tableau Server

  • Provider -- Tableau Software
  • Website -- https://www.tableau.com/server
  • License -- proprietary
  • Interoperability level -- explicitly supports PostgreSQL 8.3 or higher
  • Verified PostgreSQL versions -- didn't actually run the program, but just checked the documentation
  • Last update (YYYY-MM-DD) -- 2018-3-16
  • Description -- Extend the value of your data across your entire organization with Tableau Server. Empower your business with the freedom to explore data in a trusted environment-without limiting them to pre-defined questions, wizards, or chart types. Have the peace of mind that both your data and your analytics are governed, secure, and accurate. IT organizations love Tableau for it's ease of deployment, robust integration, simplicity of scalability, and excellent reliability. You no longer have to choose between empowering the business or protecting your data - with Tableau you can finally do both.
  • Additional info -- click here

Ubiq

  • Provider -- Ubiq
  • Website -- http://ubiq.co/
  • License -- proprietary
  • Interoperability level -- explicitly supports PostgreSQL (no specific version is specified)
  • Verified PostgreSQL versions -- didn't actually run the program, but just checked the documentation
  • Last update (YYYY-MM-DD) -- 2018-3-16
  • Description -- Ubiq is a web-based reporting tool for MySQL, PostgreSQL database. Ubiq makes it easy to analyze business data. Create web-based reports & online dashboards in minutes. Ubiq provides advanced reporting capabilities to build custom dashboard and reports for your organization. It enables you to export dashboard and reports in multiple formats. Securely share them with others.
  • Additional info -- click here

WebFOCUS

  • Provider -- Information Builders, Inc.
  • Website -- https://www.informationbuilders.com/products/bi-and-analytics-platform
  • License -- proprietary
  • Interoperability level -- explicitly supports PostgreSQL (no specific version is specified)
  • Verified PostgreSQL versions -- didn't actually run the program, but just checked the documentation
  • Last update (YYYY-MM-DD) -- 2018-3-16
  • Description -- The WebFOCUS business intelligence (BI) and analytics platform helps companies use data more strategically across and beyond the enterprise. It provides organizations with everything they need to turn data into actionable insights for real business outcomes. WebFOCUS offers the right user experience for every user. So easy to use, it helps satisfy all your information consumers needs in the way that best suits their style, with full data and decision integrity.
  • Additional info -- click here

WebQuery

  • Provider -- Canon IT Solutions Inc
  • Website -- https://www.canon-its.co.jp/products/webquery/
  • License -- proprietary
  • Interoperability level -- explicitly supports PostgreSQL (no specific version is specified)
  • Verified PostgreSQL versions -- didn't actually run the program, but just checked the documentation
  • Last update (YYYY-MM-DD) -- 2018-3-16
  • Description -- WebQuery is a data search and analysis solution that runs on a Web server. Just by setting the conditions following the screen navigation from the Web browser, you can easily perform data search and analysis.
  • Additional info -- click here

Zoho Reports