Compare PivotData Microservice vs SAP Crystal Server vs Periscope

More Information More Information More Information

Crozscore:

70%
what is this?
29%
interest rising

Crozscore:

95%
what is this?
62%
interest falling

Crozscore:

82%
what is this?
39%
no significant changes
PivotData Microservice screenshot view 1 more SAP Crystal Server screenshot view 5 more Periscope screenshot view 5 more

Software Description:

PivotData Microservice is a cross-platform on-premise .NET Core app that provides a web API for real-time data aggregation and generation of pivot tables and charts. This application may be hosted either on Windows or Linux.

Data sources are configured with JSON config which can be either a static config file or provided dynamically by main web app; microservice can be supported by a multi-tenant/SaaS usage scenario and each user could have its own customized data source configuration. The following connectors are available:

  • SQL: SQL Server, MySql, PostgreSQL, SQLite, ClickHouse, and any other DB with ODBC driver
  • MongoDB
  • ElasticSearch
  • Local CSV files

Web API generates reports by JSON report descriptions and can be used for both canned and custom (ad-hoc) interactive reporting. Pivot tables advanced options: percentages, differences, custom formatting & labels, TOP-N limits, server-side pagination, formula measures, report parameters for database-level filtering. In addition to HTML rendering, reports may be exported to PDF, CSV, Excel, and even Excel PivotTable.

Microservice is shipped with front-end components (javascript) for pivot table/chart web report builder; these widgets could be easily integrated with any web application for embedding self-service ad-hoc reports, pre-configured reports, or BI dashboards.

Software Description:

This is very useful BI software for small business, that provides reports, dashboards, and data exploration within managed infrastructure.

The main purpose of SAP Crystal Server is to ease the strain on IT resources and put business analytics directly into the hands the management. The vendor’s value proposition is that this software enables business users of all levels to make informed decisions and helps IT reduce reporting backlogs, administrative complexity, and costs.

This business analytics solution closes the gap between transactions, data preparation, analysis, and action, so business owners can make more informed decisions.

Software Description:

Periscope Data is a data analytics tool that consolidates business data from various sources, making the connection directly with databases. It brings all parameters to one place, providing users with a comprehensive view of business results.

Analysts are able to transform their SQL queries into interactive dashboards, graphs, and summaries for data consumers, remove workflow boundaries and improve data literacy in the organization. The system connects to databases via SSL JDBC, quickly and easily.

The Periscope Data Warehouse is built on Amazon Redshift, meets all business demands, and gives its users the power to eliminate repetitive manual work. Its analytics feature provides a visualized display, presenting data in more understandable format. All reports can be emailed immediately, while graphic displays can be embedded to user's website.

Features:

  • Multi-User
  • Data Import
  • Dashboard
  • Analytics
  • API
  • Data Export
  • Data Visualization

Features:

  • API
  • Data Visualization
  • Analytics
  • External Integrations
  • Data Export
  • Dashboard

Features:

  • 2-Factor Authentication
  • API
  • External Integrations
  • Forecasting
  • Scheduling
  • Notifications
  • Data Export
  • Data Import
  • Data Mining
  • Multi-User
  • Analytics
  • Dashboard
  • Data Visualization

Summary:

    No key features associated with this application.

Summary:

  • BI essentials for small and midsize businesses

  • Easily access and share reports and dashboards from a single, quick-to-deploy solution

  • View critical insights across data sources with intuitive, guided data exploration

  • Ensure corporate data is readily accessible via a common semantic layer

  • Accelerate report design and deliver personalised reports to a dynamic list

Summary:

  • Templates

  • Collaboration

  • Data Cleansing

  • High Volume Processing

  • Data Mining

  • Analytics

  • Dashboard Creation

  • Filtered Views

  • Graphical User Interface

  • Data Visualization

FAQs:

    Who are the main user groups of this service?
  • Startups, SMBs, and medium-sized companies which already have web-based intranet/management apps and need to embed BI capabilities by their SQL or NoSQL database(s).

  • What is this service generally used for?
  • Live canned reports and dashboards, ad-hoc reporting, custom end-user reporting (self-service), and scheduled reports generation.

FAQs:

    What platforms does this service support?
  • SAP Crystal Server supports both Windows and Linux.

  • What are some applications this service is commonly used in tandem with?
  • It is commonly used in tandem with Microsoft Office and Microsoft Share Point.

  • Who are the main user groups of this service?
  • The main user groups of SAP Crystal Server include both small and medium businesses.

  • Does this service offer an API?
  • Yes, SAP Crystal Server offers a complete set of APIs in both Java and NET.

  • What is this service generally used for?
  • This service is used as entry-level secure business intelligence (BI) solution.

  • Does this service integrate with any other apps?
  • Yes, SAP Crystal Server integrates with Java Portal Access, Microsoft Office, and Microsoft SharePoint.

  • Does this service offer guides, tutorials and or customer support?
  • Yes, customer support is available through email, live chat, videos, tutorial, and phone calls.

FAQs:

    Does this service offer guides, tutorials and or customer support?
  • Support: FAQs, Knowledge Base, Online Support, Phone Support, Video Tutorials, Community.

  • What is this service generally used for?
  • Periscope is used as a comprehensive data analysis platform.

  • What platforms does this service support?
  • This is a cloud-deployed software.

  • What are some applications this service is commonly used in tandem with?
  • Periscope is commonly used in tandem with Data Warehouses.

  • Who are the main user groups of this service?
  • Main users of this service are medium-sized and large businesses looking for a cloud data analytics solution, focusing on SQL.

  • Does this service integrate with any other apps?
  • Integrations: Workable, Salesforce, Survey Monkey, New Relic, Unity, Amazon Redshift, BigQuery, Snowflake, MySQL, MemSQL, Microsoft Azure, Amazon S3, Aftership, Amazon Quicksight, Asana, Azure Storage, Bigquery, Delighted, Desk.com, Dynamo, Excel, Formkeep, Freshdesk, Google Adwords, Google Drive, Google Sheets, Harvest, JIRA, Localytics, Mandrill, Marketo, Mixpanel, NetSuite, Oracle, Paypal, Recurly, SAP NetWeaver, SQL Server, Shopify, Taboola, Vero, Xero, Zapier.

  • Does this service offer multi-user capability (e.g. teams)?
  • Yes, there is multi-user capacity provided.

  • Does this service offer an API?
  • Periscope's Embed API allows the user to programmatically specify filters and their values in the URL when embedding dashboards.

Publisher:

Founded:
-
Based in:
-
Employees:
-
Likes:
Followers:

Publisher:

Founded:
-
Based in:
Walldorf
Employees:
10001+
Likes:
Followers:
5.42k

Publisher:

Founded:
-
Based in:
-
Employees:
-
Likes:
Followers:

Other:

Who uses PivotData Microservice
  • Startups
  • SMEs
  • Agencies
Desktop Platforms:
  • Web App
Languages:
English
Regional Restrictions:
No restrictions.

Other:

Who uses SAP Crystal Server
  • SMEs
Desktop Platforms:
  • Windows
Languages:
English, French, German, Japanese, Spanish, Chinese, Italian, Dutch, Russian, Korean, Portuguese, Swedish, Polish, Danish, Norwegian, Finnish, Thai, Czech, Hungarian, Slovak, Turkish, Romanian, Slovenian, Arabic
Regional Restrictions:
No restrictions.

Other:

Who uses Periscope
  • SMEs
  • Enterprises
Desktop Platforms:
  • Web App
Languages:
English
Regional Restrictions:
No restrictions.
Back to top