CData Software - Knowledge Base
Recent Articles
-
Import Real-Time Office 365 Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Microsoft Office 365 in ColdFusion.
-
Connect Sybase IQ to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Sybase IQ with IBM WebSphere for seamless data integration and connectivity.
-
How to integrate Box with Apache Airflow
Access and process Box in Apache Airflow using the CData JDBC Driver.
-
How to Connect to Live Adobe Analytics 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 Adobe Analytics for you.
-
Perform Batch Operations with Cloudant Data in Apache NiFi
Connect to IBM Cloudant and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Working with SAP SuccessFactors LMS Data in LINQPad
Execute LINQ queries to SAP SuccessFactors LMS in LINQPad.
-
Integrating Boomi Agentstudio with GraphQL Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to GraphQL, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Use the CData Software ODBC Driver for Zoho Books in MicroStrategy
Connect to Zoho Books in MicroStrategy Developer using the CData Software ODBC Driver for Zoho Books.
-
Query AgileCRM Data through ODBC in Node.js
Use node-odbc to execute SQL queries against AgileCRM from Node.js.
-
Connect to Beeminder Data in RazorSQL
Connect to Beeminder from wizards and query Beeminder from the GUI in the RazorSQL database management tool.
-
Build an OLAP Cube in SSAS from Mailgun Data
Establish a connection to Mailgun data from SQL Server Analysis Services, and use the Mailgun Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to Epicor Kinetic Data in CloverDX (formerly CloverETL)
Transfer Epicor Kinetic using the visual workflow in the CloverDX data integration tool.
-
Automated Continuous CapsuleCRM Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable CapsuleCRM replication to delimited files (CSV/TSV).
-
Analyze Helpscout Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Helpscout in Microsoft R Open.
-
Access Live Omnisend Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Omnisend into the statistical analysis tools available in SAS JMP. This article shows how to use Omnisend in the Graph Builder and Query Builder.
-
Replicate Delighted Data in Heroku for Use in Salesforce Connect
Replicate Delighted to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Build Semantic Layer Views for Landbot Data in APOS Live Data Gateway
Use the CData Connector for Landbot in APOS Live Data Gateway to build Semantic Layer Views for Landbot.
-
Visualize Live Epicor Kinetic Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Epicor Kinetic.
-
Bridge Facebook Ads Connectivity with Apache NiFi
Access and process Facebook Ads in Apache NiFi using the CData JDBC Driver.
-
Analyze Wave Financial Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Wave Financial in Microsoft R Open.
-
How to Connect to Outlook Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Outlook. Leverage the pyodbc module for ODBC in Python.
-
Connect to Zoho Inventory Data from a Connection Pool in JBoss
Integrate Zoho Inventory into Java servlets: Use the Management Console in JBoss to install the Zoho Inventory JDBC Driver.
-
Create Confluence-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Confluence Data from Klipfolio and build custom visualizations using live Atlassian Confluence.
-
Use the CData Software JDBC Driver for ServiceDesk Plus in MicroStrategy Desktop
Connect to ServiceDesk Plus in MicroStrategy Desktop using the CData Software JDBC Driver for ServiceDesk Plus.
-
How to load SAP Business Warehouse data into Elasticsearch via Logstash
Introducing a simple method to load SAP Business Warehouse data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to Invoiced Data in DBArtisan
Use wizards in DBArtisan to configure Invoiced as a data source.
-
Load Keap Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Keap to a database.
-
Moving Data from SendGrid to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live SendGrid data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
A PostgreSQL Interface for Datadog Data (MySQL Remoting via JDBC)
Use the Remoting features of the Datadog JDBC Driver to create a PostgreSQL entry-point for data access.
-
Analyze Zoho Projects Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Zoho Projects and visualize live Zoho Projects in Infragistics Reveal.
-
How to work with Guru Data in Apache Spark using SQL
Access and process Guru Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to Autopilot Data in DBArtisan
Use wizards in DBArtisan to configure Autopilot as a data source.
-
Connect FreeAgent to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect FreeAgent with IBM WebSphere for seamless data integration and connectivity.
-
How to use SQLAlchemy ORM to access Smartsheet Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Smartsheet.
-
Configure the CData JDBC Driver for TigerGraph in a Connection Pool in Tomcat
Connect to TigerGraph from a connection pool in Tomcat.
-
Automate Acumatica Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Acumatica ERP from PowerShell? This article demonstrates how to utilize the Acumatica Cmdlets for tasks like connecting to Acumatica ERP, automating operations, downloading data, and more.
-
Bridge Dotmailer Connectivity with Apache NiFi
Access and process Dotmailer in Apache NiFi using the CData JDBC Driver.
-
How to Work with Mistral AI Data in AWS Glue Jobs Using JDBC
Connect to Mistral AI from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to JotForm Data in RapidMiner
Integrate JotForm with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to Zoho Inventory Data in Ruby
Connect to Zoho Inventory in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to Twitter Ads Data from a Connection Pool in JBoss
Integrate Twitter Ads into Java servlets: Use the Management Console in JBoss to install the Twitter Ads JDBC Driver.
-
Use the CData ODBC Driver for Dynamics 365 Business Central from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Dynamics 365 Business Central to connect to Dynamics 365 Business Central from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Dynamics 365 Business Central in Excel.
-
Integrate Live Freshservice Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Freshservice to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Configure the CData JDBC Driver for Planio in a Connection Pool in Tomcat
Connect to Planio from a connection pool in Tomcat.
-
Query MariaDB Data from Node.js
Use the OData endpoint of the CData API Server to connect to your MariaDB and perform CRUD operations on MariaDB from Node.js.
-
Migrating data from GitHub to Google BigQuery using CData SSIS Components.
Easily push GitHub to Google BigQuery using the CData SSIS Tasks for GitHub and Google BigQuery.
-
Use the CData Software JDBC Driver for MailChimp in MicroStrategy Desktop
Connect to MailChimp in MicroStrategy Desktop using the CData Software JDBC Driver for MailChimp.
-
How to connect SharePoint with Sugar CRM Data through external lists
Provide Sugar CRM to SharePoint users as an external list.
-
Integrating Cursor CLI with Google Ad Manager 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.
-
A PostgreSQL Interface for Sentry Data using the CData ODBC Driver
Use the SQL Gateway and Sentry ODBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData ODBC Driver for Helpscout from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Helpscout to connect to Helpscout from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Helpscout in Excel.
-
Create Dashboards and Visualize Live Microsoft Exchange Data in Geckoboard
Use CData Connect AI to connect to live Microsoft Exchange and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Build an OLAP Cube in SSAS from Bitly Data
Establish a connection to Bitly data from SQL Server Analysis Services, and use the Bitly Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to work with Oracle Eloqua Data in Apache Spark using SQL
Access and process Oracle Eloqua Data in Apache Spark using the CData Software JDBC Driver.
-
Provide OData Services of Close Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Close by developing a WCF Service Application.
-
Use the CData Software ODBC Driver for MySQL in MicroStrategy
Connect to MySQL in MicroStrategy Developer using the CData Software ODBC Driver for MySQL.
-
Build Apps with Live Marketo Data Using the Low-Code Development Platform of Mendix
Connect Marketo with Mendix to build apps using the CData JDBC Driver for Marketo.
-
Connect to Harvest Data in Aqua Data Studio
Access Harvest from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Automated Continuous QuickBooks Time Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable QuickBooks Time replication to OneLake in Microsoft Fabric.
-
Automated Continuous Insightly Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Insightly replication to delimited files (CSV/TSV).
-
Integrating Claude Code CLI with Kafka 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.
-
Visualize WordPress Data in TIBCO Spotfire through OData
Integrate WordPress into dashboards in TIBCO Spotfire.
-
Build Charts with Salesforce Data in Clear Analytics
Create dynamic charts and perform analytics based on Salesforce & Force.com in Clear Analytics.
-
Getting Started with the CData ODBC Driver for ConvertKit
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for ConvertKit.
-
How to Import Data from Smartsheet into Google Sheets
Import Smartsheet into a Google spreadsheet that is automatically refreshed.
-
Getting Started with the CData Excel Add-In for ShipStation
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for ShipStation.
-
Easily Integrate SendGrid Data in Lazarus Pascal IDE
Learn how to easily integrate live SendGrid in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Visualize Zoho Inventory Data in Tableau
The CData ODBC driver for Zoho Inventory enables you integrate Zoho Inventory into Tableau dashboards.
-
Getting Started with the CData Power BI Connector for Cvent
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Cvent.
-
Connect to Live Apollo Data in MicroStrategy through CData Connect AI
Create a live connection to Apollo Data in CData Connect AI and connect to your Apollo from MicroStrategy.
-
Prepare, Blend, and Analyze Azure Data Lake Storage Data in Alteryx Designer (ODBC)
Build workflows to access live Azure Data Lake Storage for self-service data analytics.
-
Build SAP Business One-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for SAP Business One Data and create custom apps in Mendix.
-
How to Seamlessly Import Zoho Creator Data into IBM SPSS Modeler
Integrate Zoho Creator data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build Charts with Datadog Data in Clear Analytics
Create dynamic charts and perform analytics based on Datadog in Clear Analytics.
-
Build Twitter Ads Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Twitter Ads and build visualizations in Tableau.
-
Connect to Perplexity Data in Jaspersoft Studio
Execute SQL to remote Perplexity in Jaspersoft Studio.
-
Easily Integrate Paddle Data in Lazarus Pascal IDE
Learn how to easily integrate live Paddle in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Automated Continuous Adobe Target Replication to SingleStore
Use CData Sync for automated, continuous, customizable Adobe Target replication to SingleStore.
-
Integrating OpenCode Terminal with Adobe Target 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 Google Ad Manager from a Connection Pool in WebLogic
Use the CData JDBC Driver for Google Ad Manager to connect to Google Ad Manager from Web applications running on WebLogic.
-
Build SAP BusinessObjects BI-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for SAP BusinessObjects BI to explore live SAP BusinessObjects BI Data in Gemini Code Assist to assist with building SAP BusinessObjects BI-powered applications.
-
Stream Google Cloud Storage Data into Apache Kafka Topics
Access and stream Google Cloud Storage in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Build Klaviyo-Connected Apps in Choreo
Use CData Connect AI to connect to Klaviyo Data from Choreo and build custom apps using live Klaviyo.
-
Connect to Bugsnag Data from PowerBuilder via ADO.NET
This article demonstrates how to access Bugsnag from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Connect to Reckon Accounts Hosted Data in Ruby
Connect to Reckon Accounts Hosted in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Access Live Vertica Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Vertica from your Excel spreadsheets.
-
Connect to Microsoft OneDrive Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Excel Spreadsheet Automation on Cloudflare Data with the QUERY Formula
Pull data from Cloudflare, automate spreadsheets, and more with the QUERY formula.
-
Using the CData Software ODBC Driver for PDFMonkey in PyCharm
Connect to PDFMonkey as an ODBC data source in PyCharm using the CData Software ODBC Driver for PDFMonkey.
-
How to Connect to & Open SAP Business One Data in Microsoft Excel
This article uses the CData ODBC driver for SAP Business One to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Extract, Transform, and Load CapsuleCRM Data in Informatica PowerCenter
Create a simple Workflow for CapsuleCRM in Informatica PowerCenter.
-
Consume Phoenix OData Feeds in PowerBuilder
This article demonstrates how to consume Apache Phoenix as OData feeds from PowerBuilder using the API Server.
-
Create Exact Online-Connected Nintex Workflows
Use CData Connect AI to connect to Exact Online Data from Nintex Workflow Cloud and build custom workflows using live Exact Online.
-
Create Apps from QuickBooks Online Data in Qlik Sense Cloud
Use CData Connect AI to connect to QuickBooks Online Data and build apps from live QuickBooks Online in Qlik Sense Cloud.
-
Query Stripe Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Stripe entities in PHP by modeling them as objects.
-
How to Visualize Oracle Eloqua Reporting Data in Python with pandas
Use pandas and other modules to analyze and visualize live Oracle Eloqua Reporting in Python.
-
How to Visualize MailerSend Data in Python with pandas
Use pandas and other modules to analyze and visualize live MailerSend in Python.
-
Connect to Xero Data in CloverDX (formerly CloverETL)
Transfer Xero Accounting using the visual workflow in the CloverDX data integration tool.
-
Connect to Acumatica Data in HULFT Integrate
Connect to Acumatica as a JDBC data source in HULFT Integrate
-
Automated Continuous MYOB AccountRight Replication to MySQL
Use CData Sync for automated, continuous, customizable MYOB AccountRight replication to MySQL.