Reference

Authentication Table dialect

Description

No description available [API reference]

Instructions

Apache IoTDB (table) JDBC from Power BI, SQL Server Linked Server via ZappySys Data Gateway, Crystal Reports, SSRS, Azure Data Factory, and other ODBC tools.

  1. Same host/port as tree. Append sql_dialect=table (already in this URL).
  2. Fill user and password. Table dialect uses SHOW TABLES / relational SQL.
  3. Finish the wizard. Then click Test Connection on the DSN Main UI (the wizard does not run Test Connection).
  4. Done. You can query from C#, Python, PowerShell, and ODBC apps.

Parameters

Parameter Required Default value Options
Name: DriverFilePaths

Label: JDBC driver file(s)

Filled by the wizard after download. Separate multiple JARs with a semicolon (e.g. C:\ZappySys\Jdbc\MyConnector\driver.jar). 		YES C:\ZappySys\Jdbc\Apache IoTDB\iotdb-jdbc-2.0.8-jar-with-dependencies.jar
Name: HostName

Label: Host

JDBC host name or IP (e.g. MyHostName). 		YES MyHostName
Name: Port

Label: TCP port

JDBC port (e.g. 6667). 		YES 6667
Name: DriverClass

Label: Driver class

Optional. Leave blank to auto-detect from the JAR unless SPI is ambiguous (e.g. org.apache.iotdb.jdbc.IoTDBDriver). 		org.apache.iotdb.jdbc.IoTDBDriver
Name: SqlDialect

Label: SQL dialect

IoTDB SQL dialect (e.g. Table from the dropdown). 		table
Name Value
Notset
Table table
Tree tree
Name: UserName

Label: User name

Database user. Leave empty if the server allows anonymous JDBC.
Name: Password

Label: Password

Database password. Leave empty if no password is required.