Discover how a bimodal integration strategy can address the major data management challenges facing your organization today.
Get the Report →
Act-On Integration Guides and Tutorials
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.
- 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.)
Business Intelligence & Analytics
ETL & Replication
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 Cloud | Build Semantic Layer Views for Act-On Data (Connect Cloud) |
| 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 Cloud | Edit and Search Act-On External Objects in Salesforce Connect |
| SQL Server Linked Servers | ODBC | Connect to Act-On as a Linked Server |
| SQL Server PolyBase | Connect Cloud | Connect to Act-On Data using PolyBase with Connect Cloud |
| 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
Data Management
| Product | Technology | Article Title |
|---|---|---|
| Apache Solr | JDBC | Import Act-On Data into Apache Solr |
| 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 |
| Informatica Enterprise Data Catalog | JDBC | Add Act-On to Informatica Enterprise Data Catalog |
| MySQL Workbench | Connect Server | Query Act-On Data in MySQL Workbench (Connect Server) |
| 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 |
|---|---|---|
| MuleSoft Anypoint | JDBC | Access Act-On in Anypoint Using SQL |
| Nintex Workflow Cloud | Connect Cloud | Build Act-On-Connected Workflows in Nintex |
| Power Automate | Connect Cloud | 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 |
Data Connectors
ETL/ ELT Solutions
Cloud & API Connectivity
OEM & Custom Drivers