CData Software - Knowledge Base
Recent Articles
-
Migrating data from HDFS to Databricks using CData SSIS Components.
Easily push Apache HDFS to Databricks using the CData SSIS Tasks for HDFS and Databricks.
-
Build Voice Agents in ElevenLabs with access to Live NetSuite SuiteAnalytics Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live NetSuite SuiteAnalytics.
-
Connect to BigQuery Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Google BigQuery in Airbyte.
-
Integrating Kiro CLI with Scrapfly 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.
-
Bridge Outreach.io Connectivity with Apache NiFi
Access and process Outreach.io in Apache NiFi using the CData JDBC Driver.
-
Connect to Eventbrite Data in JRuby
Create a simple JRuby app with access to live Eventbrite.
-
Access ShipEngine Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live ShipEngine from HeidiSQL.
-
Automated Continuous Freshsales Replication to Databricks
Use CData Sync for automated, continuous, customizable Freshsales replication to Databricks.
-
Query Procore Data as a SQL Server Database in Node.js
Execute SQL Server queries against Procore from Node.js.
-
Natively Connect to Rebilly Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Rebilly. Leverage the native support for ODBC in PHP.
-
How to load Sage 300 data into Elasticsearch via Logstash
Introducing a simple method to load Sage 300 data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Replicate Multiple PagerDuty Accounts via the CData Sync CLI
Replicate multiple PagerDuty accounts to one or many databases.
-
Automated Continuous ZohoDesk Replication to Snowflake
Use CData Sync for automated, continuous, customizable ZohoDesk replication to Snowflake.
-
How to Query Live Reckon Data in Claude Desktop
Connect to and query live Reckon Data in Claude Desktop using CData MCP Server.
-
Automate SharePoint Data Replication to SAP HANA
Use CData Sync to customize and automate Microsoft SharePoint replication to SAP HANA.
-
Integrating LlamaIndex with GitHub Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on GitHub in real time.
-
Connect and Visualize Live JSON Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live JSON into the Databricks platform and create visualization dashboards with real-time JSON.
-
Replicate Google Drive Data from PowerShell
Write a quick PowerShell script to query Google Drive. Use connectivity to the live data to replicate Google Drive to SQL Server.
-
Query ScrapingBee Data through ODBC in Node.js
Use node-odbc to execute SQL queries against ScrapingBee from Node.js.
-
Connect to ServiceDesk Plus Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for ServiceDesk Plus and the SQL Gateway to access ServiceDesk Plus from Google Apps Script.
-
How to connect to Pinecone Data in DBVisualizer
Integrate Pinecone with visual data analysis tools and data connection wizards in DBVisualizer
-
Analyze Xero Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Xero Accounting and visualize Xero Accounting in SAP Analytics Cloud.
-
Replicate SageHR Data to Multiple Databases
Replicate SageHR to disparate databases with a point-and-click configuration.
-
DataBind Controls to Salesloft Data in C++Builder
DataBind to Salesloft in C++Builder with standard components and controls.
-
Replicate Multiple Wistia Accounts via the CData Sync CLI
Replicate multiple Wistia accounts to one or many databases.
-
Query Jira Assets Data as a MySQL Database in Node.js
Execute MySQL queries against Jira Assets from Node.js.
-
How to connect to Rootly Data with Squirrel SQL client
Connect to Rootly and execute queries in the Squirrel SQL Client.
-
Access Live Redshift Data in AWS Lambda
Connect to live Amazon Redshift in AWS Lambda using the CData JDBC Driver.
-
Automated Continuous Zoho Inventory Replication to SQLite
Use CData Sync for automated, continuous, customizable Zoho Inventory replication to SQLite.
-
Automate Odoo Data Replication to Couchbase
Use CData Sync to Customize and automate Odoo ERP replication to Couchbase.
-
How to Visualize Rootly Data in Python with pandas
Use pandas and other modules to analyze and visualize live Rootly in Python.
-
Query Live PayPal 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 PayPal directly from the development environment.
-
Connecting GenSpark with GitLab Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to GitLab without any replication or custom integration required.
-
Build Dashboards with Couchbase Data in DBxtra
Create dynamic dashboards and perform analytics based on Couchbase in DBxtra.
-
Transfer Google Contacts to Dynamics CRM
Never manually copy your Google contacts into CRM again! With the CData SSIS components, you can automatically synchronize Dynamics CRM with your customer and lead information no matter where it resides, without manually copying data.
-
Connect to OData Services in ACL Analytics
Connect to OData via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to OData.
-
Connect to Shopify Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Shopify.
-
Use the CData Software ODBC Driver for ServiceDesk Plus in MicroStrategy
Connect to ServiceDesk Plus in MicroStrategy Developer using the CData Software ODBC Driver for ServiceDesk Plus.
-
How to update SendGrid from Excel
This article explains how to transfer data from Excel to SendGrid using the Excel Add-In for SendGrid.
-
How to Connect Pipedrive 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 Pipedrive data in real time using natural language.
-
Consume SurveyMonkey OData Feeds in PowerBuilder
This article demonstrates how to consume SurveyMonkey as OData feeds from PowerBuilder using the API Server.
-
Bridge Mixpanel Connectivity with Apache NiFi
Access and process Mixpanel in Apache NiFi using the CData JDBC Driver.
-
Automated Continuous Dynamics 365 Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Microsoft Dynamics 365 replication to OneLake in Microsoft Fabric.
-
Building Dynamic Web Pages with Jira Data Using AngularJS
Create single-page applications with live connectivity to Jira using the CData API Server.
-
DataBind Controls to Harvest Data in Delphi
DataBind to Harvest in Delphi with standard data access components and controls.
-
Build a PostgreSQL Interface for Access Data using the CData JDBC Driver
Use the Remoting features of the Access JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Chargebee Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Chargebee replication to Azure SQL Database.
-
Import and Visualize PostgreSQL Data in Power View
Create data visualizations based on PostgreSQL in Excel.
-
Automated Continuous Perplexity Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Perplexity replication to PostgreSQL.
-
Integrating GitHub Copilot CLI with Codat 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 Azure Table Data from HeidiSQL
Use CData Connect AI to connect to and query live Azure Table Storage from HeidiSQL.
-
Integrating Claude Code CLI with FHIR 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.
-
Build a Simple VCL Application for Sage 200 Data
How to build a simple VCL Application to view Sage 200 in RAD Studio using the CData ODBC Driver for Sage 200.
-
Analyze Oracle Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Oracle Database in Microsoft R Open.
-
How to work with IBM Cloud Object Storage Data in Apache Spark using SQL
Access and process IBM Cloud Object Storage Data in Apache Spark using the CData Software JDBC Driver.
-
Create Power BI Reports on Real-Time Shippo Data
Use the CData ODBC Driver for Shippo to visualize Shippo in Power BI Desktop.
-
Connect to SAP Ariba Source Data in DBeaver
Use the CData ODBC Driver to connect to SAP Ariba Source in DBeaver.
-
Create Power BI Reports on Real-Time DocuSign Data
Use the CData ODBC Driver for DocuSign to visualize DocuSign in Power BI Desktop.
-
Connect to ChargeOver Data in JRuby
Create a simple JRuby app with access to live ChargeOver.
-
Write a Simple Go Application to work with SAS xpt Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SAS XPORT.
-
How to Visualize CockroachDB 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 CockroachDB in Python.
-
Provide OData Services of Yelp Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Yelp by developing a WCF Service Application.
-
Connect to and Visualize Live Snapchat Ads Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Snapchat Ads.
-
Create Informatica Mappings From/To an ODBC Data Source for Microsoft Planner
Create an ODBC connection to Microsoft Planner in Informatica and browse and transfer Microsoft Planner.
-
Connect to Salesforce Data 360 Data from a Connection Pool in Jetty
The Salesforce Data 360 JDBC Driver supports connection pooling: This article shows how to connect faster to Salesforce Data 360 from Web apps in Jetty.
-
Use the CData Software JDBC Driver for QuickBooks in MicroStrategy Desktop
Connect to QuickBooks Desktop in MicroStrategy Desktop using the CData Software JDBC Driver for QuickBooks.
-
Getting Started with the CData Python Connector for Sage Intacct
Learn to install and license the CData Python Connector
-
Build Agents in Relevance AI with Access to Live Zoho Books Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Zoho Books within intelligent agent workflows.
-
Natively Connect to PagerDuty Data in PHP
The CData ODBC driver for PagerDuty enables you to create PHP applications with connectivity to PagerDuty. Leverage the native support for ODBC in PHP.
-
DataBind Controls to Google Spanner Data in C++Builder
DataBind to Google Spanner in C++Builder with standard components and controls.
-
How to Connect the Power BI Service to BigCommerce: Complete Guide
Connect to the CData Software Power BI Connector for BigCommerce from PowerBI.com to provide real-time BigCommerce across the organization.
-
Build MVC Applications with Connectivity to Paylocity Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Paylocity from an ASP.NET MVC application.
-
Automated Continuous SAP SuccessFactors Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable SAP SuccessFactors replication to PostgreSQL.
-
Build a PostgreSQL Interface for Klipfolio Data using the CData JDBC Driver
Use the Remoting features of the Klipfolio JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData Software JDBC Driver for Onfleet in MicroStrategy Web
Connect to Onfleet in MicroStrategy Web using the CData Software JDBC Driver for Onfleet.
-
Create Couchbase-Connected Dashboards in Grafana
Connect to Couchbase Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Couchbase.
-
Access ServiceDesk Plus 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 ServiceDesk Plus.
-
Pipeliner CRM Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Pipeliner CRM facts in real time.
-
Connect to Google Contacts Data in CloverDX (formerly CloverETL)
Transfer Google Contacts using the visual workflow in the CloverDX data integration tool.
-
Choosing the Best Method to Connect Greenplum to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Pivotal GreenPlum from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Use Databricks Agent Bricks to Talk to Your NetSuite Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your NetSuite CRM & ERP for you.
-
Build AI/ML Models with Live Google Ads Data using Dataiku
Connect Google Ads Data with Dataiku using the CData JDBC Driver for Google Ads.
-
Access Foursquare Data from MySQL in Amazon QuickSight
Connect to Foursquare and build visualizations of Foursquare using a MySQL Connection in Amazon QuickSight.
-
Connect to DB2 Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for IBM DB2 in Airbyte.
-
Use JayDeBeApi to access LDAP Objects in Python
Use standard Python scripting and the development environment of your choice to access live LDAP.
-
ETL Email in Oracle Data Integrator
This article shows how to transfer Email into a data warehouse using Oracle Data Integrator.
-
Getting Started with the CData Python Connector for Cloudant
Learn to install and license the CData Python Connector
-
Integrate Live SAP ByDesign Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Automated Continuous SAP Business One Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable SAP Business One replication to Apache Cassandra.
-
Connect to HCL Domino Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time HCL Domino using standard SQL.
-
DataBind Controls to PabblySubscriptions Data in Delphi
DataBind to PabblySubscriptions in Delphi with standard data access components and controls.
-
Freshteam Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Freshteam facts in real time.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Avalara AvaTax within intelligent workflows.
-
Use Grok to Talk to Your Facebook 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 Facebook for you.
-
Feed Reckon Accounts Hosted Data into FineReport
How to set Reckon Accounts Hosted as a JDBC data source in FineReport.
-
Integrate with Email Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Email to a JSON file on disk.
-
Connect to Todoist Data in DBArtisan
Use wizards in DBArtisan to configure Todoist as a data source.
-
Validate Zoho Creator Data with QuerySurge
Access and validate Zoho Creator in QuerySurge using the CData JDBC Driver.
-
Integrate Cursor with Live MongoDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live MongoDB from within the editor.
-
Use the CData ODBC Driver for ServiceDesk Plus in Microsoft Power Query
You can use the CData ServiceDesk Plus ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import ServiceDesk Plus into Microsoft Power Query.