Act-On Integration Guides and Tutorials

Jerod Johnson
Director, Technology Evangelism

A list of guides and tutorials for connecting to and working with live Act-On data.

CData Software's connectivity tools enable users to connect directly to live Act-On data data from widely-used BI, analytics, ETL, and custom applications, ensuring that our customers can access their data wherever they desire. Below, you'll find a collection of guides and tutorials on integrating with live Act-On data.

Integration Use-Cases

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

Artificial Intelligence - agents, chatbots, and workflows (Claude, ChatGPT, n8n, crewAI, etc.)
Business Intelligence & Analytics - charting, reports, and more (Tableau, Power BI, Amazon QuickSight, etc.)
ETL & Replication - moving and replicating data (CData Sync, AWS Glue, Oracle Data Integrator, etc.)
Data Virtualization - retrieving and manipulating data (DbVisualizer, SQL Server PolyBase, etc.)
Software Development - developing custom applications (.NET, AngularJS, Ruby, Python, etc.)
Data Management - managing data (DBArtisan, RazorSQL, SQuirreL, etc.)
Workflow Automation - building automated workflows (SSIS, Power Automate, etc.)

Artificial Intelligence

Product	Technology	Article Title
Agentforce	Connect AI	Connecting Agentforce with Act-On Data
Azure AI Foundry	Connect AI	Use Azure AI Foundry to Talk to Your Act-On Data
Boomi AgentStudio	Connect AI	Integrating Boomi AgentStudio with Act-On Data
ChatGPT	Connect AI	Connect Act-On Data to ChatGPT
Claude Desktop	MCP Server	How to Query Live Act-On Data in Claude Desktop
Claude Code	Connect AI	How to Query Live Act-On in Claude Code
Claude.ai	Connect AI	Use Claude.ai to Talk to Your Act-On Data
Cline (VS Code)	MCP Server	How to Access Live Act-On Data in Visual Studio Code via Cline
crewAI	Connect AI	How to Connect to Live Act-On Data from crewAI Agents
Cursor	Connect AI	Integrate Cursor with Live Act-On Data
Databricks Agent Bricks	Connect AI	Use Databricks Agent Bricks to Talk to Act-On Data
Dataiku	Connect AI	Integrating Dataiku with Act-On Data
Flowise	Connect AI	How to Connect Flowise AI Agents to Live Act-On Data
Gemini (CLI)	Connect AI	How to Connect to Live Act-On Data from Gemini CLI
Gemini Enterprise	Connect AI	How to Connect to Live Act-On Data from Gemini Enterprise
Google ADK	Connect AI	How to Connect to Live Act-On Data from Google ADK Agents
Google Vertex AI	Connect AI	Integrate Google Vertex AI Agents with Live Act-On Data
Gumloop	Connect AI	Integrating Gumloop with Act-On Data
IBM watsonx Orchestrate	Connect AI	Build AI Agents with Act-On Data in IBM watsonx Orchestrate
Langchain	Connect AI	Integrating LangChain with Act-On Data
LangGraph	Connect AI	Integrating LangGraph with Act-On Data
Mastra	Connect AI	Connecting Mastra with Act-On Data
Mistral (Le Chat)	Connect AI	Connect Act-On Data to Mistral
MS Copilot Studio	Connect AI	Connect Act-On Data to Microsoft Copilot Studio
n8n	Connect AI	Build Act-On-Connected Workflows and AI Agents in n8n
OpenAI SDK (Python)	Connect AI	How to Connect to Live Act-On Data from OpenAI Python Applications
Python MCP Server	Python	Connect Act-On to AI Assistants With the CData Python MCP Server
Relevance AI	Connect AI	Build Agents in Relevance AI with Access to Live Act-On Data
Sourcegraph Amp	Connect AI	How to Connect to Live Act-On Data from Sourcegraph Amp

Business Intelligence & Analytics

