Ready to get started?

Learn more about SuiteCRM Connectivity Solutions

Learn More

SuiteCRM Integration Guides and Tutorials

A list of guides and tutorials for connecting to and working with live SuiteCRM data.

CData Software connectivity tools provide access to live SuiteCRM data from popular BI, analytics, ETL, and custom applications, offering our customers access to their data wherever they want. Below you will find a list of guides and tutorials for integrating with live SuiteCRM data.

Integration Use-Cases

Click below to jump to articles related to specific integration use-case.

Business Intelligence & Analytics


ProductTechnologyArticle Title
Alteryx DesignerODBCPrepare, Blend, and Analyze SuiteCRM in Alteryx Designer
Amazon QuickSightCloud HubBuild Interactive Dashboards from SuiteCRM in Amazon QuickSight
Aqua Data StudioJDBCConnect to SuiteCRM in Aqua Data Studio
BirstJDBCBuild Visualizations of SuiteCRM in Birst
BIRTJDBCDesign BIRT Reports on SuiteCRM
Clear AnalyticsODBCBuild Charts with SuiteCRM in Clear Analytics
Microsoft ExcelExcelExcel Spreadsheet Automation with the QUERY Formula
DBxtraODBCBuild Dashboards with SuiteCRM in DBxtra
DomoODBCCreate Datasets from SuiteCRM in Domo Workbench
Dundas BIODBCBuild Dashboards with SuiteCRM in Dundas BI
FineReportJDBCFeed SuiteCRM into FineReport
Google Data StudioCloud HubCreate Reports from SuiteCRM in Google Data Studio
IBM Cognos BIODBCCreate Data Visualizations in Cognos BI with SuiteCRM
JasperServerJDBCCreate SuiteCRM Reports on JasperReports Server
Jaspersoft BI SuiteJDBCConnect to SuiteCRM in Jaspersoft Studio
JReport DesignerJDBCIntegrate with SuiteCRM in JReport Designer
KlipfolioCloud HubCreate SuiteCRM-Connected Visualizations in Klipfolio
KNIMEJDBCEnable the SuiteCRM JDBC Driver in KNIME
LINQPadADO.NETWorking with SuiteCRM in LINQPad
Power BI DesktopPower BIAuthor Power BI Reports on Real-Time SuiteCRM
Power BI OnlineCloud HubVisualize Live SuiteCRM in the Power BI Service
Microsoft SSASADO.NETBuild an OLAP Cube in SSAS from SuiteCRM
MicroStrategyJDBCUse the CData JDBC Driver for SuiteCRM in MicroStrategy
OBIEEJDBCSuiteCRM Reporting in OBIEE with the SuiteCRM JDBC Driver
pandasPythonUse pandas to Visualize SuiteCRM in Python
Pentaho Report DesignerJDBCIntegrate SuiteCRM in the Pentaho Report Designer
QlikViewODBCConnect to and Query SuiteCRM in QlikView over ODBC
RJDBCAnalyze SuiteCRM in R
RapidMiner JDBCConnect to SuiteCRM in RapidMiner
SAP Business ObjectsJDBCCreate an SAP BusinessObjects Universe on the CData JDBC Driver for SuiteCRM
SAP Crystal ReportsJDBCPublish Reports with SuiteCRM in Crystal Reports
SAP LumiraAPI ServerConsume SuiteCRM OData Feeds in SAP Lumira
SASODBCUse the CData ODBC Driver for SuiteCRM in SAS for Real-Time Reporting and Analytics
SisenseJDBCVisualize Live SuiteCRM in Sisense
Spago BIJDBCConnect to SuiteCRM in SpagoBI
TableauTableauVisualize SuiteCRM in Tableau Desktop
Tableau OnlineCloud HubBuild SuiteCRM Visualizations in Tableau Online
Tableau ServerTableauPublish SuiteCRM-Connected Dashboards in Tableau Server
TIBCO SpotfireADO.NETVisualize SuiteCRM in TIBCO Spotfire through ADO.NET
TIBCO Spotfire ServerJDBCOperational Reporting on SuiteCRM from Spotfire Server
VisioODBCLink Visio Shapes to SuiteCRM

Back to top

ETL & Replication


