Act-On
 

Connect to Act-On marketing automation platform through easy-to-use drivers.


Integrate with BI, Reporting, Analytics, ETL Tools, and Custom Solutions.


"Excellent stuff. I am finally getting the hang of this and it is brilliant may I add!"

- Mark Couvaras, General Manager, Databarracks



Connect to Act-On Data from Anywhere!

Easily access live Act-On data from BI, Analytics, Reporting, ETL, & Custom Apps.







Act-On Integration Guides and Tutorials

BI & Analytics


Our drivers offer the fastest and easiest way to connect real-time Act-On data with BI, analytics, reporting and data visualization technologies. They provide unmatched query performance, comprehensive access to Act-On data and metadata, and seamlessly integrate with your favorite analytics tools.

LEARN MORE: Connectivity for BI & Analytics

Popular BI & Analytics Integrations


Alteryx Designer: Prepare, Blend, and Analyze Act-On in Alteryx Designer Amazon QuickSight: Build Interactive Dashboards from Act-On in Amazon QuickSight Aqua Data Studio: Connect to Act-On in Aqua Data Studio AWS Databricks: Process & Analyze Act-On Data in Databricks (AWS) Birst: Build Visualizations of Act-On in Birst BIRT: Design BIRT Reports on Act-On Clear Analytics: Build Charts with Act-On in Clear Analytics DBxtra: Build Dashboards with Act-On in DBxtra Domo: Create Datasets from Act-On in Domo Workbench Dundas BI: Build Dashboards with Act-On in Dundas BI Excel (on Mac OS): Work with Act-On Data in MS Excel on Mac OS X FineReport: Feed Act-On into FineReport Google Sheets: Access Live Act-On in Google Sheets IBM Cognos BI: Create Data Visualizations in Cognos BI with Act-On Infragistics Reveal: Analyze Act-On Data in Infragistics Reval JasperServer: Create Act-On Reports on JasperReports Server Jaspersoft BI Suite: Connect to Act-On in Jaspersoft Studio JReport Designer: Integrate with Act-On in JReport Designer Klipfolio: Create Act-On-Connected Visualizations in Klipfolio KNIME: Enable the Act-On JDBC Driver in KNIME LINQPad: Working with Act-On in LINQPad Looker Studio: Create Reports from Act-On in Looker Studio Metabase: Create Interactive Act-On-Connected Metabase Dashboards Microsoft Excel: Excel Spreadsheet Automation with the QUERY Formula Microsoft SSAS: Build an OLAP Cube in SSAS from Act-On MicroStrategy: Connect to Live Act-On in MicroStrategy through Connect Server MicroStrategy: Use the CData JDBC Driver for Act-On in MicroStrategy Microstrategy Desktop: Use the CData JDBC Driver for Act-On in MicroStrategy Desktop Microstrategy Web: Use the CData JDBC Driver for Act-On in MicroStrategy Web OBIEE: Act-On Reporting in OBIEE with the Act-On JDBC Driver pandas: Use pandas to Visualize Act-On in Python Pentaho Report Designer: Integrate Act-On in the Pentaho Report Designer Power BI Desktop: Author Power BI Reports on Real-Time Act-On Power BI Service: Visualize Live Act-On in the Power BI Service QlikView: Connect to and Query Act-On in QlikView over ODBC R: Analyze Act-On in R (JDBC) R: Analyze Act-On in R (ODBC) RapidMiner: Connect to Act-On in RapidMiner SAP Analytics Cloud: Analyze Act-On in SAP Analytics Cloud SAP Business Objects: Create an SAP BusinessObjects Universe on the CData JDBC Driver for Act-On SAP Crystal Reports: Publish Reports with Act-On in Crystal Reports SAS: Use the CData ODBC Driver for Act-On in SAS for Real-Time Reporting and Analytics SAS JMP: Use the CData ODBC Driver for Act-On in SAS JMP Sisense: Visualize Live Act-On in Sisense Spago BI: Connect to Act-On in SpagoBI Tableau: Visualize Act-On in Tableau Desktop Tableau Cloud: Build Act-On Visualizations in Tableau Cloud Tableau Server: Publish Act-On-Connected Dashboards in Tableau Server TIBCO Spotfire: Visualize Act-On in TIBCO Spotfire through ADO.NET TIBCO Spotfire Server: Operational Reporting on Act-On from Spotfire Server Visio: Link Visio Shapes to Act-On

ETL, Replication, & Warehousing


From drivers and adapters that extend your favorite ETL tools with Act-On connectivity to ETL/ELT tools for replication — our Act-On integration solutions provide robust, reliable, and secure data movement.

Connect your RDBMS or data warehouse with Act-On to facilitate operational reporting, offload queries and increase performance, support data governance initiatives, archive data for disaster recovery, and more.


Popular Data Warehousing Integrations


