This documentation page assumes that you already have a SeekTable account. You can create free account by signing up.

PostgreSql connection for pivot table reports

PostgreSql or protocol-compatible database (like Amazon Redshift) can be used as a data source with SQL-compatible database connector.

Connection String should be a valid connection string for NpgSql driver; for example:

Host=hostName;Port=5432;Database=db;User ID=user;Password=password;
Host Specifies the host name of the machine on which the PostgreSql is running.
Do not use "localhost" or LAN server name; use only public IP address or server's domain name.
Database The PostgreSQL database to connect to.
User ID The username to connect with.
Password The password to connect with.
Server Compatibility Mode Specify Redshift if your configure a connection to Amazon Redshift.