JDBC Authentication

DATABASICS authentication can be established via the username/password or directly from the JDBC URL template. Below is a full reference to the allowed authentication methods.

Authentication Method	JDBC URL String	Username	Password

Authentication Method	JDBC URL String	Username	Password
Basic Auth	jdbc:data-basics:rest:https://api.data-basics.net/apihub/apis;logFile=<Local Drive>:\\DatabasicsJDBC\\Log\\log.txt	<String> Provided by DATABAISCS	<String> Provided by DATABASICS
API Key via Username and Password fields	jdbc:data-basics:rest:https://api.data-basics.net/apihub/apis;logFile=<Local Drive>:\\DatabasicsJDBC\\Log\\log.txt	@<String> For this method of authentication the username will be the exact string. ‘@api-key’	<String> Actual API Key
API User and DATABASICS Site User via Username and Password fields	jdbc:data-basics:rest:https://api.data-basics.net/apihub/apis;companyId=<CompanyId>;appId=DBTEAdmin;logFile=<Local Drive>:\\DatabasicsJDBC\\Log\\log.txt	@<String> API Username and Password separated by comma, then base64 encoded. (apiUser:password ← base64 encoded) For the username be sure to prefix the @ symbol to the base64 encoded string	<String> DATABASICS API Site Username and Password separated by comma, then base64 encoded. (siteUser:password ← base64 encoded)
API Key via JDBC URL String	jdbc:data-basics:rest:https://api.data-basics.net/apihub/apis;api-key=<apiKey>;logFile=<Local Drive>:\\DatabasicsJDBC\\Log\\log.txt	N/A	N/A
API User and DATABASICS Site User via JDBC URL String	jdbc:data-basics:rest:https://api.data-basics.net/apihub/apis;companyId=<CompanyId>;appId=DBTEAdmin;apiAuthCode=<ApiUser:ApiPassword(base64Encoded)>;siteAuthCode=<siteUser:SitePassword(base64Encoded)>;logFile=<Local Drive>:\\DatabasicsJDBC\\Log\\log.txt	N/A	N/A