Amazon Redshift: Automated Continuous Act-On Replication to Amazon Redshift Amazon S3: Automated Continuous Act-On Replication to Amazon S3 Apache Airflow: Bridge Act-On Connectivity with Apache Airflow Apache Camel: Integrate with Act-On using Apache Camel Apache NiFi: Bridge Act-On Connectivity with Apache NiFi Apache NiFi Batch Operations: Perform Batch Operations with Act-On Data in Apache NiFi Azure Data Lake: Automated Continuous Act-On Replication to Azure Data Lake Azure Synapse: Automated Continuous Act-On Replication to Azure Synapse BIML: Use Biml to Build SSIS Tasks to Replicate Act-On to SQL Server CloverDX: Connect to Act-On in CloverDX (formerly CloverETL) Databricks: Automated Continuous Act-On Replication to Databricks FoxPro: Work with Act-On in FoxPro Google AlloyDB: Automated Continuous Act-On Replication to Google AlloyDB Google BigQuery: Automated Continuous Act-On Replication to Google BigQuery Google Cloud SQL: Automated Continuous Act-On Replication to Google Cloud SQL Google Data Fusion: Build Act-On-Connected ETL Processes in Google Data Fusion HULFT Integrate: Connect to Act-On in HULFT Integrate Informatica Cloud: Integrate Act-On in Your Informatica Cloud Instance Informatica PowerCenter: Create Informatica Mappings From/To a JDBC Data Source for Act-On Jaspersoft ETL: Connect to Act-On in Jaspersoft Studio Microsoft Excel: Transfer Data from Excel to Act-On Microsoft Power Automate: Build Act-On-Connected Automated Tasks with Power Automate (Desktop) Oracle Data Integrator: ETL Act-On in Oracle Data Integrator petl: Extract, Transform, and Load Act-On in Python Replicate to CSV: Replicate Act-On to MySQL with PowerShell SAP HANA: Automated Continuous Act-On Replication to SAP HANA SingleStore: Automated Continuous Act-On Replication to SingleStore SnapLogic: Integrate Act-On with External Services using SnapLogic Snowflake: Automated Continuous Act-On Replication to Snowflake SQL Server Linked Server: Connect to Act-On as a SQL Server Linked Server Talend: Connect to Act-On and Transfer Data in Talend UiPath Studio: Create an RPA Flow that Connects to Act-On in UiPath Studio Vertica: Automated Continuous Act-On Replication to a Vertica Database

Workflow & Automation Tools


Connect to Act-On from popular data migration, ESB, iPaaS, and BPM tools.

Our drivers and adapters provide straightforward access to Act-On data from popular applications like BizTalk, MuleSoft, SQL SSIS, Microsoft Flow, Power Apps, Talend, and many more.

Popular Workflow & Automation Tool Integrations


MuleSoft Anypoint: Access Act-On in Anypoint Using SQL Power Automate: Integrate Act-On into Power Automate Automated Tasks SSIS Export: Export Data from SQL Server to Act-On through SSIS SSIS Import: Import Act-On Data into SQL Server using SSIS SSIS Lookup: Insert New or Update Existing Act-On Records from SQL Server

Developer Tools & Technologies


The easiest way to integrate with Act-On from anywhere. Our Act-On drivers offer a data-centric model for Act-On that dramatically simplifies integration — allowing developers to build higher quality applications, faster than ever before. Learn more about the benefits for developers:



Popular Developer Integrations


.NET Charts: DataBind Charts to Act-On .NET QueryBuilder: Rapidly Develop Act-On-Driven Apps with Active Query Builder Apache Spark: Work with Act-On in Apache Spark Using SQL AppSheet: Create Act-On-Connected Business Apps in AppSheet ColdFusion: Query Act-On in ColdFusion Using JDBC ColdFusion: Query Act-On in ColdFusion Using ODBC Dash: Use Dash & Python to Build Web Apps on Act-On DevExpress: DataBind Act-On to the DevExpress Data Grid EF - Code First: Access Act-On with Entity Framework 6 EF - LINQ: LINQ to Act-On EF - MVC: Build MVC Applications with Connectivity to Act-On Filemaker Pro: Bidirectional Access to Act-On from FileMaker Pro Filemaker Pro (on Mac): Bidirectional Access to Act-On from FileMaker Pro (on Mac) Go: Write a Simple Go Application to work with Act-On on Linux Google Apps Script: Connect to Act-On in Google Apps Script Hibernate: Object-Relational Mapping (ORM) with Act-On Entities in Java IntelliJ: Connect to Act-On in IntelliJ JBoss: Connect to Act-On from a Connection Pool in JBoss JDBI: Create a Data Access Object for Act-On using JDBI JRuby: Connect to Act-On in JRuby Microsoft Power Apps: Integrate Live Act-On into Custom Business Apps Built in Power Apps NodeJS: Query Act-On in Node.js (via Connect Server) NodeJS: Query Act-On through ODBC in Node.js PHP: Natively Connect to Act-On in PHP PowerBuilder: Connect to Act-On from PowerBuilder PowerShell: Pipe Act-On to CSV in PowerShell PyCharm: Using the CData ODBC Driver for Act-On in PyCharm Python: Connect to Act-On in Python on Linux/UNIX Ruby: Connect to Act-On in Ruby RunMyProcess: Connect to Act-On in RunMyProcess RunMyProcess DSEC: Connect to Act-On in DigitalSuite Studio through RunMyProcess DSEC Servoy: Build Act-On-Connected Apps in Servoy Spring Boot: Access Live Act-On Data in Spring Boot Apps SQLAlchemy: Use SQLAlchemy ORMs to Access Act-On in Python Tomcat: Configure the CData JDBC Driver for Act-On in a Connection Pool in Tomcat Unqork: Create Act-On-Connected Applications in Unqork VCL App (RAD Studio): Build a Simple VCL Application for Act-On WebLogic: Connect to Act-On from a Connection Pool in WebLogic


When Only the Best Act-On Drivers Will Do

See what customers have to say about our products and support.





Industry-Leading Support

Support is not just a part of our business, support is our business. Whenever you need help, please consult the resources below:

Using the Act-On Drivers