JDBC Driver for SAP Business One

Build 21.0.8137

Data Model

The CData JDBC Driver for SAP Business One connects to SAP Business One Service Layer, an OData service, to model entities in relational Tables and Views. The table definitions are dynamically obtained from the SAP Business One Service Layer. Any changes in the metadata, such as added or removed columns or changes in data type, can be loaded by reconnecting.


The driver models the writable entity sets and singletons described in the service metadata document as bidirectional Tables.


Some OData entities can only be accessed through Navigation Properties. By default, the driver models navigation properties as separate views. You can disable this behavior with NavigationPropertiesAsViews. See Views for more information on querying navigation properties.

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137