Product	Technology	Article Title
Alteryx Designer	ODBC	Prepare, Blend, and Analyze Act-On in Alteryx Designer (ODBC)
Alteryx Designer	Connect AI	Work with Live Act-On Data in Alteryx Designer (Connect AI)
Amazon QuickSight	Connect AI	Build Interactive Dashboards from Act-On Data in Amazon QuickSight
Amazon SageMaker	Connect AI	Integrate Live Act-On data into Amazon SageMaker Canvas
Aqua Data Studio	JDBC	Connect to Act-On in Aqua Data Studio
AWS Databricks	JDBC	Process & Analyze Act-On Data in Databricks (AWS)
Azure Analysis Services	Connect AI	Model Act-On Data Using Azure Analysis Services
Birst	JDBC	Build Visualizations of Act-On in Birst
BIRT	JDBC	Design BIRT Reports on Act-On
Clear Analytics	ODBC	Build Charts with Act-On in Clear Analytics
Cognos Analytics (On-Prem)	Connect AI	Analyze Act-On Data in Cognos Analytics
DBxtra	ODBC	Build Dashboards with Act-On in DBxtra
Domo	ODBC	Create Datasets from Act-On in Domo Workbench
Dundas BI	ODBC	Build Dashboards with Act-On in Dundas BI
FineReport	JDBC	Feed Act-On into FineReport
Gecokboard	Connect AI	Create Dashboards and Visualize Live Act-On Data in Geckoboard
Google Sheets	Connect Spreadsheets	Access Live Act-On Data in Google Sheets
Grafana	Connect AI	Create Act-On-Connected Dashboards in Grafana
IBM Cognos BI	ODBC	Create Data Visualizations in Cognos BI with Act-On
Infragistics Reveal	Connect AI	Analyze Act-On Data in Infragistics Reval
JasperServer	JDBC	Create Act-On Reports on JasperReports Server
Jaspersoft BI Suite	JDBC	Connect to Act-On in Jaspersoft Studio
JReport Designer	JDBC	Integrate with Act-On in JReport Designer
Klipfolio	Connect AI	Create Act-On-Connected Visualizations in Klipfolio
KNIME	JDBC	Enable the Act-On JDBC Driver in KNIME
LINQPad	ADO.NET	Working with Act-On in LINQPad
Looker	Connect AI	Analyze Act-On Data in Looker
Looker Studio	Connect AI	Create Reports from Act-On Data in Looker Studio
Metabase	Connect AI	Create Interactive Act-On-Connected Metabase Dashboards
Microsoft Excel	Connect Spreadsheets	Access Live Act-On Data in Excel Desktop
Microsoft Excel for the Web	Connect Spreadsheets	Access Live Act-On Data in Excel for the Web
Microsoft SSAS	ADO.NET	Build an OLAP Cube in SSAS from Act-On
MicroStrategy	Connect AI	Connect to Live Act-On Data in MicroStrategy through Connect AI
MicroStrategy	JDBC	Use the CData JDBC Driver for Act-On in MicroStrategy
Microstrategy Desktop	JDBC	Use the CData JDBC Driver for Act-On in MicroStrategy Desktop
Microstrategy Web	JDBC	Use the CData JDBC Driver for Act-On in MicroStrategy Web
Mode Analytics	Connect AI	Create Act-On-Connected Visualizations in Mode
OBIEE	JDBC	Act-On Reporting in OBIEE with the Act-On JDBC Driver
pandas	Python	Use pandas to Visualize Act-On in Python
Pentaho Report Designer	JDBC	Integrate Act-On in the Pentaho Report Designer
Power BI Desktop	Power BI	Author Power BI Reports on Real-Time Act-On
Power BI Service	Connect AI	Visualize Live Act-On Data in the Power BI Service
Power Pivot	Connect AI	Access Act-On Data in Microsoft Power Pivot
Power Query	Connect AI	Access Act-On Data in Microsoft Power Query
Qlik Cloud	Connect AI	Create Apps from Act-On Data in Qlik Sense Cloud
QlikView	ODBC	Connect to and Query Act-On in QlikView over ODBC
R	JDBC	Analyze Act-On in R (JDBC)
R	ODBC	Analyze Act-On in R (ODBC)
RapidMiner	JDBC	Connect to Act-On in RapidMiner
Redash	Connect AI	Query, Visualize, and Share live Act-On Data in Redash
SAP Analytics Cloud	Connect AI	Analyze Act-On Data in SAP Analytics Cloud
SAP Business Objects	JDBC	Create an SAP BusinessObjects Universe on the CData JDBC Driver for Act-On
SAP Crystal Reports	JDBC	Publish Reports with Act-On in Crystal Reports (JDBC)
SAP Crystal Reports	Connect AI	Publish Reports with Act-On in Crystal Reports (Connect AI)
SAS	ODBC	Use the CData ODBC Driver for Act-On in SAS for Real-Time Reporting and Analytics
SAS JMP	ODBC	Use the CData ODBC Driver for Act-On in SAS JMP
SAS Viya	Connect AI	Analyze Live Act-On Data in SAS Viya
Sisense	JDBC	Visualize Live Act-On in Sisense
Spago BI	JDBC	Connect to Act-On in SpagoBI
Tableau	Tableau	Visualize Act-On in Tableau Desktop
Tableau	Connect AI	Visualize Act-On in Tableau Desktop (Connect AI)
Tableau Cloud	Connect AI	Build Act-On Visualizations in Tableau Cloud
Tableau Server	Tableau	Publish Act-On-Connected Dashboards in Tableau Server
ThoughtSpot	Connect AI	Model, Search, and Visualize Live Act-On Data in ThoughtSpot
TIBCO Spotfire	ADO.NET	Visualize Act-On in TIBCO Spotfire through ADO.NET
TIBCO Spotfire Server	JDBC	Operational Reporting on Act-On from Spotfire Server
Visio	ODBC	Link Visio Shapes to Act-On
Zoho Analytics	Connect AI	Create Act-On-Connected Dashboards in Zoho Analytics

