CData Software - Knowledge Base

Recent Act-On Articles

Connect Act-On to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway

Connect to your Act-On using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.

Connect to and Visualize Live Act-On in Tableau Prep

Use CData Tableau Connectors and Tableau Prep Builder to visualize live Act-On.

How to Connect to Act-On in Using Python: 6 Steps

Create Python applications on Linux/UNIX machines with connectivity to Act-On. Leverage the pyodbc module for ODBC in Python.

Visualize Act-On from Tableau

Use the Tableau Desktop business intelligence tool to connect to Act-On.

Build Charts with Act-On in Clear Analytics

Create dynamic charts and perform analytics based on Act-On in Clear Analytics.

Create an SAP BusinessObjects Universe on the CData ODBC Driver for Act-On

Provide connectivity to Act-On through an SAP BusinessObjects universe.

Publish Reports with Act-On in SAP Crystal Reports

Use the Report Wizard to design a report based on up-to-date Act-On.

Analyze Act-On in SAP Analytics Cloud

Use CData Connect AI to create an OData API on top of Act-On and visualize Act-On in SAP Analytics Cloud.

Visualize Act-On in TIBCO Spotfire through ODBC

The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Act-On into TIBCO Spotfire.

DataBind Controls to Act-On in C++Builder

DataBind to Act-On in C++Builder with standard components and controls.

Edit and Search External Act-On Objects in Salesforce Connect

Use CData Connect AI to securely provide OData feeds of Act-On to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Act-On objects that you can access from apps and the dashboard.

Connect to Act-On in Google Apps Script via SQL Gateway

Use the ODBC Driver for Act-On and the SQL Gateway to access Act-On from Google Apps Script.

Access Live Act-On in SAS JMP via ODBC

You can use the CData ODBC Driver to integrate Act-On into the statistical analysis tools available in SAS JMP. This article shows how to use Act-On in the Graph Builder and Query Builder.

Create Apps from Act-On in Qlik Sense Cloud

Use CData Connect AI to connect to Act-On and build apps from live Act-On in Qlik Sense Cloud.

Build a Simple VCL Application for Act-On

How to build a simple VCL Application to view Act-On in RAD Studio using the CData ODBC Driver for Act-On.

Visualize Act-On in Tableau

The CData ODBC driver for Act-On enables you integrate Act-On into Tableau dashboards.

Connect to Act-On in Google Apps Script via Connect AI

Use CData Connect AI to access Act-On in Google Apps Script.

Connect to Act-On in RapidMiner

Integrate Act-On with standard components and data source configuration wizards in RapidMiner Studio.

Build an OLAP Cube in SSAS from Act-On

Establish a connection to Act-On data from SQL Server Analysis Services, and use the Act-On Data Provider to build OLAP cubes for use in analytics and reporting.

Analyze Act-On in Infragistics Reveal

Use CData Connect AI to create on OData API on top of Act-On and visualize live Act-On in Infragistics Reveal.

Access Act-On as a Remote Oracle Database

Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Act-On from your Oracle system.

Manage Act-On in DBArtisan as a JDBC Source

Use wizards in DBArtisan to create a JDBC data source for Act-On.

Connect to Act-On in SpagoBI

Create reports featuring live Act-On in SpagoBI Studio. Host Act-On reports on SpagoBI Server.

Connect to Act-On in Aqua Data Studio

Access Act-On from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

How to connect SharePoint with Act-On through external lists

Provide Act-On to SharePoint users as an external list.

Deploy the ADO.NET Provider for Act-On on an SSRS Report Server

Connect to Act-On from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.

How to create Act-On federated tables in MySQL

Use the SQL Gateway and the ODBC Driver to set up federated tables for Act-On in MySQL .

Object-Relational Mapping (ORM) with Act-On Entities in Java

Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Act-On into a Java-based ORM framework, Hibernate.

Migrating data from Act-On to Databricks using CData SSIS Components.

Easily push Act-On to Databricks using the CData SSIS Tasks for Act-On and Databricks.

Connect to Act-On as a Linked Server via SQL Gateway

Use the SQL Gateway and the ODBC Driver to set up a linked server for Act-On.

Connect to Act-On in RazorSQL

Connect to Act-On from wizards and query Act-On from the GUI in the RazorSQL database management tool.

LINQ to Act-On

LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Act-On Data Provider.

