11.1 Choose an Integration Method
Choose an integration method for the project language, ingestion pattern, and deployment environment.
Selection Criteria
| Requirement | First option to consider |
|---|---|
| Native C/C++ collector | SQLCLI |
| ODBC manager/DSN application | ODBC |
| Java/Spring | JDBC |
| Python analytics/automation | machbaseapi |
| C#/VB.NET | .NET Connector |
| Go collector/service | Native machgo or database/sql |
| Node.js/TypeScript backend | @machbase/ts-client |
| R analytics | Machbase ODBC driver with RODBC |
| Bulk file ingestion/export | machloader, csvimport, csvexport |
| Continuous bulk TAG/LOG ingestion | The chosen SDK’s Append API |
Do not connect a browser directly to port 5656. Execute queries in a backend and return only the required results.
Decision Sequence
- Choose an official driver maintainable in the application language.
- Check port 5656 connectivity, operating system support, and runtime compatibility.
- Identify required SQL, prepared statement, Append, and transaction features.
- Check actual support in the SDK Feature Matrix.
- Round-trip sample timestamps, NULLs, numbers, and strings.
- Load-test target row sizes, concurrent connections, and batch sizes.
Do not choose a driver on Append support alone. Verify flush latency, server error responses, reconnection, and failed-row handling in the actual SDK. For TRANSACTION DML, check explicit transaction support. Do not assume TAG/LOG Append shares its rollback scope.
Detailed Documentation by Topic
| Topic | Detailed documentation |
|---|---|
| SDK installation, connections, APIs, complete code | SDK pages in this chapter |
| Shared authentication, binding, transactions, retries | Common Integration Concepts |
| SDK feature support | SDK Feature Support |
| SQL, configuration, command-line details | Chapter 16 Reference |
| Choose ingestion/export methods | Data Ingestion and Export |
After choosing an integration method, run its SDK installation and connection examples. Check both documented versions and actual deployment artifacts for feature support.
Last updated on