ETL & Replication

Product	Technology	Article Title
Airbyte	Connect AI	Connect to Act-On Data in Airbyte ELT Pipelines
Amazon Redshift	CData Sync	Automated Continuous Act-On Replication to Amazon Redshift
Amazon S3	CData Sync	Automated Continuous Act-On Replication to Amazon S3
Apache Airflow	JDBC	Bridge Act-On Connectivity with Apache Airflow
Apache Camel	JDBC	Integrate with Act-On using Apache Camel
Apache Cassandra	CData Sync	Automated Continuous Act-On Replication to Apache Cassandra
Apache Kafka	CData Sync	Automated Continuous Act-On Replication to Apache Kafka
Apache NiFi	JDBC	Bridge Act-On Connectivity with Apache NiFi
Apache NiFi Batch Operations	JDBC	Perform Batch Operations with Act-On Data in Apache NiFi
AWS Glue	Connect AI	Build ETL Jobs with Act-On Data in AWS Glue Jobs
Azure Data Factory	Connect AI	Import Act-On Data Using Azure Data Factory
Azure Data Lake	CData Sync	Automated Continuous Act-On Replication to Azure Data Lake
Azure Synapse	CData Sync	Automated Continuous Act-On Replication to Azure Synapse
BIML	SSIS	Use Biml to Build SSIS Tasks to Replicate Act-On to SQL Server
CloverDX	JDBC	Connect to Act-On in CloverDX (formerly CloverETL)
Couchbase	CData Sync	Automated Continuous Act-On Replication to Couchbase
CSV	CData Sync	Automated Continuous Act-On Replication to Local Delimited Files
Databricks	CData Sync	Automated Continuous Act-On Replication to Databricks
ETL Validator	JDBC	How to Work with Act-On in ETL Validator
FoxPro	ODBC	Work with Act-On in FoxPro
Google AlloyDB	CData Sync	Automated Continuous Act-On Replication to Google AlloyDB
Google BigQuery	CData Sync	Automated Continuous Act-On Replication to Google BigQuery
Google Cloud SQL	CData Sync	Automated Continuous Act-On Replication to Google Cloud SQL
Google Data Fusion	JDBC	Build Act-On-Connected ETL Processes in Google Data Fusion
Google Data Fusion	Connect AI	Build Pipelines with Live Act-On Data in Google Cloud Data Fusion (CData Connect AI)
Heroku / Salesforce Connect	CData Sync	Replicate Act-On for Use in Salesforce Connect
HULFT Integrate	JDBC	Connect to Act-On in HULFT Integrate
IBM DB2	CData Sync	Automated Continuous Act-On Replication to IBM DB2
Informatica Cloud	JDBC	Integrate Act-On in Your Informatica Cloud Instance
Informatica PowerCenter	JDBC	Create Informatica Mappings From/To a JDBC Data Source for Act-On
Jaspersoft ETL	JDBC	Connect to Act-On in Jaspersoft Studio
Microsoft Access	CData Sync	Automated Continuous Act-On Replication to Microsoft Access
Microsoft Azure Tables	CData Sync	Automated Continuous Act-On Replication to Azure SQL
Microsoft Excel	Excel	Transfer Data from Excel to Act-On
Microsoft Power Automate	Connect AI	Build Act-On-Connected Automated Tasks with Power Automate (Desktop)
Microsoft OneLake	CData Sync	Automated Continuous Act-On Replication to Microsoft OneLake (Fabric}
MongoDB	CData Sync	Automated Continuous Act-On Replication to MongoDB
MySQL	CData Sync	Automated Continuous Act-On Replication to MySQL
Oracle Data Integrator	JDBC	ETL Act-On in Oracle Data Integrator
Oracle Database	CData Sync	Automated Continuous Act-On Replication to Oracle
Pentaho Data Integration	JDBC	Integrate Act-On in Pentaho Data Integration
petl	Python	Extract, Transform, and Load Act-On in Python
PostgreSQL	CData Sync	Automated Continuous Act-On Replication to PostgreSQL
Replicate to MySQL	PowerShell	Replicate Act-On to MySQL with PowerShell
SAP HANA	CData Sync	Automated Continuous Act-On Replication to SAP HANA
SingleStore	CData Sync	Automated Continuous Act-On Replication to SingleStore
SnapLogic	JDBC	Integrate Act-On with External Services using SnapLogic (JDBC)
SnapLogic	Connect AI	Integration with Act-On Data in SnapLogic (Connect AI)
Snowflake	CData Sync	Automated Continuous Act-On Replication to Snowflake
SQL Server	CData Sync	Automated Continuous Act-On Replication to SQL Server
SQL Server Linked Server	Connect AI	Connect to Act-On Data as a SQL Server Linked Server
SQLite	CData Sync	Automated Continuous Act-On Replication to SQLite
Talend	JDBC	Connect to Act-On and Transfer Data in Talend
UiPath Studio	ODBC	Create an RPA Flow that Connects to Act-On in UiPath Studio
Vertica	CData Sync	Automated Continuous Act-On Replication to a Vertica Database
Workato	Connect AI	Build Automated Workflows with Live Act-On Data in Workato
Zapier	Connect AI	Build Automated Act-On-Connected Workflows in Zapier