Create Data Visualizations in Cognos BI with Act-On

Access Act-On as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.

Integrating Act-On in Talend Cloud Data Management Platform

Connect Act-On with Talend Cloud Data Management Platform using the [product_name].

Migrating data from Act-On to Google BigQuery using CData SSIS Components.

Easily push Act-On to Google BigQuery using the CData SSIS Tasks for Act-On and Google BigQuery.

Connect to Act-On in NetBeans

Connect to Act-On in NetBeans with the data source configuration wizard.

How to connect PolyBase to Act-On

Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Act-On.

Visualize Act-On in Sisense

Create an ElastiCube in Sisense app with access to Act-On.

Consume Act-On OData Feeds in SAP Lumira

Use the API Server to create data visualizations on Act-On feeds that reflect any changes in SAP Lumira.

Connect to Act-On in Jaspersoft Studio

Execute SQL to remote Act-On in Jaspersoft Studio.

Connect to Act-On in DBArtisan

Use wizards in DBArtisan to configure Act-On as a data source.

Connect to Act-On from Blazor Apps

Build ASP.NET Core Blazor C# apps that integrate with real-time Act-On using standard SQL.

How to use SQLAlchemy ORM to access Act-On in Python

Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Act-On.

Establish a Live Connection with Act-On using Tableau Bridge

The CData ODBC Driver for Act-On enables you to integrate live Act-On into Tableau Cloud dashboards using the Tableau Bridge.

Connect to Act-On Using the Script Function in Claris FileMaker Pro

Use the [product_name] and the Script function in FileMaker Pro to connect to Act-On and work with Act-On in your FileMaker application.

Connect to Act-On in JRuby

Create a simple JRuby app with access to live Act-On.

Create Informatica Mappings From/To a JDBC Data Source for Act-On

Create Act-On data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.

Integrate Live Act-On into Blue Prism for Intelligent Robotic Process Automation (RPA)

Connect live Act-On to Blue Prism using the [product_name] to create automated workflows for repetitive business tasks.

Analyze Act-On in Infragistics Reveal

Use the CData API Server to create an OData API on top of Act-On and visualize live Act-On in Infragistics Reveal.

Query Act-On using the OData SDK for PHP

Use the API Server and the OData PHP SDK to easily consume Act-On entities in PHP by modeling them as objects.

How to publish and share Act-On dashboards with Tableau Server

The CData ODBC driver for Act-On enables you integrate Act-On into Tableau dashboards.

Building Dynamic Web Pages with Act-On Using AngularJS

Create single-page applications with live connectivity to Act-On using the CData API Server.

Replicate Act-On from PowerShell

Write a quick PowerShell script to query Act-On. Use connectivity to the live data to replicate Act-On to SQL Server.

Query Act-On from Node.js

Use the OData endpoint of the CData API Server to connect to your Act-On and perform CRUD operations on Act-On from Node.js.

Publish Crystal Reports on Act-On

Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Act-On.

How to connect to Act-On with Squirrel SQL client

Connect to Act-On and execute queries in the Squirrel SQL Client.

Analyze Act-On with Power Pivot

This article walks you through the process of using the CData ODBC Driver for Act-On from Power Pivot. You will use the Table Import Wizard to load Act-On. You can visually build the import query or use any SQL supported by the driver.

How to Connect DBeaver to Act-On via a JDBC Driver

Manage Act-On with visual tools in DBeaver like the query browser.

Build Automated Act-On-Connected Workflows in Zapier

Use CData Connect AI to connect to live Act-On and build automated workflows in Zapier.

Working with Act-On in LINQPad

Execute LINQ queries to Act-On in LINQPad.

Enable the Act-On JDBC Driver in KNIME

Use standard data access components in KNIME to create charts and reports with Act-On.

Query Act-On in ColdFusion

Write standard ColdFusion data access code to connect to Act-On.

How to create Visio diagrams from Act-On

Automatically update Act-On with the changes you make to Visio master shapes.

Feed Act-On into FineReport

How to set Act-On as a JDBC data source in FineReport.

Connect to Act-On from a Connection Pool in Jetty

The Act-On JDBC Driver supports connection pooling: This article shows how to connect faster to Act-On from Web apps in Jetty.

Publish Act-On-Connected Dashboards in Tableau Server

Use CData Tableau Connectors and Tableau Server to visualize live Act-On.

