Datasources
Datasources are a type of PocketQuery Entity that defines where data should be fetched from. They can either be JDBC databases or REST APIs.
Datasource information is stored encrypted in our database. If you ever lose access to your Datasource, Lively Apps support cannot retrieve any data or credentials for you.
Security Advice
If your Datasource requires authentication, make sure to create a new user specifically for PocketQuery in that external service. Apply the principle of least privilege and make sure this user only has read access to data that you actually want to display with PocketQuery.
JDBC/SQL Datasource Types
JDBC/SQL Datasources use a JDBC driver to connect to a given Database. They typically require the following fields:
JDBC URLUsernamePassword
Currently, the following types of JDBC/SQL Datasources are available:
Type | JDBC URL Example |
|---|---|
MySQL 5 |
|
MySQL 8 |
|
PostgreSQL |
|
Microsoft SQL Server (MSSQL) |
|
MariaDB |
|
Oracle |
|
IBM DB2 |
|
SAP HANA |
|
Amazon Redshift |
|
|
REST Datasource Types
REST Datasources supports different kinds of authentication. For all REST Datasources a Base URL is required.
PocketQuery can also accept XML results from REST Datasources. If PocketQuery receives back an XML response from a Datasource, it will attempt to convert it into JSON before processing it further. For more information, enable debug mode in your PocketQuery macro.
REST Custom
Allows you to add custom HTTP Headers to your request which can be used for authentication. Also allows you to define custom URL parameters that will be added to every request.
REST Basic
Just like with JDBC/SQL Datasources, this type of datasource lets you specify a Username and a Password. This will be encoded and put into in the Authorization for every request to this Datasource.
If you want to learn more about HTTP Basic Authentication, click here.
REST OAuth2
PocketQuery also supports OAuth2 token-based authentication. This method requires an Authentication Server that generates temporal Access Tokens, which are used to authenticate to your datasource. Refer to the OAuth2 Datasource article to learn more about PocketQuery OAuth2 datasources.
If you are interested in resource limits related to Datasource, check out this article.