Data Virtualization

Product	Technology	Article Title
Access Linked Tables	ODBC	Update Act-On with a Microsoft Access Linked Table
APOS Live Data Gateway	JDBC	Build Semantic Layer Views for Act-On (JDBC)
APOS Live Data Gateway	Connect AI	Build Semantic Layer Views for Act-On Data (Connect AI)
Denodo	JDBC	Create A Data Source for Act-On in Denodo Platform
Dremio	JDBC	Connect to Act-On as an External Source in Dremio
MySQL Federated Tables	ODBC	Connect to Act-On as Federated Tables in MySQL
Oracle Database	ODBC	Access Act-On as a Remote Oracle Database
PostgreSQL FDW	JDBC	A PostgreSQL Interface for Act-On
Salesforce Connect	Connect AI	Edit and Search Act-On External Objects in Salesforce Connect
Salesforce External Services	Connect AI	Connect to Act-On through External Services in Salesforce
SQL Server Linked Servers	ODBC	Connect to Act-On as a Linked Server
SQL Server PolyBase	Connect AI	Connect to Act-On Data using PolyBase with Connect AI
SQL Server PolyBase	ODBC	Connect to Act-On as an External Data Source using PolyBase
TIBCO Data Virtualization	TIBCO DV	Access Live Act-On Data in TIBCO Data Virtualization

