SeekTable

Frequently Asked Questions


Who are you? How safe my data on SeekTable?

SeekTable.com is owned and maintained by the same team that supports NReco Components (located in Kyiv, Ukraine); we're in business many years so you can be sure that SeekTable will not suddenly disappear. Your data is used only to build visualizations and reports requested by you; see our privacy policy for more details. As any other internet service SeekTable cannot be 100% safe, and in case of very sensitive data you can consider usage of self-hosted (on-premise) installation.


Is SeekTable really free?

Yes, SeekTable offers free personal accounts, and we don't plan to remove them in the future.

With paid subscription you can unlock additional SeekTable functionality:


Can I share cubes/reports with other SeekTable users?

It is possible to share your cubes and/or reports with your team members using team-sharing feature:

  • invite users into your team (in self-hosted mode confirmation by email is not needed)
  • share a cube (data source) or reports to team with access rules:
    • who can access the cube or report: all team members or you can choose users
    • for cube: what dimensions/measures should be accessible (all or you can choose items)
    • for report: what report options are enabled (Rows/Columns/Values/Chart/Filter selectors, Format/Params tabs, export formats)
  • record-level permissions: you can use special report parameter to filter report data by user's email

You can easily evaluate this feature with free 14-day trial: just click on "Share to team" and then activate your trial. If you need more time to test team sharing functionality feel free to contact us.


How to subscribe to a report (schedule report generation)?

In case of live data source (database, or auto-sync CSV) you might want to automate report generation on schedule (daily, weekly etc) and get a report with newest values directly to your email inbox (or Slack/Drive/Dropbox/OneDrive etc), without the need to open SeekTable app. For this purpose SeekTable has connectors in the following integration platforms:

  • Zapier: you can create "zaps" that trigger on some event and execute an action in your SeekTable account: report export, share report by email, CSV file upload.
  • Microsoft Flow: you can create workflow automation to deliver reports on schedule and perform the same actions in your SeekTable account as in case of Zapier.

Can I use an API to access SeekTable reports?

SeekTable has two different API endpoints:

  • API that allows you to render/export reports saved in your account or upload/refresh a CSV file. It is primarily used by Zapier and MS Flow connectors, but you can use this web API directly if you like.
  • API of PivotData microservice - this is reporting engine used by SeekTable. This API can be used for embedded BI functionality; if you are interested in this please contact us.

Is it possible to install SeekTable on my server?

We realize that in some cases you cannot use SeekTable as a cloud service for number of reasons - say, if you have sensitive data that should not leave your company's intranet or your local computer.

You still can use reporting functionality provided by self-hosted SeekTable which is available as docker images.
Also, if you're looking for embedded pivot tabes, you can download PivotData microservice - this is reporting engine used by SeekTable - and integrate its web pivot builder into your web application.


How to automatically import CSV file from Google Drive/OneDrive/Dropbox/URL?

In some cases you might want to keep reports created by CSV in sync with:

  • Google Drive (including spreadsheets editable with Google Sheets)
  • Microsoft OneDrive (including Excel files)
  • Dropbox (only CSV/TSV files)
  • public URL (only CSV/TSV files)

This kind of automation is possible with Zapier or Microsoft Flow.


I want to use database %X% as a data source. Is it possible?

If this database is SQL-compatible and it has Linux ODBC driver we can add it to the list of supported connectors upon request. Examples of such databases:

  • Google BigQuery
  • Snowflake
  • Vertica
  • Exasol
  • AWS Athena
  • Apache Drill

Possibility of connection to SSAS or Azure Analysis Services Tabular Model

Potentially SeekTable's reporting engine can generate MDX (or DAX in case of Tabular Model) in the same way as this happens for SQL sources; only blocker is lack of .NET Core support for ADOMD.NET client library - yes that's shame that Microsoft products don't support each other yet.

We have experimented a bit with 3rd party XMLA-over-HTTP client library and for now this is only way how SeekTable can connect to SSAS (or any other XMLA-compatible OLAP server). However this approach doesn't work for Azure Analysis Services because it is not available with XMLA over HTTP protocol (yet). If you're interested in usage of Analysis Services with SeekTable please contact us.


Edit table data and write back to a database

In case of non-aggregated reports (flat table type) it might be useful to have a possiblity to edit values directly from the report.

SeekTable is a reporting tool and its primary purpose is data visualization. However, in case of SQL data source potentially it is possible to have a capability to edit record values or delete rows.

If you're insterested in this feature please let us know.