Self-hosted SeekTable setup

You can install and run SeekTable on-premise with docker:

Linux (recommended: Ubuntu Server 16.04 or 18.04)
Mac OS
Windows (7/8/10 x64): use Oracle VirtualBox to run a VM with Linux or Docker Toolbox for Windows

You can run self-hosted SeekTable in cloud with a few clicks from AWS marketplace.

Docker
Kubernetes

Ensure that docker is installed. If not: Docker CE setup instructions.
Ensure that docker-compose (or analog) is installed. If not: install Docker Compose as a container.
Download SeekTable's configuration for docker-compose: docker-compose.tar.gz and extract the files:
```
$ mkdir -p /opt/seektable
$ cd /opt/seektable
$ wget https://www.seektable.com/docker-compose.tar.gz -P ./
$ tar xf docker-compose.tar.gz
```
ODBC Driver for BigQuery is not included into the default distribution.
To enable BigQuery connector use this configuration: https://www.seektable.com/docker-compose-bigquery.tar.gz
Optional: edit docker-compose.seektable.env file to configure an app base URL and other self-hosted SeekTable system settings.
Important: ensure that server's firewall allows incoming connections for ports 80 and 5200. It is possible to use a single port (80 or 443) with help of a reverse proxy server.
Run the following command:
```
$ sudo docker-compose up
```
Add -d option if you want to run SeekTable in the background and start it up automatically on reboot.
Now you can open http://your_server_hostname_or_ip/ and create accounts in your local SeekTable installation.
If your installation is accessible from internet it is recommended to follow security best practices.

Download SeekTable configuration for docker-compose: docker-compose.tar.gz.
Use kubernetes/kompose to deploy SeekTable on Kubernetes directly with kompose up, or kompose convert to convert SeekTable's docker-compose.yml to files that you can use with kubectl.
SeekTable uses these default ports mapping:
- Container seektable/seektable: internal 5000 → external 80
- Container seektable/pivotdataservice: internal 5000 → external 5200
If you need to use another external port for 'pivotdataservice' (instead of 5200) the following environment variable should be specified for seektable/seektable container (specify port that you use instead of 5200):
```
SeekTable_ST:PivotDataService:ExternalBaseUrl=//@host:5200/
```
SeekTable expects that containers can use these internal endpoints to reach each other (default configuration for docker-compose):
- http://seektable:5000/
- http://pivotdataservice:5000/
You may change these URLs in this way:
- Container seektable/seektable env variable:
```
SeekTable_ST:PivotDataService:InternalBaseUrl=http://pivotdataservice:5000/
SeekTable_ST:PivotDataService:SchemaAccessToken=YOUR_INSTALLATION_UNIQUE_ID
```
- Container seektable/pivotdataservice env variable:
```
PivotDataService_PivotDataService:CubeProviders:0:Url=http://seektable:5000/api/cube/schema?access_token=YOUR_INSTALLATION_UNIQUE_ID
```

Upgrade: to refresh downloaded images run $ sudo docker-compose pull, or use docker pull command for all SeekTable images (listed below). It is recommended to use latest version of docker images published on Docker Hub.
Scalability notice: standard version of self-hosted SeekTable uses Sqlite and not designed for multiple containers (replicas) per service. If you are interested in the high-availability version that supports horizontal scale please contact us.

In case of complications or questions please contact support@seektable.com.

Usage conditions

SeekTable installation uses 2 docker images:

seektable/seektable FREE	This is main SeekTable web application. You can use this image for FREE under the following conditions: installation should be used/accessed only by employees/customers of your company; you cannot make it public (accessible for everyone). usage of modified image is prohibited (changes in any application files including css/js etc) your on-premise SeekTable deployment is activated automatically; we may contact you by email and ask for the feedback. You can change usage conditions or unlock additional SeekTable features with paid subscriptions.
seektable/pivotdataservice FREE with trial notices/limitations OR $499/year	PivotData microservice is a reporting engine used by SeekTable (both products are developed & maintained by the same team). This engine is a separate commercial product that requires per-deployment license key, but when it is used as part of self-hosted SeekTable special usage conditions are applicable: PivotData microservice that runs in trial mode (without a license key) can be used for any period of time in production use. You cannot use PivotData microservice as a separate product (call its web API directly). In the trial mode special notice is displayed at the bottom of pivot tables, and max number of cells with values is limited by 100k. You can hide trial notice / remove report size limitation with an appropriate self-hosted SeekTable subscription (see below).