Software Development

Product	Technology	Article Title
AWS Lambda	JDBC	Access Live Act-On Data in AWS Lambda
Axios	Connect AI	Build Act-On-Connected Web Apps with Axios and CData Connect AI
.NET Charts	ADO.NET	DataBind Charts to Act-On
.NET QueryBuilder	ODBC	Rapidly Develop Act-On-Driven Apps with Active Query Builder
Apache Spark	JDBC	Work with Act-On in Apache Spark Using SQL
AppSheet	Connect AI	Create Act-On-Connected Business Apps in AppSheet
Bubble.io	Connect AI	Build Act-On-Connected Apps in Bubble
C++Builder	ODBC	DataBind Controls to Act-On Data in C++Builder
Choreo	Connect AI	Build Custom Apps on Act-On Data in Choreo
Claude Code	MCP Server	Build Act-On-Powered Applications in Claude Code with CData Code Assist MCP
ColdFusion	JDBC	Query Act-On in ColdFusion Using JDBC
ColdFusion	ODBC	Query Act-On in ColdFusion Using ODBC
Cursor	MCP Server	Build Act-On-Powered Applications in Cursor with CData Code Assist MCP
Dash	Python	Use Dash & Python to Build Web Apps on Act-On
Delphi	ODBC	DataBind Controls to Act-On Data in Delphi
DevExpress	ADO.NET	DataBind Act-On to the DevExpress Data Grid
EF - Code First	ADO.NET	Access Act-On with Entity Framework 6
EF - LINQ	ADO.NET	LINQ to Act-On
EF - MVC	ADO.NET	Build MVC Applications with Connectivity to Act-On
Filemaker Pro	ODBC	Bidirectional Access to Act-On from FileMaker Pro
Filemaker Pro (on Mac)	JDBC	Bidirectional Access to Act-On from FileMaker Pro (on Mac)
Gemini Code Assist	MCP Server	Build Act-On-Powered Applications in Gemini Code Assist with CData Code Assist MCP
GitHub Copilot	MCP Server	Build Act-On-Powered Applications in GitHub Copilot with CData Code Assist MCP
Go	ODBC	Write a Simple Go Application to work with Act-On on Linux
Google Apps Script	Connect AI	Connect to Act-On Data in Google Apps Script
Hibernate	JDBC	Object-Relational Mapping (ORM) with Act-On Entities in Java
IntelliJ	JDBC	Connect to Act-On in IntelliJ
JBoss	JDBC	Connect to Act-On from a Connection Pool in JBoss
JDBI	JDBC	Create a Data Access Object for Act-On using JDBI
JetBrains RubyMine	JDBC	Integrate Act-On with JetBrains RubyMine
Jitterbit	Connect AI	Integrate with Live Act-On Data in Jitterbit
JRuby	JDBC	Connect to Act-On in JRuby
Lazarus IDE	ODBC	Easily Integrate Act-On Data in Lazarus Pascal IDE
Mendix	Connect AI	Build Act-On-Connected Apps in Mendix (Connect AI)
Mendix	JDBC	Build Act-On-Connected Apps in Mendix (JDBC)
Microsoft Power Apps	Connect AI	Integrate Live Act-On Data into Custom Business Apps Built in Power Apps
NodeJS	Connect AI	Query Act-On Data in Node.js (via Connect AI)
NodeJS	ODBC	Query Act-On through ODBC in Node.js
OutSystems	Connect AI	Create Act-On-Connected Enterprise Applications in OutSystems
Perplexity Desktop	MCP Server	How to Query Live Act-On Data in Perplexity Desktop
PHP	ODBC	Natively Connect to Act-On in PHP
PowerBuilder	ADO.NET	Connect to Act-On from PowerBuilder
PowerShell	PowerShell	Pipe Act-On to CSV in PowerShell
PyCharm	ODBC	Using the CData ODBC Driver for Act-On in PyCharm
Python	ODBC	Connect to Act-On in Python on Linux/UNIX
Retool	Connect AI	Build Act-On-Connected Apps in Retool
Ruby	ODBC	Connect to Act-On in Ruby
RunMyProcess	Connect AI	Connect to Act-On Data in RunMyProcess
RunMyProcess DSEC	JDBC	Connect to Act-On in DigitalSuite Studio through RunMyProcess DSEC
Servoy	JDBC	Build Act-On-Connected Apps in Servoy
Spring Boot	JDBC	Access Live Act-On Data in Spring Boot Apps
SQLAlchemy	Python	Use SQLAlchemy ORMs to Access Act-On in Python
Tomcat	JDBC	Configure the CData JDBC Driver for Act-On in a Connection Pool in Tomcat
Unqork	Connect AI	Create Act-On-Connected Applications in Unqork
VCL App (RAD Studio)	ODBC	Build a Simple VCL Application for Act-On
WebLogic	JDBC	Connect to Act-On from a Connection Pool in WebLogic