Visualize Act-On in TIBCO Spotfire through ADO.NET

Integrate Act-On into dashboards in TIBCO Spotfire.

Extend Google Sheets with Act-On

Make calls to the API Server from Google Apps Script.

Create Informatica Mappings From/To an ODBC Data Source for Act-On

Create an ODBC connection to Act-On in Informatica and browse and transfer Act-On.

Integrate Act-On in the Pentaho Report Designer

Publish reports based on Act-On in the Pentaho BI tool.

Import and Visualize Act-On in Power View

Create data visualizations based on Act-On in Excel.

Configure the CData JDBC Driver for Act-On in a Connection Pool in Tomcat

Connect to Act-On from a connection pool in Tomcat.

Provide OData Services of Act-On from a WCF Application

In this article, we will demonstrate the process of generating an OData feed for Act-On by developing a WCF Service Application.

Automate Act-On Integration Tasks from PowerShell

Are you in search of a quick and easy way to access Act-On from PowerShell? This article demonstrates how to utilize the Act-On Cmdlets for tasks like connecting to Act-On, automating operations, downloading data, and more.

Build Data Flows from Act-On to SQL Server using SSIS

Easily back up Act-On to SQL Server using the SSIS components for Act-On.

Create Dynamic Act-On Grids Using the Infragistics XamDataGrid

Learn how you can connect Act-On to Infragistics XamDataGrid to build dynamic grids.

Analyze Act-On in Slingshot with CData API Server

Use the CData API Server to build an OData API on top of Act-On and visualize the live in Slingshot (formerly Reveal BI) for seamless insights.

Build AI/ML Models with Live Act-On Data using Dataiku

Connect Act-On Data with Dataiku using the [product_name].

ETL Act-On in Oracle Data Integrator

This article shows how to transfer Act-On into a data warehouse using Oracle Data Integrator.

Connect to Act-On from a Connection Pool in WebLogic

Use the CData JDBC Driver for Act-On to connect to Act-On from Web applications running on WebLogic.

Integrate Act-On in Pentaho Data Integration

Build ETL pipelines based on Act-On in the Pentaho Data Integration tool.

Explore Geographical Relationships in Act-On with Power Map

Create data visualizations with Act-On in Power Map.

How to Connect to & Open Act-On in Microsoft Excel

This article uses the CData ODBC driver for Act-On to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.

DataBind Controls to Act-On in Delphi

DataBind to Act-On in Delphi with standard data access components and controls.

Natively Connect to Act-On in PHP via ODBC (Linux)

Create PHP applications on Linux/UNIX machines with connectivity to Act-On. Leverage the native support for ODBC in PHP.

Use CData Connect AI to Access Act-On in Microsoft Power Pivot

Use CData Connect AI to connect to live Act-On in the Power Pivot business intelligence tool.

Connect to Act-On from Asprova with CData Software ODBC Driver for Act-On

This article shows how to connect faster to Act-On data from Asprova.

Build MVC Applications with Connectivity to Act-On

This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Act-On from an ASP.NET MVC application.

Using the CData Software ODBC Driver for Act-On in PyCharm

Connect to Act-On as an ODBC data source in PyCharm using the CData Software ODBC Driver for Act-On.

How to connect to Act-On in DBVisualizer

Integrate Act-On with visual data analysis tools and data connection wizards in DBVisualizer

Use the CData ODBC Driver for Act-On from SharePoint Excel Services

This article demonstrates how to use the CData ODBC Driver for Act-On to connect to Act-On from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Act-On in Excel.

Connect to Live Act-On in PostGresSQL Interface through CData Connect AI

Create a live connection to Act-On in CData Connect AI and connect to your Act-On from PostgreSQL.

Create SSAS Tabular Models from Act-On

How to build a SQL Server Analysis Service Tabular Model from Act-On using CData drivers.

Visualize Live Act-On in Tableau

Use CData Tableau Connectors and Tableau Desktop to visualize live Act-On.

How to Visualize Act-On Data in Python with pandas

Use pandas and other modules to analyze and visualize live Act-On in Python.

Build Data Flows from SQL Server to Act-On through SSIS

Easily push SQL Server data to Act-On using the CData SSIS Tasks for Act-On.

Viewing Act-On in RAD Studio Data Explorer