seektable/seektable FREE

This is main SeekTable web application. You can use this image for FREE under the following conditions:

installation should be used/accessed only by employees/customers of your company; you cannot make it public (accessible for everyone).
usage of modified image is prohibited (changes in any application files including css/js etc)
your on-premise SeekTable deployment is activated automatically; we may contact you by email and ask for the feedback.

You can change usage conditions or unlock additional SeekTable features with paid subscriptions.

seektable/pivotdataservice FREE with trial notices/limitations OR $499/year

PivotData microservice is a reporting engine used by SeekTable (both products are developed & maintained by the same team). This engine is a separate commercial product that requires per-deployment license key, but when it is used as part of self-hosted SeekTable special usage conditions are applicable:

PivotData microservice that runs in trial mode (without a license key) can be used for any period of time in production use.
You cannot use PivotData microservice as a separate product (call its web API directly).
In the trial mode special notice is displayed at the bottom of pivot tables, and max number of cells with values is limited by 100k. You can hide trial notice / remove report size limitation with an appropriate self-hosted SeekTable subscription (see below).

Paid subscriptions for self-hosted SeekTable advanced features

System/users admin	Administrator role for one or several accounts. Administrator can: add/update/delete user accounts, login-as-user restore account data from XML backup enable "admin" role for any number of users system setup: disable public sign-up (users can be added only by admin), disable self-delete for user accounts, disable file upload / add cube for non-admins	$499 / year
White-label mode Requires: system admin	Use your company logo/brand instead of SeekTable, hide "Generated by" and "Powered by" notices in app/exports/shared reports, hide links to seektable.com website, set custom footer content for emails and PDF export, customize SeekTable app visual styles by adding your own CSS, localize app UI (customize or translate the interface to non-English language).	$499 / year
PivotData Microservice license	Activates a license key for SeekTable's reporting engine: removes trial notices at the bottom of pivot tables / max 100k values limitation.	$499 / year
Single sign-on (SSO)	Ability to setup SSO with WS-Federation (Active Directory with ADFS, Azure Directory etc). Support of SAML2 or custom SSO flow may be added upon request.	$499 / year
Team sharing	Team owner role for high-powered user(s) who is creating the data and sharing it with others. Team owner can: manage team members share cubes/reports to team members with an access control Only user who creates and shares cubes/reports need to have a paid subscription; viewers are free accounts. Number of 'viewers' in the team is not limited. "Team sharing" subscription can be enabled for unlimited number of users with a fixed price.	$25 / month / user when billed anually $299/year/user
Advanced publishing/embedding	Ability to use advanced features for reports published to web (public links): interactive report view: pagination, sort by labels/values, inputs for parameters enable exports (PDF, CSV, Excel etc), extend export limit for rows enable chart legend and hide table below the chart customize styles with CSS rules embed reports in a secure way (with JWT auth) apply report parameters from the host page without IFRAME reload auto refresh report every N minutes Only users who create and publish the reports need to have a paid subcription. There are no any limitations on the number of 'viewers'. "Advanced publishing" subscription can be enabled for unlimited number of users with a fixed price.	$25 / month / user when billed anually $299/year/user
Audit Log	Collects information about all actions in the system performed by end-users: cubes/reports creation, changes (with diffs), report views and actions with reports (filtering, sorting, export etc), published reports views and actions, errors. Only users with "admin" rights can access this audit trail.	Request pricing
Commercial Support / Integration Project	It is possible to purchase special support packages to get guaranteed technical support with SeekTable deployment, setup or troubleshooting (including bug fix SLA). Integration services of any kind may be provided by SeekTable outsourcing partner on the 'time & material' basis.	Request pricing

Request 14 Day Trial
Trial period may be extended if you need more time for the decision-making process.