CData Software - Knowledge Base
Recent Articles
-
Create DocuSign Dataflows on PowerBI.com
Connect to the CData Power BI Connector for DocuSign from PowerBI.com to create Power BI Dataflows with real-time data.
-
Create Apps from Oracle HCM Cloud Data in Qlik Sense Cloud
Use CData Connect AI to connect to Oracle HCM Cloud Data and build apps from live Oracle HCM Cloud in Qlik Sense Cloud.
-
Automate ZarMoney Data Replication to Azure Data Lake
Use CData Sync to customize and automate ZarMoney replication to Azure Data Lake.
-
Access Live Bright Data Data in Coginiti Pro
Connect to and query live Bright Data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Access Live Act-On Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Act-On through MCP integration.
-
Connect to Oracle Eloqua Data in Ruby
Connect to Oracle Eloqua in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Create a Data Access Object for BigCommerce Data using JDBI
A brief overview of creating a SQL Object API for BigCommerce in JDBI.
-
Query Paymo Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Paymo from Node.js.
-
Build MVC Applications with Connectivity to Sendwithus Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Sendwithus from an ASP.NET MVC application.
-
Publish Crystal Reports on Datadog Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Datadog.
-
Using the CData Software ODBC Driver for Dotmailer in PyCharm
Connect to Dotmailer as an ODBC data source in PyCharm using the CData Software ODBC Driver for Dotmailer.
-
Analyze Greenplum Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Pivotal GreenPlum and visualize Pivotal GreenPlum in SAP Analytics Cloud.
-
Analyze JotForm Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze JotForm in Microsoft R Open.
-
Automated Continuous Drip Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Drip replication to Apache Cassandra.
-
Build MVC Applications with Connectivity to LinkedIn Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access LinkedIn from an ASP.NET MVC application.
-
FormSite Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on FormSite facts in real time.
-
Use Biml to Build SSIS Tasks to Replicate eBay Analytics Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate eBay Analytics to SQL Server.
-
Integrate Printful with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Printful with External Services.
-
How to work with ZendeskSell Data in Apache Spark using SQL
Access and process ZendeskSell Data in Apache Spark using the CData Software JDBC Driver.
-
Replicate Contentful Data from PowerShell
Write a quick PowerShell script to query Contentful. Use connectivity to the live data to replicate Contentful to SQL Server.
-
Connect to Marketo Data from PowerBuilder via ADO.NET
This article demonstrates how to access Marketo from Appeon PowerBuilder using the CData ADO.NET Provider for Marketo.
-
Use the CData Software JDBC Driver for Templated in MicroStrategy Desktop
Connect to Templated in MicroStrategy Desktop using the CData Software JDBC Driver for Templated.
-
Automated Continuous Yelp Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Yelp replication to Amazon Redshift.
-
Build Apps with Live Couchbase Data Using the Low-Code Development Platform of Mendix
Connect Couchbase with Mendix to build apps using the CData JDBC Driver for Couchbase.
-
Use the CData Software ODBC Driver for EmailOctopus in SAS for Real-Time Reporting and Analytics
Connect to real-time EmailOctopus in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for EmailOctopus.
-
Access Dropbox Data from MySQL in Amazon QuickSight
Connect to Dropbox and build visualizations of Dropbox using a MySQL Connection in Amazon QuickSight.
-
Connect Sendwithus to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Sendwithus using the CData Python MCP Server.
-
Analyze Salesforce CRM Analytics Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Salesforce CRM Analytics and visualize live Salesforce CRM Analytics in Infragistics Reveal.
-
How to Easily Query YouTube Analytics Data in OpenOffice Base
Connect to YouTube Analytics data in OpenOffice Base using the CData ODBC Driver for YouTube Analytics and generate reports with live data insights.
-
Query MYOB AccountRight Data as a SQL Server Database in Node.js
Execute SQL Server queries against MYOB AccountRight from Node.js.
-
Stream Pingdom Data into Apache Kafka Topics
Access and stream Pingdom in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Import Blackbaud FE NXT Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Blackbaud FE NXT Data and provide access to live Blackbaud FE NXT for custom reports in the Power BI Service.
-
Bidirectional Access to Avalara AvaTax Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Avalara AvaTax in Filemaker Pro for Mac or Windows.
-
Automated Continuous JSON Replication to Databricks
Use CData Sync for automated, continuous, customizable JSON replication to Databricks.
-
Use Claude to Talk to Your Vertica 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 Vertica for you.
-
Create Data Visualizations Based On GitHub Data in Mode
Use CData Connect AI to connect to GitHub Data from Mode and build visualizations using live
-
Integrate Real-Time Access to Google Analytics in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Google Analytics in real time.
-
Bridge Spark Connectivity with Apache NiFi
Access and process Apache Spark SQL in Apache NiFi using the CData JDBC Driver.
-
Bidirectional Access to Telegram Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Telegram in Filemaker Pro for Mac or Windows.
-
ETL Vimeo in Oracle Data Integrator
This article shows how to transfer Vimeo into a data warehouse using Oracle Data Integrator.
-
Connect to Microsoft Exchange Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Microsoft Exchange and the Script function in FileMaker Pro to connect to Microsoft Exchange and work with Microsoft Exchange in your FileMaker application.
-
Viewing Lakebase Data in RAD Studio Data Explorer
How to view Lakebase in RAD Studio Data Explorer using the CData ODBC Driver for Lakebase.
-
How to Work with SAP BusinessObjects BI Data in AWS Glue Jobs Using JDBC
Connect to SAP BusinessObjects BI from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automated Continuous CouchDB Replication to Amazon S3
Use CData Sync for automated, continuous, customizable CouchDB replication to Amazon S3.
-
Access Live FTP 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 FTP Servers through MCP integration.
-
Deploy the ADO.NET Provider for Quaderno on an SSRS Report Server
Connect to Quaderno from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Connect to Exact Online Data in Jaspersoft Studio
Execute SQL to remote Exact Online in Jaspersoft Studio.
-
Deploy the ADO.NET Provider for Adobe Target on an SSRS Report Server
Connect to Adobe Target from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Automate Campaigner Data Replication to Couchbase
Use CData Sync to Customize and automate Campaigner replication to Couchbase.
-
How to Connect DBeaver to AgileCRM via a JDBC Driver
Manage AgileCRM with visual tools in DBeaver like the query browser.
-
Build Agents in Relevance AI with Access to Live Act CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Act CRM within intelligent agent workflows.
-
Build a PostgreSQL Interface for TigerGraph Data using the CData JDBC Driver
Use the Remoting features of the TigerGraph JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to integrate Metabase with Google Ads Data
Use CData Connect AI to connect to live Google Ads and create an interactive dashboard in Metabase from Google Ads.
-
Working with QuickBooks Data in LINQPad
Execute LINQ queries to QuickBooks Desktop in LINQPad.
-
Connect to QuickBooks Data from PowerBuilder via JDBC
This article demonstrates how to access QuickBooks Desktop from PowerBuilder using the QuickBooks JDBC Driver.
-
Automate Azure Data Catalog Data Replication to Azure Synapse
Use CData Sync to customize and automate Azure Data Catalog replication to Azure Synapse.
-
Automate Access Data Replication to Azure Data Lake
Use CData Sync to customize and automate Microsoft Access replication to Azure Data Lake.
-
Connect to SharePoint Excel Services Data in JRuby
Create a simple JRuby app with access to live SharePoint Excel Services.
-
Add MariaDB Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for MariaDB with the Informatica Enterprise Data Catalog to classify and organize data.
-
Consume HBase OData Feeds in PowerBuilder
This article demonstrates how to consume Apache HBase as OData feeds from PowerBuilder using the API Server.
-
Connect to Google Drive Data in RazorSQL
Connect to Google Drive from wizards and query Google Drive from the GUI in the RazorSQL database management tool.
-
Use the CData ODBC Driver for Front in Microsoft Power Query
You can use the CData Front ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Front into Microsoft Power Query.
-
Integrating Boomi Agentstudio with Pipedrive Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Pipedrive, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Automated Continuous Marketo Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Marketo replication to delimited files (CSV/TSV).
-
Getting Started with the CData ADO.NET Provider for Dynamics 365 Business Central
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Dynamics 365 Business Central.
-
Build Data Flows from Procore to SQL Server using SSIS
Easily back up Procore to SQL Server using the SSIS components for Procore.
-
Build Apps with Live ZohoPeople Data Using the Low-Code Development Platform of Mendix
Connect ZohoPeople with Mendix to build apps using the CData API Driver for JDBC.
-
Visualize Datadog Data in Sisense
Create an ElastiCube in Sisense app with access to Datadog.
-
Getting Started with the CData JDBC Driver for ZendeskSell
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for ZendeskSell.
-
How to Create Power BI Visual Reports with Real-Time GraphQL Data
Use CData Power BI Connectors to visualize GraphQL in Power BI.
-
How to publish and share Google Ads Data dashboards with Tableau Server
The CData ODBC driver for Google Ads enables you integrate Google Ads into Tableau dashboards.
-
Create Avalara AvaTax Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Avalara AvaTax data access from reports, embedded analytics, and more.
-
Integrate Cursor with Live GraphQL Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live GraphQL from within the editor.
-
Automated Continuous Helpscout Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Helpscout replication to PostgreSQL.
-
Create Power BI Reports on Real-Time Greenhouse Data
Use the CData ODBC Driver for Greenhouse to visualize Greenhouse in Power BI Desktop.
-
Connect to MessageBird Data in JRuby
Create a simple JRuby app with access to live MessageBird.
-
Connect to Gorgias Data from a Connection Pool in Jetty
The Gorgias JDBC Driver supports connection pooling: This article shows how to connect faster to Gorgias from Web apps in Jetty.
-
Build Access-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Access to explore live Access Data in Gemini Code Assist to assist with building Access-powered applications.
-
Integrating Kiro CLI with Kintone 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.
-
How to Visualize BambooHR Data in Python with pandas
Use pandas and other modules to analyze and visualize live BambooHR in Python.
-
Connect to Active Directory Data in CloverDX (formerly CloverETL)
Transfer Active Directory using the visual workflow in the CloverDX data integration tool.
-
Easily Integrate Pushbullet Data in Lazarus Pascal IDE
Learn how to easily integrate live Pushbullet in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to FHIR Data in Jaspersoft Studio
Execute SQL to remote FHIR in Jaspersoft Studio.
-
Natively Connect to Codat Data in PHP
The CData ODBC driver for Codat enables you to create PHP applications with connectivity to Codat. Leverage the native support for ODBC in PHP.
-
Getting Started with the CData ODBC Driver for ClickTime
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for ClickTime.
-
Azure Data Catalog Reporting in OBIEE with the Azure Data Catalog JDBC Driver
Deploy the Azure Data Catalog JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Integrating Kiro CLI with GraphQL 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 Google Drive Data (MySQL Remoting via JDBC)
Use the Remoting features of the Google Drive JDBC Driver to create a PostgreSQL entry-point for data access.
-
Visualize Live ChargeOver Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live ChargeOver using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Access Live CockroachDB Data in Power Automate Desktop via ODBC
The CData ODBC Driver for CockroachDB enables you to integrate CockroachDB into workflows built using Microsoft Power Automate Desktop.
-
Build an OLAP Cube in SSAS from SAP Ariba Source Data
Establish a connection to SAP Ariba Source data from SQL Server Analysis Services, and use the SAP Ariba Source Data Provider to build OLAP cubes for use in analytics and reporting.
-
Integrate Cursor with Live SAP Netweaver Gateway Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live SAP Netweaver Gateway from within the editor.
-
Build AI Agents with Bullhorn CRM Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Bullhorn CRM through CData Connect AI.
-
Connect to Phoenix Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Apache Phoenix using standard SQL.
-
How to Connect to & Open Jira Assets Data in Microsoft Excel
This article uses the CData ODBC driver for Jira Assets to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build AI/ML Models with Live Oracle SCM Data using Dataiku
Connect Oracle SCM Data with Dataiku using the CData JDBC Driver for Oracle SCM.
-
Choosing the Best Method to Connect Printify to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Printify from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to Access Live xBase Data in Visual Studio Code via Cline
Run CData MCP Server for xBase on Windows Subsytem for Linux (WSL) and connect to live xBase from the Cline extension in Visual Studio Code.
-
Integrate with Omnisend Data in JReport Designer
Create charts and reports based on Omnisend in JReport Designer.
-
How to integrate Gorgias with Apache Airflow
Access and process Gorgias in Apache Airflow using the CData JDBC Driver.