CData Software - Knowledge Base
Recent Articles
-
Connect to Deel in SpagoBI
Create reports featuring live Deel data in SpagoBI Studio. Host Deel reports on SpagoBI Server.
-
Automated Continuous Instagram Replication to SQL Server
Use CData Sync for automated, continuous, customizable Instagram replication to SQL Server.
-
Use the CData Software ODBC Driver for Coda in MicroStrategy Web
Connect to Coda data in MicroStrategy Web using the CData Software ODBC Driver for Coda.
-
Connect to Google Contacts Data in NetBeans
Connect to Google Contacts data in NetBeans with the data source configuration wizard.
-
Automated Continuous DocuSign Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable DocuSign replication to delimited files (CSV/TSV).
-
Automated Continuous Retently Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Retently replication to Google Cloud SQL.
-
Automated Continuous VWO Replication to IBM DB2
Use CData Sync for automated, continuous, customizable VWO replication to IBM DB2.
-
DataBind Charts to SharePoint Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to SharePoint data 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.
-
Integrate with Sugar CRM Data in JReport Designer
Create charts and reports based on Sugar CRM data in JReport Designer.
-
Integrate Devin with Live DocuSign Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live DocuSign data.
-
How to Connect to & Open Microsoft Planner Data in Microsoft Excel
This article uses the CData ODBC driver for Microsoft Planner to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
LINQ to Jira Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Jira Data Provider.
-
Access Cvent 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 Cvent data.
-
Integrate Devin with Live Bannerbear Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Bannerbear data.
-
Automated Continuous LaunchDarkly Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable LaunchDarkly replication to Azure SQL Database.
-
Build a Singer.io Tap for Customer.io With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Customer.io data using the CData Python Connector.
-
Feed Freshservice Data into FineReport
How to set Freshservice data as a JDBC data source in FineReport.
-
Automated Continuous Klipfolio Replication to MySQL
Use CData Sync for automated, continuous, customizable Klipfolio replication to MySQL.
-
Integrate Trello with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Trello with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Trello data.
-
Use the CData Software ODBC Driver for MySQL in SAS for Real-Time Reporting and Analytics
Connect to real-time MySQL data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for MySQL.
-
Validate Bullhorn CRM Data with QuerySurge
Access and validate Bullhorn CRM data in QuerySurge using the CData JDBC Driver.
-
How to connect Amazon QuickSight to Elasticsearch Data
Create a connection to Elasticsearch data in CData Connect AI and insert Elasticsearch data into Amazon QuickSight SPICE to build interactive dashboards.
-
Getting Started with the CData Python Connector for TaxJar
Learn to install and license the CData Python Connector and configure a connection to live TaxJar data.
-
Use Dash to Build to Web Apps on Databricks Data
Create Python applications that use pandas and Dash to build Databricks-connected web apps.
-
Integrate Live Cvent Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Cvent data and integrate live Cvent data into apps built in Microsoft Power Apps.
-
Connect to Drip Data in Ruby
Connect to Drip data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automated Continuous HDFS Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable HDFS replication to Amazon Redshift.
-
Connect to Azure Synapse Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Azure Synapse Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Integrate BambooHR Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live BambooHR data from Informatica Cloud.
-
How to Access Live Aweber Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Aweber enables you to integrate Aweber data into workflows built using Microsoft Power Automate Desktop.
-
Analyze MailChimp Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of MailChimp data and visualize live MailChimp data in Infragistics Reveal.
-
Integrate Goose with Live Optimizely Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Optimizely data from within the local AI agent.
-
Write a Simple Go Application to work with Zoho Creator Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Zoho Creator data.
-
Analyze Marketo Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Marketo data and visualize live Marketo data in Infragistics Reveal.
-
View Reports on Real-Time Perigon Data in Power BI Report Server
Use the CData ODBC Driver for Perigon to visualize Perigon data in Power BI Desktop and then publish them to Power BI Report Server.
-
How to Seamlessly Import Rootly Data into IBM SPSS Modeler
Integrate Rootly data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Integrate with live IBM Cloud Object Storage Data in Jitterbit
Use CData Connect AI to connect to and integrate live IBM Cloud Object Storage data in Jitterbit.
-
Use Biml to Build SSIS Tasks to Replicate Recurly Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Recurly data to SQL Server.
-
Use the CData Software ODBC Driver for Timely in MicroStrategy Desktop
Connect to Timely data in MicroStrategy Desktop using the CData Software ODBC Driver for Timely.
-
Automated Continuous Mocean Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Mocean replication to Google Cloud SQL.
-
Prepare, Blend, and Analyze ClickUp Data in Alteryx Designer (ODBC)
Build workflows to access live ClickUp data for self-service data analytics.
-
Access Live Dynamics CRM Data in Coginiti Pro
Connect to and query live Dynamics CRM data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to PDFMonkey in SpagoBI
Create reports featuring live PDFMonkey data in SpagoBI Studio. Host PDFMonkey reports on SpagoBI Server.
-
Access Live HubDB Data in Excel 365 Online (Excel for the web)
Connect to HubDB data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Connect to Anaplan Data in ACL Analytics
Connect to Anaplan data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Anaplan data.
-
Integrate Salesforce Data into Power Automate Desktop using CData Connect
CData Connect for Salesforce Data enables you to integrate Salesforce data into workflows built using Microsoft Power Automate Desktop.
-
Consume MongoDB OData Feeds in PowerBuilder
This article demonstrates how to consume MongoDB data as OData feeds from PowerBuilder using the API Server.
-
Integrate Kafka Data in Pentaho Data Integration
Build ETL pipelines based on Kafka data in the Pentaho Data Integration tool.
-
Analyze SAP Fieldglass Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of SAP Fieldglass data and visualize live SAP Fieldglass data in Infragistics Reveal.
-
Build Dashboards with ZohoSubscriptions Data in DBxtra
Create dynamic dashboards and perform analytics based on ZohoSubscriptions data in DBxtra.
-
Getting Started with the CData ODBC Driver for Avalara AvaTax
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Avalara AvaTax.
-
Replicate Multiple SAP Accounts via the CData Sync CLI
Replicate multiple SAP accounts to one or many databases.
-
Working with Mailgun Data in LINQPad
Execute LINQ queries to Mailgun data in LINQPad.
-
How to load Instantly data into Elasticsearch via Logstash
Introducing a simple method to load Instantly data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Automated Continuous XML Replication to Oracle
Use CData Sync for automated, continuous, customizable XML replication to Oracle.
-
Natively Connect to eBay Data in PHP
The CData ODBC driver for eBay enables you to create PHP applications with connectivity to eBay data. Leverage the native support for ODBC in PHP.
-
Query Kafka Data in ColdFusion
Write standard ColdFusion data access code to connect to Kafka data.
-
Integrating Claude Code with Reckon Accounts Hosted Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Reckon Accounts Hosted data within assisted coding and automated development workflows.
-
Integrate Printify with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Printify with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Printify data.
-
Connect to and Visualize Live SAP Ariba Source Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live SAP Ariba Source data.
-
Bind Live Oracle Eloqua Reporting Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Oracle Eloqua Reporting data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
DataBind Charts to Mixpanel Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Mixpanel data 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.
-
Automated Continuous NetSuite Replication to SQLite
Use CData Sync for automated, continuous, customizable NetSuite replication to SQLite.
-
Access Live CockroachDB Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live CockroachDB data from your Google Sheets.
-
Connect to and Query Email Data in QlikView over ODBC
Create data visualizations with Email data in QlikView.
-
Connect to Redshift Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Redshift Data and connect to Redshift data in Akorbi Digital RunMyProcess.
-
Automated Continuous Amazon Marketplace Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Amazon Marketplace data replication to OneLake in Microsoft Fabric.
-
Access Live Mode 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 Mode data through MCP integration.
-
Connect DB2 Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your DB2 data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Getting Started with the CData JDBC Driver for Attio
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Attio.
-
Moving Data from Parquet to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Parquet data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to Visualize Cloudflare Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Cloudflare data in Python.
-
Import Real-Time SendInBlue Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use SendInBlue data in ColdFusion.
-
Getting Started with the CData Power BI Connector for Rootly
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Use the CData Software JDBC Driver for Stripe in MicroStrategy Desktop
Connect to Stripe data in MicroStrategy Desktop using the CData Software JDBC Driver for Stripe.
-
How to integrate Metabase with ClickUp Data
Use CData Connect AI to connect to live ClickUp data and create an interactive dashboard in Metabase from ClickUp data.
-
Automated Continuous Microsoft Planner Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Microsoft Planner replication to Google BigQuery.
-
Integrate Exa with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Exa with External Services.
-
Analyze Salesloft Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Salesloft data with the CData JDBC Driver for Salesloft.
-
Query CSV Data in ColdFusion
Write standard ColdFusion data access code to connect to CSV data.
-
Build Data Flows from AgileCRM to SQL Server using SSIS
Easily back up AgileCRM data to SQL Server using the SSIS components for AgileCRM.
-
Build Testmonitor-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Testmonitor data.
-
Integrate Cline with Live Egnyte Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Egnyte data from within your IDE.
-
Migrating data from BambooHR to Snowflake using CData SSIS Components.
Easily push BambooHR data to Snowflake using the CData SSIS Tasks for BambooHR and Snowflake.
-
View Reports on Real-Time Adobe Analytics Data in Power BI Report Server
Use the CData ODBC Driver for Adobe Analytics to visualize Adobe Analytics data in Power BI Desktop and then publish them to Power BI Report Server.
-
How to use SQLAlchemy ORM to access JSON Services in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of JSON services.
-
Connect to Sugar CRM Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Sugar CRM data from Filemaker Pro on Mac.
-
Build Zendesk-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Zendesk data and build Zendesk-connected web apps with Axios.
-
How to Connect to Live Exa Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Exa data through natural language.
-
Validate NetSuite Data with QuerySurge
Access and validate NetSuite data in QuerySurge using the CData JDBC Driver.
-
Comparing Insert Methods in BigQuery: Streaming, DML, and Bulk Loading with the CData BigQuery Driver
Learn how to choose the best insert method for Google BigQuery—Streaming, DML, or Bulk Loading—using the CData BigQuery Driver. Improve your data integration and ETL workflows with optimized strategies.
-
Connecting Mastra with Tally Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Tally data, no replication required.
-
Connect to and Visualize Live Productboard Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Productboard data.
-
How to Connect OneNote Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live OneNote data in real time using natural language.
-
Build Dashboards with ServiceNow Data in Dundas BI
Create dynamic dashboards and perform analytics based on ServiceNow data in Dundas BI.
-
How to Visualize Airtable Data in Python with pandas
Use pandas and other modules to analyze and visualize live Airtable data in Python.
-
Publish Crystal Reports on IBM Informix Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date IBM Informix data.
-
Work with Live Blackbaud FE NXT Data in Power Query
Use CData Connect AI to connect to Blackbaud FE NXT data and work with live Blackbaud FE NXT data in Microsoft Power Query.
-
Integrating Claude Code with ZohoMarketingHub Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on ZohoMarketingHub data within assisted coding and automated development workflows.
-
Migrating data from QuickBooks Online to Databricks using CData SSIS Components.
Easily push QuickBooks Online data to Databricks using the CData SSIS Tasks for QuickBooks Online and Databricks.