CData Software - Knowledge Base
Recent Articles
-
Publish Crystal Reports on HCL Domino Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date HCL Domino.
-
How to Query Live MarkLogic Data in Claude Desktop
Connect to and query live MarkLogic Data in Claude Desktop using CData MCP Server.
-
Create Dashboards and Visualize Live Pipedrive Data in Geckoboard
Use CData Connect AI to connect to live Pipedrive and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Integrating GitHub Copilot CLI with CSV/TSV Files via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
Visualize Amazon Athena Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Amazon Athena.
-
Analyze Outreach.io Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Outreach.io and visualize Outreach.io in SAP Analytics Cloud.
-
Query Cloudflare Data in ColdFusion
Write standard ColdFusion data access code to connect to Cloudflare.
-
Build Box-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Box.
-
Use the CData Software ODBC Driver for Helpscout in SAS for Real-Time Reporting and Analytics
Connect to real-time Helpscout in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Helpscout.
-
Process & Analyze Paymo Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Paymo Data.
-
How to connect to Simplesat Data in DBVisualizer
Integrate Simplesat with visual data analysis tools and data connection wizards in DBVisualizer
-
Enable the MariaDB JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with MariaDB.
-
Integrate Open WebUI with Live SharePoint Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Microsoft SharePoint from within the chat interface.
-
Automate SpaceX Data Replication to Couchbase
Use CData Sync to Customize and automate SpaceX replication to Couchbase.
-
Query Pinterest Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Pinterest and perform CRUD operations on Pinterest from Node.js.
-
Create Datasets from Discourse in Domo Workbench and Build Visualizations of Discourse Data in Domo
Use the CData Software ODBC Driver for Discourse to create datasets from Discourse in Domo Workbench and then build visualizations in the Domo service.
-
How to load Foursquare data into Elasticsearch via Logstash
Introducing a simple method to load Foursquare data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Automated Continuous Klipfolio Replication to SingleStore
Use CData Sync for automated, continuous, customizable Klipfolio replication to SingleStore.
-
Getting Started with the CData Python Connector for Sugar CRM
Learn to install and license the CData Python Connector
-
Use the CData Software ODBC Driver for Guru in MicroStrategy Desktop
Connect to Guru in MicroStrategy Desktop using the CData Software ODBC Driver for Guru.
-
Use Manus AI to Talk to Your Act CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Act CRM.
-
Import MarkLogic Data Using Azure Data Factory
Use CData Connect AI to connect to MarkLogic Data from Azure Data Factory and import live MarkLogic.
-
Build MVC Applications with Connectivity to Kafka Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Kafka from an ASP.NET MVC application.
-
Easily Integrate Shortcut Data in Lazarus Pascal IDE
Learn how to easily integrate live Shortcut in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Automated Continuous Parquet Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Parquet replication to Google BigQuery.
-
Bidirectional Access to ZohoSubscriptions Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate ZohoSubscriptions in Filemaker Pro for Mac or Windows.
-
How to Connect to Live MySQL Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your MySQL for you.
-
How to Update Salesforce Records from Excel with CDATAUPDATE: Excel Add-In for Salesforce
Learn how to connect Excel to Salesforce and update records using the CDATAUPDATE formula with the CData Excel Add-In for Salesforce
-
Create AdRoll Dataflows on PowerBI.com
Connect to the CData Power BI Connector for AdRoll from PowerBI.com to create Power BI Dataflows with real-time data.
-
Automated Continuous Sage Cloud Accounting Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Sage Cloud Accounting replication to IBM DB2.
-
Build Automated EnterpriseDB-Connected Workflows in Zapier
Use CData Connect AI to connect to live EnterpriseDB and build automated workflows in Zapier.
-
Visualize Clio Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Clio into TIBCO Spotfire.
-
Automated Continuous Presto Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Presto replication to PostgreSQL.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Highrise CRM to Power BI dashboards. Simply drag and drop Highrise CRM into data visuals on the Power BI canvas.
-
How to Connect to Outreach.io Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Outreach.io. Leverage the pyodbc module for ODBC in Python.
-
Import LinkedIn Ads Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access LinkedIn Ads. In this article, you will use the OData format to import LinkedIn Ads into Microsoft Power Query.
-
DataBind Controls to Guru Data in C++Builder
DataBind to Guru in C++Builder with standard components and controls.
-
Automated Continuous Clio Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Clio replication to IBM DB2.
-
Integrating Google Tasks Data in Talend Cloud Data Management Platform
Connect Google Tasks Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Connect to Spark from Asprova with CData Software ODBC Driver for Spark
This article shows how to connect faster to Spark data from Asprova.
-
Automated Continuous Datadog Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Datadog replication to AlloyDB.
-
Automated Continuous SAS xpt Replication to Snowflake
Use CData Sync for automated, continuous, customizable SAS xpt replication to Snowflake.
-
How to Query Live Vercel Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Vercel data in natural language using Python.
-
Use Claude to Talk to Your Salesforce Marketing Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Salesforce Marketing Cloud for you.
-
Integrate with AdRoll Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy AdRoll to a JSON file on disk.
-
Visualize Live MySQL Data in the Power BI Service
Use CData Connect AI to connect to live MySQL and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Intercom Data from a Connection Pool in JBoss
Integrate Intercom into Java servlets: Use the Management Console in JBoss to install the Intercom JDBC Driver.
-
Integrate Open WebUI with Live Trello Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Trello from within the chat interface.
-
Use Databricks Agent Bricks to Talk to Your Confluence Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Atlassian Confluence for you.
-
Connect to Email Data in CloverDX (formerly CloverETL)
Transfer Email using the visual workflow in the CloverDX data integration tool.
-
Replicate Multiple PagerDuty Accounts
Replicate multiple PagerDuty accounts to one or many databases.
-
Connecting GenSpark with DB2 Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to IBM DB2 without any replication or custom integration required.
-
Integrating GitHub Copilot CLI with Apollo via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
Integrate Live ZarMoney Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live ZarMoney to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Automated Continuous Dynamics 365 Business Central Replication to Snowflake
Use CData Sync for automated, continuous, customizable Dynamics 365 Business Central replication to Snowflake.
-
Automated Continuous GetResponse Replication to MySQL
Use CData Sync for automated, continuous, customizable GetResponse replication to MySQL.
-
Access Live Sage Intacct Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Sage Intacct into the statistical analysis tools available in SAS JMP. This article shows how to use Sage Intacct in the Graph Builder and Query Builder.
-
Integrate GitLab with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate GitLab with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to GitLab.
-
Use JayDeBeApi to access Apify Data in Python
Use standard Python scripting and the development environment of your choice to access live Apify.
-
Connect to Jira Assets Data in ACL Analytics
Connect to Jira Assets via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Jira Assets.
-
Connecting GenSpark with Microsoft OneDrive Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Microsoft OneDrive without any replication or custom integration required.
-
Access Live Microsoft Ads Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Microsoft Ads through MCP integration.
-
Migrating data from Email to Google BigQuery using CData SSIS Components.
Easily push Email to Google BigQuery using the CData SSIS Tasks for Email and Google BigQuery.
-
Connect to Exact Online Data from PowerBuilder via ADO.NET
This article demonstrates how to access Exact Online from Appeon PowerBuilder using the CData ADO.NET Provider for Exact Online.
-
Use the CData Software ODBC Driver for Certinia in MicroStrategy
Connect to Certinia in MicroStrategy Developer using the CData Software ODBC Driver for Certinia.
-
Integrate ZohoMarketingHub with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate ZohoMarketingHub with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to ZohoMarketingHub.
-
How to connect SharePoint with Google Drive Data through external lists
Provide Google Drive to SharePoint users as an external list.
-
How to connect PolyBase to Google Spanner
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Google Spanner.
-
Visualize Postmark Data in TIBCO Spotfire through ADO.NET
Integrate Postmark into dashboards in TIBCO Spotfire.
-
Automated Continuous Cloudant Replication to SQLite
Use CData Sync for automated, continuous, customizable Cloudant replication to SQLite.
-
How to import Unbounce Data into Apache Solr
Use the CData Software JDBC Driver for Unbounce in Data Import Handler and create an automated import of Unbounce to Apache Solr Enterprise Search platform.
-
Connect to FreshBooks Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to FreshBooks and work with FreshBooks in your FileMaker application.
-
Build Visualizations of Cassandra Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Apache Cassandra in Birst.
-
How to publish and share Eventbrite Data dashboards with Tableau Server
The CData ODBC driver for Eventbrite enables you integrate Eventbrite into Tableau dashboards.
-
How to publish and share Jira Assets Data dashboards with Tableau Server
The CData ODBC driver for Jira Assets enables you integrate Jira Assets into Tableau dashboards.
-
Automate Pipeliner CRM Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Pipeliner CRM from PowerShell? This article demonstrates how to utilize the Pipeliner CRM Cmdlets for tasks like connecting to Pipeliner CRM, automating operations, downloading data, and more.
-
How to Access Live Mocean Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Mocean enables you to integrate Mocean into workflows built using Microsoft Power Automate Desktop.
-
Build Snowflake-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Snowflake.
-
Integrating LlamaIndex with Exact Online Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Exact Online in real time.
-
Rapidly Develop Eventbrite-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Eventbrite.
-
How to Query Vault CRM Data in MySQL Workbench
Execute MySQL queries against live Veeva Vault & Vault CRM from MySQL Workbench.
-
Create Dynamic SendInBlue Grids Using the Infragistics XamDataGrid
Learn how you can connect SendInBlue to Infragistics XamDataGrid to build dynamic grids.
-
Create Power BI Reports on Real-Time Coinbase Data
Use the CData ODBC Driver for Coinbase to visualize Coinbase in Power BI Desktop.
-
Use Dash to Build Web Apps on SAP Fieldglass Data via CData Connect AI
Build interactive Dash web apps on live SAP Fieldglass using pandas and the CData Connect AI Python SDK.
-
Create LinkedIn-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to LinkedIn Data from OutSystems and build custom enterprise apps using live LinkedIn.
-
Operational Reporting on BigCommerce Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote BigCommerce.
-
Prepare, Blend, and Analyze Redis Data in Alteryx Designer (Connect AI)
Build workflows to access live Redis for self-service data analytics.
-
Integrate Live Teradata Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Teradata to Blue Prism using the CData ODBC Driver for Teradata to create automated workflows for repetitive business tasks.
-
Access Billsby Data 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 Billsby.
-
Connect to Sage Intacct Data from a Connection Pool in Jetty
The Sage Intacct JDBC Driver supports connection pooling: This article shows how to connect faster to Sage Intacct from Web apps in Jetty.
-
Connecting GenSpark with FHIR Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to FHIR without any replication or custom integration required.
-
How to connect and process LinkedIn Ads from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live LinkedIn Ads.
-
How to Connect Flowise AI Agents to Live Klaviyo Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Klaviyo without replication.
-
How to update PostgreSQL from Excel
This article explains how to transfer data from Excel to PostgreSQL using the Excel Add-In for PostgreSQL.
-
Connect Eventbrite to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Eventbrite with IBM WebSphere for seamless data integration and connectivity.
-
Model Salesforce Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Salesforce, enabling the direct import of real-time Salesforce & Force.com.
-
How to use SQLAlchemy ORM to access Sendwithus Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Sendwithus.
-
Use ChatGPT to Talk to Your SQL Analysis Services Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your SQL Analysis Services for you.
-
Migrating data from Klipfolio to Databricks using CData SSIS Components.
Easily push Klipfolio to Databricks using the CData SSIS Tasks for Klipfolio and Databricks.
-
Integrating Antigravity CLI with Copper via CData CLI
Connect Copper to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.