ODBC Driver for Kintone

Build 24.0.9060

Data Model

The driver models the Kintone API as relational Tables, Views, and Stored Procedures.

Tables

Using the driver, you can work with all the tables in your account. The table schemas can be static or dynamic. The Comments table has a static schema with fixed columns, while other tables are dynamic, reflecting changes in the metadata -- when you connect, the driver retrieves table metadata from Kintone to generate the table schemas.

Static schemas are defined in schema files, which makes them easy to extend. Edit the schema file to customize the column behavior of the static Comments table, to change the data type for example. The schema files are located in the db subfolder of the driver installation folder.

Sub-Tables

In some Kintone apps, the user can add custom fields containing many records. The driver models these fields as dynamic subtables reflecting your changes.

Stored Procedures

Stored Procedures are function-like interfaces to Kintone. They can be used to search, update, and modify information in Kintone. For example, use stored procedures to execute operations on apps or work with files.

Views

The driver models apps in the static Apps view.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060