CData Software - Knowledge Base
Recent Articles
-
Write a Simple Go Application to work with Adobe Analytics Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Adobe Analytics data.
-
Work with MailChimp Data in FoxPro
Load MailChimp data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to Google Drive Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Google Drive.
-
Getting Started with the CData Python Connector for MailChimp
Learn to install and license the CData Python Connector and configure a connection to live MailChimp data.
-
Integrate with Oracle Data in JReport Designer
Create charts and reports based on Oracle data in JReport Designer.
-
Use Claude to Talk to Your Google Campaign Manager 360 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 Google Campaign Manager 360 data for you.
-
Automate Yelp Data Replication to Couchbase
Use CData Sync to Customize and automate Yelp data replication to Couchbase.
-
Access Live Tavily Data in Excel 365 Online (Excel for the web)
Connect to Tavily data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Migrating data from AgileCRM to Snowflake using CData SSIS Components.
Easily push AgileCRM data to Snowflake using the CData SSIS Tasks for AgileCRM and Snowflake.
-
Connect to Sugar CRM Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Sugar CRM data in Airbyte.
-
How to import Keap Data into Apache Solr
Use the CData Software JDBC Driver for Keap in Data Import Handler and create an automated import of Keap data to Apache Solr Enterprise Search platform.
-
Access Splunk Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Splunk data from HeidiSQL.
-
Getting Started with the CData Python Connector for Access
Learn to install and license the CData Python Connector and configure a connection to live Access data.
-
Create Highrise-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Highrise Data from Klipfolio and build custom visualizations using live Highrise data.
-
Integrating WordPress Data in Talend Cloud Data Management Platform
Connect WordPress Data with Talend Cloud Data Management Platform using the CData JDBC Driver for WordPress.
-
Query Live ZohoExpense Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live ZohoExpense data directly from the development environment.
-
Build a PostgreSQL Interface for Sugar CRM Data using the CData JDBC Driver
Use the Remoting features of the Sugar CRM JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connecting Agentforce with PostgreSQL Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your PostgreSQL data for you.
-
Build Vault CRM Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Vault CRM data and build visualizations in Tableau Cloud.
-
Migrating data from Keap to Snowflake using CData SSIS Components.
Easily push Keap data to Snowflake using the CData SSIS Tasks for Keap and Snowflake.
-
Design BIRT Reports on Google Forms Data
Provide current Google Forms data to your embedded analytics.
-
Create Informatica Mappings From/To a JDBC Data Source for ServiceNow
Create ServiceNow data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Migrating data from SAS xpt to Databricks using CData SSIS Components.
Easily push SAS xpt data to Databricks using the CData SSIS Tasks for SAS xpt and Databricks.
-
Using the CData Software ODBC Driver for Reckon Accounts Hosted in PyCharm
Connect to Reckon Accounts Hosted as an ODBC data source in PyCharm using the CData Software ODBC Driver for Reckon Accounts Hosted.
-
Create Informatica Mappings From/To a JDBC Data Source for SQL Server
Create SQL Server data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to Work with ZohoExpense Data in AWS Glue Jobs Using JDBC
Connect to ZohoExpense from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automated Continuous Tally Replication to MySQL
Use CData Sync for automated, continuous, customizable Tally replication to MySQL.
-
Integrate Live QuickBooks Online Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to QuickBooks Online data and integrate live QuickBooks Online data into apps built in Microsoft Power Apps.
-
Getting Started with the CData Power BI Connector for Webflow
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
How to Access Live LinkedIn Ads Data in Power Automate Desktop via ODBC
The CData ODBC Driver for LinkedIn Ads enables you to integrate LinkedIn Ads data into workflows built using Microsoft Power Automate Desktop.
-
Connect Paylocity Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Paylocity data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to Build an ETL App for WordPress Data in Python with CData
Create ETL applications and real-time data pipelines for WordPress data in Python with petl.
-
Visualize QuickBooks 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 QuickBooks data into TIBCO Spotfire.
-
How to Visualize Azure Analysis Services Data in Python with pandas
Use pandas and other modules to analyze and visualize live Azure Analysis Services data in Python.
-
Automated Continuous Webflow Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Webflow replication to PostgreSQL.
-
Query CSV Data in DataGrip
Create a Data Source for CSV in DataGrip and use SQL to query live CSV data.
-
Visualize Azure DevOps Data in Sisense
Create an ElastiCube in Sisense app with access to Azure DevOps data.
-
Connect to Live SAP Netweaver Gateway Data in MicroStrategy through CData Connect AI
Create a live connection to SAP Netweaver Gateway Data in CData Connect AI and connect to your SAP Netweaver Gateway data from MicroStrategy.
-
Load Bitly Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Bitly data to a database.
-
Visualize Live MessageBird Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live MessageBird data.
-
Create Dashboards and Visualize Live BigCommerce Data in Geckoboard
Use CData Connect AI to connect to live BigCommerce data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Connect to ChargeOver Data in NetBeans
Connect to ChargeOver data in NetBeans with the data source configuration wizard.
-
Model, Search, and Visualize Live Sage Intacct Data in ThoughtSpot
Use CData Connect AI to connect to live Sage Intacct data for modeling, searching, and visualizing.
-
Analyze Avalara AvaTax Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Avalara AvaTax data and visualize live Avalara AvaTax data in Infragistics Reveal.
-
Use the CData ODBC Driver for Elasticsearch in Microsoft Power Query
You can use the CData Elasticsearch ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Elasticsearch data into Microsoft Power Query.
-
How to create an RPA flow for Excel Online Data in UiPath Studio
Use the Excel Online ODBC Driver to create workflows that access real-time Excel Online data without any coding.
-
Integrate Theia IDE with Live Zoho Projects Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Zoho Projects data from within the development environment.
-
Validate Retently Data with QuerySurge
Access and validate Retently data in QuerySurge using the CData JDBC Driver.
-
Mailjet Reporting in OBIEE with the Mailjet JDBC Driver
Deploy the Mailjet JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Replicate Teamwork Data to Multiple Databases
Replicate Teamwork data to disparate databases with a point-and-click configuration.
-
Build Automated Google Contacts-Connected Workflows in Zapier
Use CData Connect AI to connect to live Google Contacts data and build automated workflows in Zapier.
-
Extract, Transform, and Load Microsoft Ads Data in Informatica PowerCenter
Create a simple Workflow for Microsoft Ads data in Informatica PowerCenter.
-
Connect to Clari Data in JRuby
Create a simple JRuby app with access to live Clari data.
-
Connect to EnterpriseDB Data in Ruby
Connect to EnterpriseDB data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
DataBind Controls to Avro Data in C++Builder
DataBind to Avro data in C++Builder with standard components and controls.
-
Integrating Claude Code with Act-On Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Act-On data within assisted coding and automated development workflows.
-
Build ClickUp-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to ClickUp data and build web apps with connectivity to live ClickUp data.
-
Replicate Multiple GetResponse Accounts
Replicate multiple GetResponse accounts to one or many databases.
-
Connect to eBay Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with eBay Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Analyze Live SAP Ariba Source Data in SAS Viya
Use CData Connect AI to connect to SAP Ariba Source data from SAS Viya and deploy self-service analytics using live SAP Ariba Source data.
-
Create Informatica Mappings From/To a JDBC Data Source for HDFS
Create HDFS data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Integrating Gumloop with Redshift Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Redshift data within automated workflows.
-
Build Microsoft Entra ID Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Microsoft Entra ID data and build visualizations in Tableau Cloud.
-
Getting Started with the CData Excel Add-In for Xero
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Xero.
-
A PostgreSQL Interface for Exa Data (MySQL Remoting via JDBC)
Use the Remoting features of the Exa JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Data Flows from Mocean to SQL Server using SSIS
Easily back up Mocean data to SQL Server using the SSIS components for Mocean.
-
A PostgreSQL Interface for Calendly Data using the CData ODBC Driver
Use the SQL Gateway and Calendly ODBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous AdRoll Replication to MongoDB
Use CData Sync for automated, continuous, customizable AdRoll replication to MongoDB.
-
Load Yelp Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Yelp data to a database.
-
Access Live SAP Fieldglass Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate SAP Fieldglass data into the statistical analysis tools available in SAS JMP. This article shows how to use SAP Fieldglass data in the Graph Builder and Query Builder.
-
How to load QuickBooks Time data into Elasticsearch via Logstash
Introducing a simple method to load QuickBooks Time data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to Dynamics 365 in SpagoBI
Create reports featuring live Dynamics 365 data in SpagoBI Studio. Host Dynamics 365 reports on SpagoBI Server.
-
Access Live Salesloft 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 Salesloft data through MCP integration.
-
Connect to NASA from Asprova with CData Software ODBC Driver for NASA
This article shows how to connect faster to NASA data from Asprova.
-
How to Query Sage 200 Data in MySQL Workbench
Execute MySQL queries against live Sage 200 data from MySQL Workbench.
-
Integrating LangGraph with iContact Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on iContact data within automated workflows.
-
Integrating Google Calendar Data in Talend Cloud Data Management Platform
Connect Google Calendar Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Google Calendar.
-
Create Power BI Reports on Real-Time Active Directory Data
Use the CData ODBC Driver for Active Directory to visualize Active Directory data in Power BI Desktop.
-
Create Bugsnag Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Bugsnag from PowerBI.com to create Power BI Dataflows with real-time data.
-
Access ShipEngine Data from MySQL in PHP
Connect to ShipEngine through the standard MySQL libraries in PHP.
-
Connect to OneNote Data from a Connection Pool in JBoss
Integrate OneNote data into Java servlets: Use the Management Console in JBoss to install the OneNote JDBC Driver.
-
How to Connect to Live Microsoft Ads Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Microsoft Ads data for you.
-
How to Connect to Live Wave Financial Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Wave Financial data without replication.
-
Getting Started with the CData Excel Add-In for Productboard
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Productboard.
-
Getting Started with the CData Excel Add-In for Typeform
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Typeform.
-
Creating Salesforce Data 360-Connected Applications in Unqork
You can use CData Connect AI to feed Salesforce Data 360 data to Unqork and build custom business apps.
-
Connect to BenchmarkEmail Data from a Connection Pool in Jetty
The BenchmarkEmail JDBC Driver supports connection pooling: This article shows how to connect faster to BenchmarkEmail data from Web apps in Jetty.
-
Publish Crystal Reports on Wrike Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Wrike data.
-
Establish a Live Connection with IBM Informix Data using Tableau Bridge
The CData ODBC Driver for IBM Informix enables you to integrate live IBM Informix data into Tableau Cloud dashboards using the Tableau Bridge.
-
How to publish and share Adobe Commerce Data dashboards with Tableau Server
The CData ODBC driver for Adobe Commerce enables you integrate Adobe Commerce data into Tableau dashboards.
-
Migrating data from Mistral AI to Snowflake using CData SSIS Components.
Easily push Mistral AI data to Snowflake using the CData SSIS Tasks for Mistral AI and Snowflake.
-
Integrating Claude Code with eBay Analytics Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on eBay Analytics data within assisted coding and automated development workflows.
-
Analyze Oracle Eloqua Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Oracle Eloqua data and visualize Oracle Eloqua data in SAP Analytics Cloud.
-
How to Work with Float Data in ETL Validator JDBC
Connect to Float from ETL Validator jobs using the CData Software JDBC Driver.
-
Automated Continuous LinkedIn Ads Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable LinkedIn Ads replication to Amazon Redshift.
-
Publish Gong-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Gong data.
-
Query Live Google Search Results in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Google Search results directly from the development environment.
-
Connect to Mixpanel Data from a Connection Pool in Jetty
The Mixpanel JDBC Driver supports connection pooling: This article shows how to connect faster to Mixpanel data from Web apps in Jetty.
-
Analyze Guru Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Guru data with the CData JDBC Driver for Guru.
-
Automated Continuous Active Directory Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Active Directory replication to Amazon S3.