CData Software - Knowledge Base
Recent Articles
-
Access Live OData Services in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate OData into the statistical analysis tools available in SAS JMP. This article shows how to use OData in the Graph Builder and Query Builder.
-
Choosing the Best Method to Connect MailChimp to SQL Server: 5 Options Explained
Discover multiple ways to connect and use MailChimp from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Replicate MessageBird Data to Multiple Databases
Replicate MessageBird to disparate databases with a point-and-click configuration.
-
Moving Data from Campaigner to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Campaigner data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Build Voice Agents in ElevenLabs with access to Live Jira Assets Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Jira Assets.
-
Use Databricks Agent Bricks to Talk to Your Xero Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Xero Accounting for you.
-
Add Pinecone Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Pinecone with the Informatica Enterprise Data Catalog to classify and organize data.
-
Use the CData Software ODBC Driver for Placid in SAS for Real-Time Reporting and Analytics
Connect to real-time Placid in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Placid.
-
Automated Continuous Eventbrite Replication to SQL Server
Use CData Sync for automated, continuous, customizable Eventbrite replication to SQL Server.
-
Use the CData Software ODBC Driver for Webflow in MicroStrategy Desktop
Connect to Webflow in MicroStrategy Desktop using the CData Software ODBC Driver for Webflow.
-
Build a Simple VCL Application for ADP Data
How to build a simple VCL Application to view ADP in RAD Studio using the CData ODBC Driver for ADP.
-
How to Build an ETL App for Discord Data in Python with CData
Create ETL applications and real-time data pipelines for Discord in Python with petl.
-
How to Visualize Printify Data in Python with pandas
Use pandas and other modules to analyze and visualize live Printify in Python.
-
Analyze Okta Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Okta and visualize live Okta in Infragistics Reveal.
-
Build Visualizations of SparkPost Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of SparkPost in Birst.
-
Integrate Cvent with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Cvent with External Services.
-
How to Design SendGrid Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to SendGrid from mobile and tablet Power Apps.
-
Analyze MailChimp Data in Looker
Use CData Connect AI to connect to MailChimp Data from Looker and build custom apps using live MailChimp.
-
Query Live Square 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 Square directly from the development environment.
-
Easily Integrate Todoist Data in Lazarus Pascal IDE
Learn how to easily integrate live Todoist in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Create a Data Access Object for MySQL Data using JDBI
A brief overview of creating a SQL Object API for MySQL in JDBI.
-
Access SAP Business One Data from MySQL in PHP
Connect to SAP Business One through the standard MySQL libraries in PHP.
-
Replicate Sugar CRM Data from PowerShell
Write a quick PowerShell script to query Sugar CRM. Use connectivity to the live data to replicate Sugar CRM to SQL Server.
-
How to Connect to Live NetSuite Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your NetSuite CRM & ERP for you.
-
Use the CData Software ODBC Driver for SAP Netweaver Gateway in MicroStrategy Desktop
Connect to SAP Netweaver Gateway in MicroStrategy Desktop using the CData Software ODBC Driver for SAP Netweaver Gateway.
-
Access Live TaxJar Data in TIBCO Data Virtualization
Use the TaxJar Tibco DV Adapter to create a TaxJar data source in TIBCO Data Virtualization Studio and gain access to live TaxJar from your TDV Server.
-
Migrating data from CircleCI to Snowflake using CData SSIS Components.
Easily push CircleCI to Snowflake using the CData SSIS Tasks for CircleCI and Snowflake.
-
Integrate Oracle Financials Cloud Data in the Pentaho Report Designer
Publish reports based on Oracle Financials Cloud in the Pentaho BI tool.
-
Integrating LangChain with FreshBooks Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on FreshBooks within automated workflows.
-
Manage EmailOctopus Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for EmailOctopus.
-
Automated Continuous Bannerbear Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Bannerbear replication to Apache Kafka.
-
Using the CData Software ODBC Driver for Drift in PyCharm
Connect to Drift as an ODBC data source in PyCharm using the CData Software ODBC Driver for Drift.
-
Connect to Freshservice Data in Google Apps Script via Connect AI
Use CData Connect AI to access Freshservice in Google Apps Script.
-
Connect to Planio Data in HULFT Integrate
Connect to Planio as a JDBC data source in HULFT Integrate
-
Publish Crystal Reports on Dynamics CRM Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Microsoft Dynamics CRM.
-
Build a Singer.io Tap for LDAP With the CData Python Connector
Learn how to easily build a Singer.io Tap for live LDAP data using
-
Build Voice Agents in ElevenLabs with access to Live Highrise Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Highrise CRM.
-
Integrate Live FHIR Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to FHIR and integrate live FHIR into apps built in Microsoft Power Apps.
-
Build Square-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Square to explore live Square Data in Claude Code to assist with building Square-powered applications.
-
DataBind Microsoft Exchange Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Microsoft Exchange with the DevExpress Windows Forms and Web controls to provide Microsoft Exchange to a chart.
-
Integrating Shippo Data in Talend Cloud Data Management Platform
Connect Shippo Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Automated Continuous Cloudant Replication to MongoDB
Use CData Sync for automated, continuous, customizable Cloudant replication to MongoDB.
-
Bridge JobNimbus Connectivity with Apache NiFi
Access and process JobNimbus in Apache NiFi using the CData JDBC Driver.
-
Use Biml to Build SSIS Tasks to Replicate Foursquare Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Foursquare to SQL Server.
-
Design BIRT Reports on Toggl Data
Provide current Toggl to your embedded analytics.
-
Connect to Real-Time Microsoft OneDrive Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Microsoft OneDrive and Dataflow to import and use Microsoft OneDrive in Power Apps.
-
Work with LionDesk Data in FoxPro
Load LionDesk into a FoxPro database. This article includes full code and a walk-through of the process.
-
Migrating data from CockroachDB to Google BigQuery using CData SSIS Components.
Easily push CockroachDB to Google BigQuery using the CData SSIS Tasks for CockroachDB and Google BigQuery.
-
Automated Continuous ZohoInvoice Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable ZohoInvoice replication to Apache Cassandra.
-
Automated Continuous Zoho CRM Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Zoho CRM replication to Azure SQL Database.
-
Use Biml to Build SSIS Tasks to Replicate Auth0 Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Auth0 to SQL Server.
-
Configure the CData JDBC Driver for AgileCRM in a Connection Pool in Tomcat
Connect to AgileCRM from a connection pool in Tomcat.
-
Bidirectional Access to Pipeline CRM Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Pipeline CRM in Filemaker Pro for Mac or Windows.
-
Visualize Airtable Data in Tableau
The CData ODBC driver for Airtable enables you integrate Airtable into Tableau dashboards.
-
Use the CData Software JDBC Driver for Perplexity in MicroStrategy Web
Connect to Perplexity in MicroStrategy Web using the CData Software JDBC Driver for Perplexity.
-
Getting Started with the CData ODBC Driver for Redis
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Redis.
-
How to connect PolyBase to LDAP
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live LDAP.
-
Access eBay Analytics Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live eBay Analytics from HeidiSQL.
-
Connect to Live Oracle Eloqua Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Oracle Eloqua in CData Connect AI and connect to your Oracle Eloqua from PostgreSQL.
-
Integrating LangChain with Google Campaign Manager 360 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Google Campaign Manager 360 within automated workflows.
-
How to load SAS Data Sets data into Elasticsearch via Logstash
Introducing a simple method to load SAS Data Sets data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Build Zoho Inventory-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Zoho Inventory to explore live Zoho Inventory Data in Cursor to assist with building Zoho Inventory-powered applications.
-
Replicate JobNimbus Data from PowerShell
Write a quick PowerShell script to query JobNimbus. Use connectivity to the live data to replicate JobNimbus to SQL Server.
-
Build Phoenix-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Phoenix to explore live Phoenix Data in Gemini Code Assist to assist with building Phoenix-powered applications.
-
Publish Salesloft-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Salesloft.
-
Feed Azure DevOps Data into FineReport
How to set Azure DevOps as a JDBC data source in FineReport.
-
Build Pipelines with Live Adobe Analytics Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Adobe Analytics from Google Cloud Data Fusion, enabling the integration of live Adobe Analytics into the building and management of effective data pipelines.
-
Configure the CData JDBC Driver for Calendly in a Connection Pool in Tomcat
Connect to Calendly from a connection pool in Tomcat.
-
Access Eventbrite 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 Eventbrite.
-
Design BIRT Reports on JSON Services
Provide current JSON to your embedded analytics.
-
Getting Started with the CData Connect AI Python SDK for Phoenix
Install the CData Connect AI Python SDK to read and write live Apache Phoenix with standard DB-API 2.0 Python code.
-
Automated Continuous Kintone Replication to Databricks
Use CData Sync for automated, continuous, customizable Kintone replication to Databricks.
-
Publish Crystal Reports on SAP SuccessFactors LMS Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date SAP SuccessFactors LMS.
-
Getting Started with the CData JDBC Driver for PagerDuty
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for PagerDuty.
-
How to connect to Retently Data from IntelliJ
Integrate connectivity to Retently with wizards in IntelliJ.
-
DataBind Charts to LionDesk Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to LionDesk from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Visualize Live Cosmos DB Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Azure Cosmos DB.
-
Integrate Live Asana Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Asana to Blue Prism using the CData ODBC Driver for Asana to create automated workflows for repetitive business tasks.
-
Connect to Facebook Ads Data in Jaspersoft Studio
Execute SQL to remote Facebook Ads in Jaspersoft Studio.
-
How to import Toggl Data into Apache Solr
Use the CData Software JDBC Driver for Toggl in Data Import Handler and create an automated import of Toggl to Apache Solr Enterprise Search platform.
-
How to connect to GetResponse Data from IntelliJ
Integrate connectivity to GetResponse with wizards in IntelliJ.
-
Connect to PhantomBuster Data in JRuby
Create a simple JRuby app with access to live PhantomBuster.
-
Edit and Search External Basecamp Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Basecamp to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Basecamp Data objects that you can access from apps and the dashboard.
-
Visualize Live Microsoft OneDrive Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Microsoft OneDrive into custom reports in Power BI.
-
Access Live Missive Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Missive in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Consume Shopify OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Shopify feeds that reflect any changes in SAP Lumira.
-
Getting Started with the CData ODBC Driver for Harvest
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Harvest.
-
Visualize Recurly 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 Recurly into TIBCO Spotfire.
-
Use the CData Software JDBC Driver for HubSpot in MicroStrategy Web
Connect to HubSpot in MicroStrategy Web using the CData Software JDBC Driver for HubSpot.
-
Automated Continuous Hive Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Hive replication to Amazon S3.
-
Use the CData Software ODBC Driver for Klaviyo in MicroStrategy
Connect to Klaviyo in MicroStrategy Developer using the CData Software ODBC Driver for Klaviyo.
-
Analyze Jira Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Jira from Power Pivot. You will use the Table Import Wizard to load Atlassian Jira. You can visually build the import query or use any SQL supported by the driver.
-
Manage Raisers Edge NXT Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Raisers Edge NXT.
-
Enable the Wrike JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Wrike.
-
How to Connect the Power BI Service to Twilio: Complete Guide
Connect to the CData Software Power BI Connector for Twilio from PowerBI.com to provide real-time Twilio across the organization.
-
Use Microsoft Copilot Studio to talk to your Spark Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Apache Spark SQL for you.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Microsoft Office 365 to Power BI dashboards. Simply drag and drop Microsoft Office 365 into data visuals on the Power BI canvas.
-
Migrating data from Discourse to Snowflake using CData SSIS Components.
Easily push Discourse to Snowflake using the CData SSIS Tasks for Discourse and Snowflake.
-
Use the CData Software JDBC Driver for CloudConvert in MicroStrategy Desktop
Connect to CloudConvert in MicroStrategy Desktop using the CData Software JDBC Driver for CloudConvert.
-
Visualize Copper 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 Copper into TIBCO Spotfire.