CData JDBC Driver for SugarCRM models SugarCRM modules as relational Tables.

Table definitions are dynamically retrieved. The driver 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, will immediately be reflected when you connect using the driver.

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

This section shows the sample table definitions that are included in the SugarCRM development environment.