ProductTechnologyArticle Title
Amazon RedshiftCData SyncAutomated Continuous SuiteCRM Replication to Amazon Redshift
Amazon S3CData SyncAutomated Continuous SuiteCRM Replication to Amazon S3
Apache CamelJDBCIntegrate with SuiteCRM using Apache Camel
Apache CassandraCData SyncAutomated Continuous SuiteCRM Replication to Apache Cassandra
Apache NiFiJDBCBridge SuiteCRM Connectivity with Apache NiFi
AWS GlueJDBCConnect to SuiteCRM in AWS Glue Jobs Using JDBC
BIMLSSISUse Biml to Build SSIS Tasks to Replicate SuiteCRM to SQL Server
CloverDXJDBCConnect to SuiteCRM in CloverDX (formerly CloverETL)
CSVCData SyncAutomated Continuous SuiteCRM Replication to Local Delimited Files
IBM DB2CData SyncAutomated Continuous SuiteCRM Replication to IBM DB2
FoxProODBCWork with SuiteCRM in FoxPro
Google BigQueryCData SyncAutomated Continuous SuiteCRM Replication to Google BigQuery
Google Cloud SQLCData SyncAutomated Continuous SuiteCRM Replication to Google Cloud SQL
Google Data FusionJDBCBuild SuiteCRM-Connected ETL Processes in Google Data Fusion
Heroku / Salesforce ConnectCData SyncReplicate SuiteCRM for Use in Salesforce Connect
HULFT IntegrateJDBCConnect to SuiteCRM in HULFT Integrate
Informatica CloudJDBCIntegrate SuiteCRM in Your Informatica Cloud Instance
Informatica PowerCenterJDBCCreate Informatica Mappings From/To a JDBC Data Source for SuiteCRM
Jaspersoft ETLJDBCConnect to SuiteCRM in Jaspersoft Studio
Microsoft AccessCData SyncAutomated Continuous SuiteCRM Replication to Microsoft Access
Microsoft Azure TablesCData SyncAutomated Continuous SuiteCRM Replication to Azure SQL
Microsoft ExcelExcelTransfer Data from Excel to SuiteCRM
MongoDBCData SyncAutomated Continuous SuiteCRM Replication to MongoDB
MySQLCData SyncAutomated Continuous SuiteCRM Replication to MySQL
Oracle Data IntegratorJDBCETL SuiteCRM in Oracle Data Integrator
Oracle DatabaseCData SyncAutomated Continuous SuiteCRM Replication to Oracle
petlPythonExtract, Transform, and Load SuiteCRM in Python
PostgreSQLCData SyncAutomated Continuous SuiteCRM Replication to PostgreSQL
Replicate to CSVPowerShellReplicate SuiteCRM to MySQL with PowerShell
SnowflakeCData SyncAutomated Continuous SuiteCRM Replication to Snowflake
SQL ServerCData SyncAutomated Continuous SuiteCRM Replication to SQL Server
SQLiteCData SyncAutomated Continuous SuiteCRM Replication to SQLite
TalendJDBCConnect to SuiteCRM and Transfer Data in Talend
UiPath StudioODBCCreate an RPA Flow that Connects to SuiteCRM in UiPath Studio

Back to top

Data Virtualization



Back to top

Software Development


ProductTechnologyArticle Title
.NET ChartsADO.NETDataBind Charts to SuiteCRM
.NET QueryBuilderODBCRapidly Develop SuiteCRM-Driven Apps with Active Query Builder
Angular JSAPI ServerUsing AngularJS to Build Dynamic Web Pages with SuiteCRM
Apache SparkJDBCWork with SuiteCRM in Apache Spark Using SQL
AppSheetCloud HubCreate SuiteCRM-Connected Business Apps in AppSheet
Microsoft Azure Logic AppsAPI ServerTrigger SuiteCRM IFTTT Flows in Azure App Service
ColdFusionJDBCQuery SuiteCRM in ColdFusion
DashPythonUse Dash & Python to Build Web Apps on SuiteCRM
DevExpressADO.NETDataBind SuiteCRM to the DevExpress Data Grid
EF - Code FirstADO.NETAccess SuiteCRM with Entity Framework 6
EF - LINQADO.NETLINQ to SuiteCRM
EF - MVCADO.NETBuild MVC Applications with Connectivity to SuiteCRM
Filemaker ProJDBCBidirectional Access to SuiteCRM from FileMaker Pro
GoODBCWrite a Simple Go Application to work with SuiteCRM on Linux
Google Apps ScriptCloud HubConnect to SuiteCRM in Google Apps Script
HibernateJDBCObject-Relational Mapping (ORM) with SuiteCRM Entities in Java
IntelliJJDBCConnect to SuiteCRM in IntelliJ
JBossJDBCConnect to SuiteCRM from a Connection Pool in JBoss
JDBIJDBCCreate a Data Access Object for SuiteCRM using JDBI
JRubyJDBCConnect to SuiteCRM in JRuby
NodeJSAPI ServerQuery SuiteCRM from Node.js
NodeJSCloud HubQuery SuiteCRM as a MySQL Database in Node.js
NodeJSJDBCQuery SuiteCRM through ODBC in Node.js
PHPCloud HubAccess SuiteCRM in PHP through the Cloud Hub
PHPODBCNatively Connect to SuiteCRM in PHP
PowerShellPowerShellPipe SuiteCRM to CSV in PowerShell
PowerBuilderADO.NETConnect to SuiteCRM from PowerBuilder
PyCharmODBCUsing the CData ODBC Driver for SuiteCRM in PyCharm
PythonODBCConnect to SuiteCRM in Python on Linux/UNIX
RubyODBCConnect to SuiteCRM in Ruby
SAP UI5API ServerIntegrate Real-Time Access to SuiteCRM in SAPUI5 MVC Apps
ServoyJDBCBuild SuiteCRM-Connected Apps in Servoy
SQLAlchemyPythonUse SQLAlchemy ORMs to Access SuiteCRM in Python
TomcatJDBCConfigure the CData JDBC Driver for SuiteCRM in a Connection Pool in Tomcat
VCL App (RAD Studio)FireDACBuild a Simple VCL Application for SuiteCRM
WebLogicJDBCConnect to SuiteCRM from a Connection Pool in WebLogic

Back to top

Data Management



Back to top

Workflow Automation



Back to top