How to view Act-On in RAD Studio Data Explorer using the CData ODBC Driver for Act-On.

Consume Act-On OData Feeds in PowerBuilder

This article demonstrates how to consume Act-On as OData feeds from PowerBuilder using the API Server.

Build Act-On-Connected Web Apps with Axios and CData Connect AI

Use CData Connect AI to connect to live Act-On and build Act-On-connected web apps with Axios.

Work with Act-On in FoxPro

Load Act-On into a FoxPro database. This article includes full code and a walk-through of the process.

Connect to Act-On through External Services in Salesforce

Use CData Connect AI to securely connect Salesforce External Services with Act-On using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.

Connect to and Query Act-On in QlikView over ODBC

Create data visualizations with Act-On in QlikView.

How to update Act-On from Excel

This article explains how to transfer data from Excel to Act-On using the Excel Add-In for Act-On.

Connect to Act-On in Claris FileMaker Pro

Use the [product_name] in FileMaker Pro to connect to Act-On and work with Act-On in your FileMaker applications.

Edit and Search Act-On External Objects in Salesforce Connect (API Server)

Use the API Server to securely provide OData feeds of Act-On to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Act-On objects that you can access from apps and the dashboard.

Connect to Act-On in CloverDX (formerly CloverETL)

Transfer Act-On using the visual workflow in the CloverDX data integration tool.

Connect to Act-On from PowerBuilder via ODBC

This article demonstrates how to use the CData ODBC Driver for Act-On to connect to Act-On and execute queries in PowerBuilder.

How to Build an ETL App for Act-On in Python with CData

Create ETL applications and real-time data pipelines for Act-On in Python with petl.

Access Act-On in Mule Applications Using the CData JDBC Driver

Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Act-On.

Bidirectional Access to Act-On from FileMaker Pro

Use the MySQL Remoting feature of the JDBC driver to integrate Act-On in Filemaker Pro for Mac or Windows.

Visualize Act-On in TIBCO Spotfire through OData

Integrate Act-On into dashboards in TIBCO Spotfire.

How to Use a Microsoft Access Database to Update Act-On in Real Time

Update Act-On data by creating a linked table in Microsoft Access with the CData Act-On ODBC Driver.

Use Dash to Build to Web Apps on Act-On

Create Python applications that use pandas and Dash to build Act-On-connected web apps.

Extract, Transform, and Load Act-On in Informatica PowerCenter

Create a simple Workflow for Act-On in Informatica PowerCenter.

Publish Act-On-Connected Dashboards in Tableau Server via JDBC

Use CData JDBC drivers and Tableau Server to visualize live Act-On.

Build Dashboards with Act-On in DBxtra

Create dynamic dashboards and perform analytics based on Act-On in DBxtra.

How to Access Act-On Using Entity Framework

This article shows how to access Act-On using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.

Connect to Act-On from a Connection Pool in JBoss

Integrate Act-On into Java servlets: Use the Management Console in JBoss to install the Act-On JDBC Driver.

Integrate with Act-On in JReport Designer

Create charts and reports based on Act-On in JReport Designer.

Migrating data from Act-On to Snowflake using CData SSIS Components.

Easily push Act-On to Snowflake using the CData SSIS Tasks for Act-On and Snowflake.

Load Act-On to a Database Using Embulk

Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Act-On to a database.

Connect to Act-On from PowerBuilder via JDBC

This article demonstrates how to access Act-On from PowerBuilder using the Act-On JDBC Driver.

Create Reports with Act-On in SAP Crystal Reports

Use the Report Wizard to design a report based on up-to-date Act-On.

Create an SAP BusinessObjects Universe on the CData JDBC Driver for Act-On

Provide connectivity to Act-On through an SAP BusinessObjects universe.

DataBind Act-On to the DevExpress Data Grid

Use the CData Software ADO.NET Provider for Act-On with the DevExpress Windows Forms and Web controls to provide Act-On to a chart.

How to connect to Act-On from IntelliJ

Integrate connectivity to Act-On with wizards in IntelliJ.

Connect to Act-On in Ruby

Connect to Act-On in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

Back Up Act-On to SQL Server through SSIS

Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Act-On. In this article, we will employ an SSIS workflow to populate a database with Act-On data.

How to Query Live Act-On Data in Natural Language in Python using LlamaIndex

Use LlamaIndex to query live Act-On data in natural language using Python.

