ADO.NET Provider for SugarCRM

Build 23.0.8839

Data Model

The CData ADO.NET Provider for SugarCRM models SugarCRM modules as relational tables.

Table definitions are dynamically retrieved. The provider connects to SugarCRM and gets the list of tables and the metadata for the tables by calling the appropriate Web services.

Any changes you make to your SugarCRM account, such as adding a new table, or adding new columns, or changing the data type of a column, are immediately reflected when you connect using the provider.

The provider can also expose custom modules on your SugarCRM account that are not mentioned in the Tables section. You can query these custom modules like any other table. Additionally, you can query custom fields of standard modules.

The following sections show the sample table definitions that are included in the SugarCRM development environment.

Tables

The provider models the SugarCRM development environment sample tables, such as Account, Asset, and Campaign as relational Tables.

Views

The Audit module is modeled as a read-only view. See Views for more information.

Stored Procedures

Stored Procedures are function-like interfaces to SugarCRM. They can be used to download SugarCRM files and create custom schemas.

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