CData Software - Knowledge Base
Recent Articles
-
Integrate Stripe with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Stripe with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Stripe.
-
Build Couchbase-Connected Apps in Choreo
Use CData Connect AI to connect to Couchbase Data from Choreo and build custom apps using live Couchbase.
-
Create Data Visualizations in Cognos BI with Paymo Data
Access Paymo as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Build Charts with REST Data in Clear Analytics
Create dynamic charts and perform analytics based on REST in Clear Analytics.
-
Use Manus AI to Talk to Your Google Campaign Manager 360 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Google Campaign Manager 360.
-
DataBind FreeAgent Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide FreeAgent to a chart.
-
Create WordPress-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to WordPress Data from OutSystems and build custom enterprise apps using live WordPress.
-
Integrate Teamwork Data in Pentaho Data Integration
Build ETL pipelines based on Teamwork in the Pentaho Data Integration tool.
-
Automated Continuous Zoho Books Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Zoho Books replication to Amazon Redshift.
-
Access Live PingOne Data in AWS Lambda (with IntelliJ IDEA)
Connect to live PingOne in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to SharePoint Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for SharePoint to connect to Microsoft SharePoint and execute queries in PowerBuilder.
-
Build Semantic Layer Views for Apollo Data in APOS Live Data Gateway
Use the CData Connector for Apollo in APOS Live Data Gateway to build Semantic Layer Views for Apollo.
-
Create a Data Access Object for SAP Hybris C4C Data using JDBI
A brief overview of creating a SQL Object API for SAP Hybris C4C in JDBI.
-
Build Data Flows from Postmark to SQL Server using SSIS
Easily back up Postmark to SQL Server using the SSIS components for Postmark.
-
Connect to Basecamp Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Basecamp from Filemaker Pro on Mac.
-
Connect to NetSuite Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for NetSuite and the Script function in FileMaker Pro to connect to NetSuite and work with NetSuite CRM & ERP in your FileMaker application.
-
Automated Continuous OnePageCrm Replication to Oracle
Use CData Sync for automated, continuous, customizable OnePageCrm replication to Oracle.
-
How to Create Power BI Visual Reports with Real-Time Azure Synapse Data
Use CData Power BI Connectors to visualize Azure Synapse in Power BI.
-
Connect to Acumatica Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Acumatica as an External Source in Dremio.
-
Access Live WooCommerce Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live WooCommerce from your Excel spreadsheets.
-
Choosing the Best Method to Connect Rebilly to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Rebilly from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Access Live AlloyDB Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Google AlloyDB from your Excel spreadsheets.
-
Building Dynamic Web Pages with Adobe Target Data Using AngularJS
Create single-page applications with live connectivity to Adobe Target using the CData API Server.
-
Connect Pinterest to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Pinterest with IBM WebSphere for seamless data integration and connectivity.
-
Use the CData ODBC Driver for Microsoft Ads from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Microsoft Ads to connect to Microsoft Ads from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Microsoft Ads in Excel.
-
Creating Oracle-Connected Applications in Unqork
You can use CData Connect AI to feed Oracle Database to Unqork and build custom business apps.
-
Build Charts with Sybase Data in Clear Analytics
Create dynamic charts and perform analytics based on Sybase in Clear Analytics.
-
Automated Continuous Freshteam Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Freshteam replication to Apache Kafka.
-
Connect to Figshare Data in Jaspersoft Studio
Execute SQL to remote Figshare in Jaspersoft Studio.
-
DataBind Quaderno Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Quaderno to a chart.
-
Query Zoho Projects Data as a MySQL Database in Node.js
Execute MySQL queries against Zoho Projects from Node.js.
-
Write a Simple Go Application to work with Copper Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Copper.
-
Work with Live SendGrid Data in Power Query
Use CData Connect AI to connect to SendGrid and work with live SendGrid in Microsoft Power Query.
-
Connect and Query Live Dynamics 365 Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Microsoft Dynamics 365 into Databricks
-
Connect to Avro Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Avro Data and connect to Apache Avro in Akorbi Digital RunMyProcess.
-
Load Quickbase Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Quickbase to a database.
-
Integrate Epicor Kinetic Data in Pentaho Data Integration
Build ETL pipelines based on Epicor Kinetic in the Pentaho Data Integration tool.
-
Create Informatica Mappings From/To an ODBC Data Source for Oracle Eloqua Reporting
Create an ODBC connection to Oracle Eloqua Reporting in Informatica and browse and transfer Oracle Eloqua Reporting.
-
Connect to Shippo Data from a Connection Pool in Jetty
The Shippo JDBC Driver supports connection pooling: This article shows how to connect faster to Shippo from Web apps in Jetty.
-
Visualize Live Reckon Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Reckon using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Analyze YouTube Analytics Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze YouTube Analytics in Microsoft R Open.
-
Integrating Codex CLI with Neo4J 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.
-
Use the CData ODBC Driver for MessageBird in Microsoft Power Query
You can use the CData MessageBird ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import MessageBird into Microsoft Power Query.
-
Connect to and Query Google Calendar Data in QlikView over ODBC
Create data visualizations with Google Calendar in QlikView.
-
Integrating Antigravity CLI with CSV/TSV Files via CData CLI
Connect CSV/TSV Files to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Query Exact Online Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Exact Online and perform CRUD operations on Exact Online from Node.js.
-
Connecting Pipedream with Certinia Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Certinia data in real time.
-
Publish Crystal Reports on Billsby Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Billsby.
-
Integrate with live Confluence Data in Jitterbit
Use CData Connect AI to connect to and integrate live Atlassian Confluence in Jitterbit.
-
How to Build an ETL App for Google Search Results in Python with CData Connect AI
Build ETL pipelines that read and write live Google Search in Python with petl and the CData Connect AI Python SDK.
-
Automated Continuous SendPulse Replication to Databricks
Use CData Sync for automated, continuous, customizable SendPulse replication to Databricks.
-
Integrate Real-Time Access to Highrise in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Highrise CRM in real time.
-
Integrating Billsby Data in Talend Cloud Data Management Platform
Connect Billsby Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Create Informatica Mappings From/To an ODBC Data Source for GitHub
Create an ODBC connection to GitHub in Informatica and browse and transfer GitHub.
-
Integrating Kiro CLI with Vimeo 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 Insightly Data in TIBCO Spotfire through ADO.NET
Integrate Insightly into dashboards in TIBCO Spotfire.
-
How to load Google Sheets data into Elasticsearch via Logstash
Introducing a simple method to load Google Sheets data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Automated Continuous Cloudant Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Cloudant replication to delimited files (CSV/TSV).
-
Build an OLAP Cube in SSAS from Codat Data
Establish a connection to Codat data from SQL Server Analysis Services, and use the Codat Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to Blackbaud FE NXT 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 Blackbaud FE NXT.
-
Replicate SAP SuccessFactors Data to Multiple Databases
Replicate SAP SuccessFactors to disparate databases with a point-and-click configuration.
-
Stream Power BI XMLA Data into Apache Kafka Topics
Access and stream Power BI XMLA in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrating Cursor CLI with Testmonitor 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.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for ServiceNow
Provide connectivity to ServiceNow through an SAP BusinessObjects universe.
-
Replicate Monday.com Data in Heroku for Use in Salesforce Connect
Replicate Monday.com to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Sage 300
Provide connectivity to Sage 300 through an SAP BusinessObjects universe.
-
Analyze Live Greenplum Data in SAS Viya
Use CData Connect AI to connect to Pivotal GreenPlum from SAS Viya and deploy self-service analytics using live Pivotal GreenPlum.
-
Integrating Cursor CLI with Square 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.
-
Getting Started with the CData JDBC Driver for Exact Online
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Exact Online.
-
Integrating Claude Code CLI with Shippo 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 Azure DevOps Data from PowerBuilder via JDBC
This article demonstrates how to access Azure DevOps from PowerBuilder using the Azure DevOps JDBC Driver.
-
Consume Redis OData Feeds in PowerBuilder
This article demonstrates how to consume Redis as OData feeds from PowerBuilder using the API Server.
-
A PostgreSQL Interface for Odoo Data using the CData ODBC Driver
Use the SQL Gateway and Odoo ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to SAP Fieldglass Data from PowerBuilder via ADO.NET
This article demonstrates how to access SAP Fieldglass from Appeon PowerBuilder using the CData ADO.NET Provider for SAP Fieldglass.
-
Connect and Visualize Live ActiveCampaign Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live ActiveCampaign into the Databricks platform and create visualization dashboards with real-time ActiveCampaign.
-
Use Biml to Build SSIS Tasks to Replicate Google Forms Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Google Forms to SQL Server.
-
Use the CData Software ODBC Driver for JotForm in MicroStrategy
Connect to JotForm in MicroStrategy Developer using the CData Software ODBC Driver for JotForm.
-
Automated Continuous Zoho Books Replication to Oracle
Use CData Sync for automated, continuous, customizable Zoho Books replication to Oracle.
-
Connect to MySQL Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for MySQL and the SQL Gateway to access MySQL from Google Apps Script.
-
How to connect to Azure Analysis Services Data with Squirrel SQL client
Connect to Azure Analysis Services and execute queries in the Squirrel SQL Client.
-
Edit and Search External Microsoft Entra ID Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Microsoft Entra ID to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Microsoft Entra ID Data objects that you can access from apps and the dashboard.
-
Access Live LightSpeedRetail Data in AWS Lambda
Connect to live LightSpeedRetail in AWS Lambda using the CData JDBC Driver.
-
Import Real-Time Notion Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Notion in ColdFusion.
-
Validate Yelp Data with QuerySurge
Access and validate Yelp in QuerySurge using the CData JDBC Driver.
-
Create SSAS Tabular Models from Anaplan Data
How to build a SQL Server Analysis Service Tabular Model from Anaplan using CData drivers.
-
How to load SAP HANA XS Advanced data into Elasticsearch via Logstash
Introducing a simple method to load SAP HANA XS Advanced data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Create SSAS Tabular Models from Typeform Data
How to build a SQL Server Analysis Service Tabular Model from Typeform using CData drivers.
-
How to connect PolyBase to Timely
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Timely.
-
Create Reports with Azure Data Catalog Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Azure Data Catalog.
-
Visualize Live ChartMogul Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live ChartMogul.
-
How to Query Live Salesforce Pardot Data in Claude Desktop
Connect to and query live Salesforce Pardot Data in Claude Desktop using CData MCP Server.
-
Connect to Bannerbear Data in JRuby
Create a simple JRuby app with access to live Bannerbear.
-
Integrate PolarTeamPro Data in the Pentaho Report Designer
Publish reports based on PolarTeamPro in the Pentaho BI tool.
-
Import Microsoft Entra ID Data Using Azure Data Factory
Use CData Connect AI to connect to Microsoft Entra ID Data from Azure Data Factory and import live Microsoft Entra ID.
-
Integrating Codex CLI with Chargebee 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.
-
Integrate Oracle SCM Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Oracle SCM from Informatica Cloud.
-
Visualize SAP SuccessFactors Data in TIBCO Spotfire through ADO.NET
Integrate SAP SuccessFactors into dashboards in TIBCO Spotfire.
-
Build Visualizations of Pipedrive Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Pipedrive in Birst.
-
A PostgreSQL Interface for Demio Data using the CData ODBC Driver
Use the SQL Gateway and Demio ODBC Driver to create a PostgreSQL entry-point for data access.
-
Feed Gong Data into FineReport
How to set Gong as a JDBC data source in FineReport.