PowerShell Scripting to Replicate Act-On to MySQL

Write a simple PowerShell script to replicate Act-On to a MySQL database.

How to Import Data from Act-On into Google Sheets

Import Act-On into a Google spreadsheet that is automatically refreshed.

Connect to Act-On in RunMyProcess through Connect AI

Use CData Connect AI to create on OData API for Act-On and connect to Act-On in Akorbi Digital RunMyProcess.

Build Dashboards with Act-On in Dundas BI

Create dynamic dashboards and perform analytics based on Act-On in Dundas BI.

Connect to Act-On from PowerBuilder via ADO.NET

This article demonstrates how to access Act-On from Appeon PowerBuilder using the CData ADO.NET Provider for Act-On.

Excel Spreadsheet Automation on Act-On with the QUERY Formula

Pull data, automate spreadsheets, and more with the QUERY formula.

Natively Connect to Act-On in PHP

The CData ODBC driver for Act-On enables you to create PHP applications with connectivity to Act-On. Leverage the native support for ODBC in PHP.

Design BIRT Reports on Act-On

Provide current Act-On to your embedded analytics.

Connect Act-On to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway

Connect to your Act-On using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.

Connect to and Visualize Live Act-On in Tableau Prep

Use CData Tableau Connectors and Tableau Prep Builder to visualize live Act-On.

How to Connect to Act-On in Using Python: 6 Steps

Create Python applications on Linux/UNIX machines with connectivity to Act-On. Leverage the pyodbc module for ODBC in Python.

Visualize Act-On from Tableau

Use the Tableau Desktop business intelligence tool to connect to Act-On.

Build Charts with Act-On in Clear Analytics

Create dynamic charts and perform analytics based on Act-On in Clear Analytics.

Create an SAP BusinessObjects Universe on the CData ODBC Driver for Act-On

Provide connectivity to Act-On through an SAP BusinessObjects universe.

Publish Reports with Act-On in SAP Crystal Reports

Use the Report Wizard to design a report based on up-to-date Act-On.

Analyze Act-On in SAP Analytics Cloud

Use CData Connect AI to create an OData API on top of Act-On and visualize Act-On in SAP Analytics Cloud.

Visualize Act-On in TIBCO Spotfire through ODBC

The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Act-On into TIBCO Spotfire.

DataBind Controls to Act-On in C++Builder

DataBind to Act-On in C++Builder with standard components and controls.

Edit and Search External Act-On Objects in Salesforce Connect

Connect to Act-On in Google Apps Script via SQL Gateway

Use the ODBC Driver for Act-On and the SQL Gateway to access Act-On from Google Apps Script.

Access Live Act-On in SAS JMP via ODBC

You can use the CData ODBC Driver to integrate Act-On into the statistical analysis tools available in SAS JMP. This article shows how to use Act-On in the Graph Builder and Query Builder.

Create Apps from Act-On in Qlik Sense Cloud

Use CData Connect AI to connect to Act-On and build apps from live Act-On in Qlik Sense Cloud.

Build a Simple VCL Application for Act-On

How to build a simple VCL Application to view Act-On in RAD Studio using the CData ODBC Driver for Act-On.

Visualize Act-On in Tableau

The CData ODBC driver for Act-On enables you integrate Act-On into Tableau dashboards.

Connect to Act-On in Google Apps Script via Connect AI

Use CData Connect AI to access Act-On in Google Apps Script.

Connect to Act-On in RapidMiner

Integrate Act-On with standard components and data source configuration wizards in RapidMiner Studio.

Build an OLAP Cube in SSAS from Act-On

Establish a connection to Act-On data from SQL Server Analysis Services, and use the Act-On Data Provider to build OLAP cubes for use in analytics and reporting.

Analyze Act-On in Infragistics Reveal

Use CData Connect AI to create on OData API on top of Act-On and visualize live Act-On in Infragistics Reveal.

Access Act-On as a Remote Oracle Database

Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Act-On from your Oracle system.

Manage Act-On in DBArtisan as a JDBC Source

Use wizards in DBArtisan to create a JDBC data source for Act-On.

Connect to Act-On in SpagoBI

Create reports featuring live Act-On in SpagoBI Studio. Host Act-On reports on SpagoBI Server.

Connect to Act-On in Aqua Data Studio

