The Sugar CRM Adapter models SugarCRM modules as relational tables.

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

Any changes you make to your Sugar CRM 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 adapter.

The adapter can also expose custom modules on your Sugar CRM 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 adapter models the Sugar CRM 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 Sugar CRM. They can be used to download Sugar CRM files and create custom schemas.