Tableau Connector for SuiteCRM

Build 22.0.8462

SuiteCRM V4.1 Data Model

CData Tableau Connector for SuiteCRM models SuiteCRM modules as relational database.

Tables

Table definitions are dynamically retrieved. The connector connects to SuiteCRM and gets the list of tables and the metadata for the tables by calling the appropriate Web services. Any changes you make to your SuiteCRM 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 connector.

The connector can also expose custom modules on your SuiteCRM account that are not mentioned in the . 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 SuiteCRM development environment.

Query Processing

The connector offloads as much of the SELECT statement processing as possible to SuiteCRM and then processes the rest of the query in memory; API limitations and requirements are documented in this section.

See SupportEnhancedSQL for more information on how the connector circumvents API limitations with in-memory client-side processing.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462