Access Act-On from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

How to connect SharePoint with Act-On through external lists

Provide Act-On to SharePoint users as an external list.

Deploy the ADO.NET Provider for Act-On on an SSRS Report Server

Connect to Act-On from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.

How to create Act-On federated tables in MySQL

Use the SQL Gateway and the ODBC Driver to set up federated tables for Act-On in MySQL .

Object-Relational Mapping (ORM) with Act-On Entities in Java

Migrating data from Act-On to Databricks using CData SSIS Components.

Easily push Act-On to Databricks using the CData SSIS Tasks for Act-On and Databricks.

Connect to Act-On as a Linked Server via SQL Gateway

Use the SQL Gateway and the ODBC Driver to set up a linked server for Act-On.

Connect to Act-On in RazorSQL

Connect to Act-On from wizards and query Act-On from the GUI in the RazorSQL database management tool.

LINQ to Act-On

Create Data Visualizations in Cognos BI with Act-On

Access Act-On as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.

Integrating Act-On in Talend Cloud Data Management Platform

Connect Act-On with Talend Cloud Data Management Platform using the [product_name].

Migrating data from Act-On to Google BigQuery using CData SSIS Components.

Easily push Act-On to Google BigQuery using the CData SSIS Tasks for Act-On and Google BigQuery.

Connect to Act-On in NetBeans

Connect to Act-On in NetBeans with the data source configuration wizard.

How to connect PolyBase to Act-On

Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Act-On.

Visualize Act-On in Sisense

Create an ElastiCube in Sisense app with access to Act-On.

Consume Act-On OData Feeds in SAP Lumira

Use the API Server to create data visualizations on Act-On feeds that reflect any changes in SAP Lumira.

Connect to Act-On in Jaspersoft Studio

Execute SQL to remote Act-On in Jaspersoft Studio.

Connect to Act-On in DBArtisan

Use wizards in DBArtisan to configure Act-On as a data source.

Connect to Act-On from Blazor Apps

Build ASP.NET Core Blazor C# apps that integrate with real-time Act-On using standard SQL.

How to use SQLAlchemy ORM to access Act-On in Python

Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Act-On.

Establish a Live Connection with Act-On using Tableau Bridge

The CData ODBC Driver for Act-On enables you to integrate live Act-On into Tableau Cloud dashboards using the Tableau Bridge.

Connect to Act-On Using the Script Function in Claris FileMaker Pro

Use the [product_name] and the Script function in FileMaker Pro to connect to Act-On and work with Act-On in your FileMaker application.

Connect to Act-On in JRuby

Create a simple JRuby app with access to live Act-On.

Create Informatica Mappings From/To a JDBC Data Source for Act-On

Create Act-On data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.

Integrate Live Act-On into Blue Prism for Intelligent Robotic Process Automation (RPA)

Connect live Act-On to Blue Prism using the [product_name] to create automated workflows for repetitive business tasks.

Analyze Act-On in Infragistics Reveal

Use the CData API Server to create an OData API on top of Act-On and visualize live Act-On in Infragistics Reveal.

Query Act-On using the OData SDK for PHP

Use the API Server and the OData PHP SDK to easily consume Act-On entities in PHP by modeling them as objects.

How to publish and share Act-On dashboards with Tableau Server

The CData ODBC driver for Act-On enables you integrate Act-On into Tableau dashboards.

Building Dynamic Web Pages with Act-On Using AngularJS

Create single-page applications with live connectivity to Act-On using the CData API Server.

Replicate Act-On from PowerShell

Write a quick PowerShell script to query Act-On. Use connectivity to the live data to replicate Act-On to SQL Server.

Query Act-On from Node.js

Use the OData endpoint of the CData API Server to connect to your Act-On and perform CRUD operations on Act-On from Node.js.

Publish Crystal Reports on Act-On

Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Act-On.

How to connect to Act-On with Squirrel SQL client

Connect to Act-On and execute queries in the Squirrel SQL Client.

Analyze Act-On with Power Pivot

How to Connect DBeaver to Act-On via a JDBC Driver

Manage Act-On with visual tools in DBeaver like the query browser.

Build Automated Act-On-Connected Workflows in Zapier

Use CData Connect AI to connect to live Act-On and build automated workflows in Zapier.

Working with Act-On in LINQPad

Execute LINQ queries to Act-On in LINQPad.

