Connections
Admin users can create a connection to a data source in the "Add Data Connection" section. Once a connection is created it can be used within all dashboards you wish to apply to.
Pulse supports any database with a JDBC driver, this includes kdb, postgresql, mysql, ms sql, clickhouse and 30+ databases.
If you want to use kdb streaming data, you must create a kdb streaming connection.
Caching 
All queries are cached and shared over all users where permissions allow. They are cached for the time period specified in each query.
For example if there is a panel with an SQL query "select date,price from t" to database A with a time period of 5 seconds. No matter how many users are viewing that dashboard, only one query will go to database A every 5 seconds.
Streaming
 kdb+ |
Websocket |
 Binance |
Top Supported Databases
kdb+ |
mySQL |
questDB |
PostgreSQL |
TimeScale |
Redis |
Microsoft SQL Server |
H2 Database |
Supported Databases
Clickhouse |
DuckDB |
TDengine |
DB2 |
Informix |
DolphinDB |
Derby |
HSQLDB |
SQLite |
CSV |
MongoDB |
InfluxDB |
Apache Kylin |
Snowflake |
Elastic Search |
JDBC |
Sqream |
Apache Calcite Avatica |
Teradata |
MS Access |
NuoDB |
SAP HANA |
Gemfire XD |
Snappy Data Tibco |
Spark Hive |
Kyubi Hive |
Yandex Clickhouse |
Neo4J |
Presto |
Trino |
Apache Solr |
Apache Ignite |
Omnisci |
CrateDB |
Other
REST |
JSON |
XML |
Python |
R |
Email |
FRED |