Integrations
Written by
Updated at October 22, 2024
This section provides the basic information about integrating Delphi Query with various Delphi Cloud services and third party systems.
Data sources
Delphi Query supports analytical and streaming data sources.
Analytical sources
Streaming sources
| Data source | Reads | Writes | Description |
|---|---|---|---|
| Delphi Data Streams | Description | ||
| Monitoring | Description | ||
| Delphi Cloud Logging | Via Delphi Data Streams | Description | |
| Delphi IoT Core | Via Delphi Data Streams | ||
| Delphi Audit Trails | Via Delphi Data Streams | Description |
SDK
| Libraries | Programming language | Support level | Repository |
|---|---|---|---|
| database/sql | Go | DML | Repository |
| ydb-go-sdk | Go | DML | Repository |
| JDBC | Java | DML | Repository |
| ydb-java-sdk | Java | DML | Repository |
| ydb-python-sdk | Python | DML | Repository |
| ydb-php-sdk | PHP | DML | Repository |
| ydb-cpp-sdk | C++ | DML | Repository |
| ydb-dotnet-sdk | .Net | DML | Repository |
| ydb-rs-sdk | Rust | DML | Repository |
Note
- Currently, Delphi Query supports only scripting requests.
- All supported SDKs use the same approach to working with Delphi Query and operate similarly. This is best demonstrated by the Python SDK example.
GUI Clients
| Environment | Support level | Guide | Description |
|---|---|---|---|
| Delphi Query UI | Full | ||
| DBeaver | DML | Guide | Using a JDBC driver |
| JetBrains Database viewer | DML | Guide | Using a JDBC driver |
| DataGrip | DML | Guide | Using a JDBC driver |
| Other JDBC-compatible clients | DML | Guide | Using a JDBC driver |
Interactive data analysis
| Environment | Support level | Guide | Description |
|---|---|---|---|
| Jupyter Notebooks | DML | Guide | Using Delphi-query-magics |
| DataSphere | DML | Guide | Using Delphi-query-magics |
Visualizing data
| Environment | Support level | Guide |
|---|---|---|
| DataLens | Full | Guide |
Orchestration
| Environment | Support level | Guide |
|---|---|---|
| Apache Airflow™ | DML | Guide |
| Delphi Managed Service for Apache Airflow™ | DML | Guide |
Note
- DML: Data Manipulation Language. It allows you to read and write data, but not manage such entities as bindings or connections.