Enable the Act-On JDBC Driver in KNIME

Use standard data access components in KNIME to create charts and reports with Act-On.

Query Act-On in ColdFusion

Write standard ColdFusion data access code to connect to Act-On.

How to create Visio diagrams from Act-On

Automatically update Act-On with the changes you make to Visio master shapes.

Feed Act-On into FineReport

How to set Act-On as a JDBC data source in FineReport.

Connect to Act-On from a Connection Pool in Jetty

The Act-On JDBC Driver supports connection pooling: This article shows how to connect faster to Act-On from Web apps in Jetty.

Publish Act-On-Connected Dashboards in Tableau Server

Use CData Tableau Connectors and Tableau Server to visualize live Act-On.

Visualize Act-On in TIBCO Spotfire through ADO.NET

Integrate Act-On into dashboards in TIBCO Spotfire.

Extend Google Sheets with Act-On

Make calls to the API Server from Google Apps Script.

Create Informatica Mappings From/To an ODBC Data Source for Act-On

Create an ODBC connection to Act-On in Informatica and browse and transfer Act-On.

Integrate Act-On in the Pentaho Report Designer

Publish reports based on Act-On in the Pentaho BI tool.

Import and Visualize Act-On in Power View

Create data visualizations based on Act-On in Excel.

Configure the CData JDBC Driver for Act-On in a Connection Pool in Tomcat

Connect to Act-On from a connection pool in Tomcat.

Provide OData Services of Act-On from a WCF Application

In this article, we will demonstrate the process of generating an OData feed for Act-On by developing a WCF Service Application.

Automate Act-On Integration Tasks from PowerShell

Build Data Flows from Act-On to SQL Server using SSIS

Easily back up Act-On to SQL Server using the SSIS components for Act-On.

Create Dynamic Act-On Grids Using the Infragistics XamDataGrid

Learn how you can connect Act-On to Infragistics XamDataGrid to build dynamic grids.

Analyze Act-On in Slingshot with CData API Server

Use the CData API Server to build an OData API on top of Act-On and visualize the live in Slingshot (formerly Reveal BI) for seamless insights.

Build AI/ML Models with Live Act-On Data using Dataiku

Connect Act-On Data with Dataiku using the [product_name].

ETL Act-On in Oracle Data Integrator

This article shows how to transfer Act-On into a data warehouse using Oracle Data Integrator.

Connect to Act-On from a Connection Pool in WebLogic

Use the CData JDBC Driver for Act-On to connect to Act-On from Web applications running on WebLogic.

Integrate Act-On in Pentaho Data Integration

Build ETL pipelines based on Act-On in the Pentaho Data Integration tool.

Explore Geographical Relationships in Act-On with Power Map

Create data visualizations with Act-On in Power Map.

How to Connect to & Open Act-On in Microsoft Excel

This article uses the CData ODBC driver for Act-On to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.

DataBind Controls to Act-On in Delphi

DataBind to Act-On in Delphi with standard data access components and controls.

Natively Connect to Act-On in PHP via ODBC (Linux)

Create PHP applications on Linux/UNIX machines with connectivity to Act-On. Leverage the native support for ODBC in PHP.

Use CData Connect AI to Access Act-On in Microsoft Power Pivot

Use CData Connect AI to connect to live Act-On in the Power Pivot business intelligence tool.

Connect to Act-On from Asprova with CData Software ODBC Driver for Act-On

This article shows how to connect faster to Act-On data from Asprova.

Build MVC Applications with Connectivity to Act-On

This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Act-On from an ASP.NET MVC application.

Using the CData Software ODBC Driver for Act-On in PyCharm

Connect to Act-On as an ODBC data source in PyCharm using the CData Software ODBC Driver for Act-On.

How to connect to Act-On in DBVisualizer

Integrate Act-On with visual data analysis tools and data connection wizards in DBVisualizer

Use the CData ODBC Driver for Act-On from SharePoint Excel Services

Connect to Live Act-On in PostGresSQL Interface through CData Connect AI

Create a live connection to Act-On in CData Connect AI and connect to your Act-On from PostgreSQL.

Create SSAS Tabular Models from Act-On

How to build a SQL Server Analysis Service Tabular Model from Act-On using CData drivers.

Visualize Live Act-On in Tableau

Use CData Tableau Connectors and Tableau Desktop to visualize live Act-On.

