CData Software - Knowledge Base
Recent Articles
-
Access Live ChartMogul Data in AWS Lambda (with IntelliJ IDEA)
Connect to live ChartMogul data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrate Timely Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Timely data and integrate live Timely data into your Power Automate tasks.
-
Connect LeadDesk Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your LeadDesk data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Replicate Box Data to Multiple Databases
Replicate Box data to disparate databases with a point-and-click configuration.
-
Create SSAS Tabular Models from SharePoint Data
How to build a SQL Server Analysis Service Tabular Model from SharePoint data using CData drivers.
-
Integrating Codex with Microsoft Ads data 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.
-
Use the CData ODBC Driver for RSS in Microsoft Power Query
You can use the CData RSS ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import RSS feeds into Microsoft Power Query.
-
Connect to Azure Analysis Services Data from AWS Glue
Use CData Connect AI to gain access to live Azure Analysis Services data from your AWS Glue jobs.
-
Access IBM Informix 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 IBM Informix data.
-
How to Connect the Power BI Service to Hubstaff: Complete Guide
Connect to the CData Software Power BI Connector for Hubstaff from PowerBI.com to provide real-time Hubstaff data across the organization.
-
Stream Asana Data into Apache Kafka Topics
Access and stream Asana data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Use the CData Software ODBC Driver for FreshBooks in MicroStrategy Desktop
Connect to FreshBooks data in MicroStrategy Desktop using the CData Software ODBC Driver for FreshBooks.
-
Access Live Humanity Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Humanity data into the statistical analysis tools available in SAS JMP. This article shows how to use Humanity data in the Graph Builder and Query Builder.
-
DataBind Controls to NetSuite Data in Delphi
DataBind to NetSuite data in Delphi with standard data access components and controls.
-
Integrate with Highrise Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Highrise data to a JSON file on disk.
-
Migrating data from ZohoMarketingHub to Google BigQuery using CData SSIS Components.
Easily push ZohoMarketingHub data to Google BigQuery using the CData SSIS Tasks for ZohoMarketingHub and Google BigQuery.
-
Integrate Goose with Live QuickBooks Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live QuickBooks data from within the local AI agent.
-
Integrate Campaigner Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Campaigner data from Informatica Cloud.
-
Access Live PabblySubscriptions Data in Coginiti Pro
Connect to and query live PabblySubscriptions data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to Create Power BI Visual Reports with Real-Time ClickTime Data
Use CData Power BI Connectors to visualize ClickTime data in Power BI.
-
Access Live Elorus Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Elorus data into the statistical analysis tools available in SAS JMP. This article shows how to use Elorus data in the Graph Builder and Query Builder.
-
Query Jira Assets Data as a SQL Server Database in Node.js
Execute SQL Server queries against Jira Assets data from Node.js.
-
Rapidly Develop Harvest-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 Harvest.
-
Getting Started with the CData Python Connector for Box
Learn to install and license the CData Python Connector and configure a connection to live Box data.
-
Integrate Instagram with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Instagram with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Instagram data.
-
Analyze MailChimp Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for MailChimp from Power Pivot. You will use the Table Import Wizard to load MailChimp data. You can visually build the import query or use any SQL supported by the driver.
-
Build Samanage Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Samanage data and build visualizations in Tableau Cloud.
-
How to Connect to Dynamics 365 Business Central Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Dynamics 365 Business Central data. Leverage the pyodbc module for ODBC in Python.
-
Connect to JotForm Data from PowerBuilder via JDBC
This article demonstrates how to access JotForm data from PowerBuilder using the JotForm JDBC Driver.
-
Visualize Live Microsoft Ads Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Microsoft Ads data.
-
How to Easily Query Amazon Marketplace Data in OpenOffice Base
Connect to Amazon Marketplace data in OpenOffice Base using the CData ODBC Driver for Amazon Marketplace and generate reports with live data insights.
-
Connect to and Visualize Live Postmark Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Postmark data.
-
Connect SendPulse to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live SendPulse data using the CData Python MCP Server.
-
Create Informatica Mappings From/To a JDBC Data Source for Mocean
Create Mocean data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to Box Data in DBeaver
Use the CData ODBC Driver to connect to Box data in DBeaver.
-
DataBind Controls to Pipeline CRM Data in C++Builder
DataBind to Pipeline CRM data in C++Builder with standard components and controls.
-
Load PDFMonkey Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load PDFMonkey data to a database.
-
Connect to QuickBooks Online Data in Ruby
Connect to QuickBooks Online data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Access Live Email 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 Email data through MCP integration.
-
How to Visualize Odoo Data in Python with pandas
Use pandas and other modules to analyze and visualize live Odoo data in Python.
-
Connect to Real-Time Customer.io Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Customer.io data in Power Apps.
-
Process & Analyze Azure DevOps Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Azure DevOps Data.
-
DataBind Controls to OData Services in Delphi
DataBind to OData services in Delphi with standard data access components and controls.
-
Automated Continuous CapsuleCRM Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable CapsuleCRM replication to Google BigQuery.
-
Integrate Discourse with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Discourse with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Discourse data.
-
Load SuiteCRM Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load SuiteCRM data to a database.
-
Automated Continuous LinkedIn Replication to Databricks
Use CData Sync for automated, continuous, customizable LinkedIn replication to Databricks.
-
Automated Continuous Presto Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Presto replication to Azure SQL Database.
-
Integrate Trae with Live IBM Informix Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live IBM Informix data from within the AI-powered IDE.
-
Connect to Azure Data Lake Storage Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Azure Data Lake Storage data.
-
Automated Continuous Mouseflow Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Mouseflow data replication to OneLake in Microsoft Fabric.
-
Analyze ServiceNow Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of ServiceNow data and visualize ServiceNow data in SAP Analytics Cloud.
-
Publish Crystal Reports on Klipfolio Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Klipfolio data.
-
Build Agents in Relevance AI with Access to Live Monday.com Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Monday.com data within intelligent agent workflows.
-
Use the CData Software JDBC Driver for Shopify in MicroStrategy Desktop
Connect to Shopify data in MicroStrategy Desktop using the CData Software JDBC Driver for Shopify.
-
How to Work with EmailOctopus Data in ETL Validator JDBC
Connect to EmailOctopus from ETL Validator jobs using the CData Software JDBC Driver.
-
Provide OData Services of Cloudflare Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Cloudflare data by developing a WCF Service Application.
-
How to Easily Query Shippo Data in OpenOffice Base
Connect to Shippo data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Object-Relational Mapping (ORM) with Google Directory Data 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 Google Directory data into a Java-based ORM framework, Hibernate.
-
Publish Reports with DocuSign Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date DocuSign data.
-
Configure the CData JDBC Driver for Apollo in a Connection Pool in Tomcat
Connect to Apollo data from a connection pool in Tomcat.
-
Build Dashboards with PagerDuty Data in Dundas BI
Create dynamic dashboards and perform analytics based on PagerDuty data in Dundas BI.
-
Analyze Office 365 Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Office 365 data in Microsoft R Open.
-
Integrating Cursor with ChartMogul Data 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.
-
Load Act-On Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Act-On data to a database.
-
Integrate Google's Vertex AI Agent with Live Impala Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Impala data within intelligent workflows.
-
Build a Singer.io Tap for Neo4J With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Neo4J data using the CData Python Connector.
-
Analyze BigCommerce Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze BigCommerce data with the CData JDBC Driver for BigCommerce.
-
Automated Continuous Klipfolio Replication to Databricks
Use CData Sync for automated, continuous, customizable Klipfolio replication to Databricks.
-
Query Live DB2 Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live DB2 data through a conversational interface.
-
Integrate LinkedIn with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate LinkedIn with External Services.
-
How to Access Google Analytics Data Using Entity Framework
This article shows how to access Google Analytics data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Build Visualizations of Spotify Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Spotify data in Birst.
-
Build Aweber-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Aweber Data and create custom apps in Mendix.
-
Explore Geographical Relationships in Microsoft Ads Data with Power Map
Create data visualizations with Microsoft Ads data in Power Map.
-
Integrating Codex with Zuora data 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.
-
Connect to Phoenix Data in ACL Analytics
Connect to Phoenix data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Phoenix data.
-
Connect to SAP Ariba Source Data in ACL Analytics
Connect to SAP Ariba Source data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to SAP Ariba Source data.
-
Excel Spreadsheet Automation on Google Contacts Data with the QUERY Formula
Pull data from Google Contacts, automate spreadsheets, and more with the QUERY formula.
-
Automated Continuous Everhour Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Everhour replication to Apache Kafka.
-
Create Mouseflow Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Mouseflow from PowerBI.com to create Power BI Dataflows with real-time data.
-
Access Live BambooHR Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live BambooHR data from your Excel spreadsheets.
-
How to connect Amazon QuickSight to ZohoSubscriptions Data
Create a connection to ZohoSubscriptions data in CData Connect AI and insert ZohoSubscriptions data into Amazon QuickSight SPICE to build interactive dashboards.
-
Automated Qualaroo Data Replication to Teradata
Use CData Sync to Customize and automate Qualaroo data replication to Teradata.
-
Visualize Live Everhour Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Everhour data.
-
Connect to MailerLite Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to MailerLite and work with MailerLite data in your FileMaker applications.
-
Access Intercom Data from MySQL in PHP
Connect to Intercom through the standard MySQL libraries in PHP.
-
Create Apps from HDFS Data in Qlik Sense Cloud
Use CData Connect AI to connect to HDFS Data and build apps from live HDFS data in Qlik Sense Cloud.
-
Connect to Databricks Data in Ruby
Connect to Databricks data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Use Agno to Talk to Your Sybase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Sybase data for you.
-
Use Azure AI Foundry to Talk to Your Cassandra Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Cassandra data for you.
-
Access Live NetSuite Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live NetSuite data from your Excel spreadsheets.
-
Access Live Certinia Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Certinia data from your Excel spreadsheets.
-
Getting Started with the CData Connect AI Python SDK for Highrise
Install the CData Connect AI Python SDK to read and write live Highrise data with standard DB-API 2.0 Python code.
-
How to connect to Raisers Edge NXT Data from IntelliJ
Integrate connectivity to Raisers Edge NXT data with wizards in IntelliJ.
-
Use JayDeBeApi to access Sentry Data in Python
Use standard Python scripting and the development environment of your choice to access live Sentry data.
-
Automated Continuous Landbot Replication to SQL Server
Use CData Sync for automated, continuous, customizable Landbot replication to SQL Server.
-
How to Easily Query AdRoll Data in OpenOffice Base
Connect to AdRoll data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Use Grok to Talk to Your Salesforce Marketing Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Salesforce Marketing data for you.
-
Automated Continuous Quickbase Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Quickbase replication to Apache Cassandra.