Data Management

Product	Technology	Article Title
Apache Solr	JDBC	Import Act-On Data into Apache Solr
Coginiti Pro	JDBC	Access Live Act-On Data in Coginiti Pro
DataGrip	JDBC	Qeury Act-On Data in DataGrip
DB Artisan	JDBC	Manage Act-On in DBArtisan as a JDBC Source
DB Artisan	ODBC	Connect to Act-On in DBArtisan
DBeaver	JDBC	Connect to Act-On in DBeaver
DbVisualizer	JDBC	Connect to Act-On in DBVisualizer
HeidiSQL	Connect AI	Connect to Act-On Data in HeidiSQL
Informatica Enterprise Data Catalog	JDBC	Add Act-On to Informatica Enterprise Data Catalog
MySQL Workbench	ODBC	Query Act-On in MySQL Workbench (ODBC)
QuerySurge	JDBC	Validate Act-On Data with QuerySurge
RazorSQL	JDBC	Connect to Act-On in RazorSQL
SQuirreL	JDBC	Connect to Act-On in Squirrel SQL Client

Workflow Automation

Product	Technology	Article Title
Blue Prism	ODBC	Integrate Live Act-On Data for Intelligent Robotic Process Automation
MuleSoft Anypoint	JDBC	Access Act-On in Anypoint Using SQL
Nintex Workflow Cloud	Connect AI	Build Act-On-Connected Workflows in Nintex
Power Automate	Connect AI	Integrate Act-On Data into Power Automate Automated Tasks
SSIS Export	SSIS	Export Data from SQL Server to Act-On through SSIS
SSIS Import	SSIS	Import Act-On Data into SQL Server using SSIS
SSIS Lookup	SSIS	Insert New or Update Existing Act-On Records from SQL Server

Ready to get started?

Learn more:

Act-On Connectivity Solutions

URL: https://www.cdata.com/kb/tech/acton-article-list.rst