How to Visualize Act-On Data in Python with pandas

Use pandas and other modules to analyze and visualize live Act-On in Python.

Build Data Flows from SQL Server to Act-On through SSIS

Easily push SQL Server data to Act-On using the CData SSIS Tasks for Act-On.

Viewing Act-On in RAD Studio Data Explorer

How to view Act-On in RAD Studio Data Explorer using the CData ODBC Driver for Act-On.

Consume Act-On OData Feeds in PowerBuilder

This article demonstrates how to consume Act-On as OData feeds from PowerBuilder using the API Server.

Build Act-On-Connected Web Apps with Axios and CData Connect AI

Use CData Connect AI to connect to live Act-On and build Act-On-connected web apps with Axios.

Work with Act-On in FoxPro

Load Act-On into a FoxPro database. This article includes full code and a walk-through of the process.

Connect to Act-On through External Services in Salesforce

Connect to and Query Act-On in QlikView over ODBC

Create data visualizations with Act-On in QlikView.

How to update Act-On from Excel

This article explains how to transfer data from Excel to Act-On using the Excel Add-In for Act-On.

Connect to Act-On in Claris FileMaker Pro

Use the [product_name] in FileMaker Pro to connect to Act-On and work with Act-On in your FileMaker applications.

Edit and Search Act-On External Objects in Salesforce Connect (API Server)

Connect to Act-On in CloverDX (formerly CloverETL)

Transfer Act-On using the visual workflow in the CloverDX data integration tool.

Connect to Act-On from PowerBuilder via ODBC

This article demonstrates how to use the CData ODBC Driver for Act-On to connect to Act-On and execute queries in PowerBuilder.

How to Build an ETL App for Act-On in Python with CData

Create ETL applications and real-time data pipelines for Act-On in Python with petl.

Access Act-On in Mule Applications Using the CData JDBC Driver

Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Act-On.

Bidirectional Access to Act-On from FileMaker Pro

Use the MySQL Remoting feature of the JDBC driver to integrate Act-On in Filemaker Pro for Mac or Windows.

Visualize Act-On in TIBCO Spotfire through OData

Integrate Act-On into dashboards in TIBCO Spotfire.

How to Use a Microsoft Access Database to Update Act-On in Real Time

Update Act-On data by creating a linked table in Microsoft Access with the CData Act-On ODBC Driver.

Use Dash to Build to Web Apps on Act-On

Create Python applications that use pandas and Dash to build Act-On-connected web apps.

Extract, Transform, and Load Act-On in Informatica PowerCenter

Create a simple Workflow for Act-On in Informatica PowerCenter.

Publish Act-On-Connected Dashboards in Tableau Server via JDBC

Use CData JDBC drivers and Tableau Server to visualize live Act-On.

Build Dashboards with Act-On in DBxtra

Create dynamic dashboards and perform analytics based on Act-On in DBxtra.

How to Access Act-On Using Entity Framework

This article shows how to access Act-On using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.

Connect to Act-On from a Connection Pool in JBoss

Integrate Act-On into Java servlets: Use the Management Console in JBoss to install the Act-On JDBC Driver.

Integrate with Act-On in JReport Designer

Create charts and reports based on Act-On in JReport Designer.

Migrating data from Act-On to Snowflake using CData SSIS Components.

Easily push Act-On to Snowflake using the CData SSIS Tasks for Act-On and Snowflake.

Load Act-On to a Database Using Embulk

Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Act-On to a database.

Connect to Act-On from PowerBuilder via JDBC

This article demonstrates how to access Act-On from PowerBuilder using the Act-On JDBC Driver.

Create Reports with Act-On in SAP Crystal Reports

Use the Report Wizard to design a report based on up-to-date Act-On.

Create an SAP BusinessObjects Universe on the CData JDBC Driver for Act-On

Provide connectivity to Act-On through an SAP BusinessObjects universe.

DataBind Act-On to the DevExpress Data Grid

Use the CData Software ADO.NET Provider for Act-On with the DevExpress Windows Forms and Web controls to provide Act-On to a chart.

CData is the data layer that makes AI work in production—live connectivity and replication across hundreds of the most critical enterprise sources, semantic context, and built-in governance. Powering AI for Databricks, Microsoft, Google, Palantir, and 10,000+ customers worldwide.