CData Software - Knowledge Base
Recent Articles
-
Integrating Codex CLI with Greenhouse 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 Informatica Mappings From/To a JDBC Data Source for Access
Create Access data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Integrate Live SAS xpt Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to SAS XPORT and integrate live SAS XPORT into apps built in Microsoft Power Apps.
-
Connect to Google Spanner Data in DBArtisan
Use wizards in DBArtisan to configure Google Spanner as a data source.
-
Connect to Confluence Data in Google Apps Script via Connect AI
Use CData Connect AI to access Atlassian Confluence in Google Apps Script.
-
Create Reports with Retently Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Retently.
-
How to Query Recurly Data in MySQL Workbench
Execute MySQL queries against live Recurly from MySQL Workbench.
-
Integrate JSON with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate JSON with External Services.
-
Publish Delighted-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Delighted.
-
Automated Continuous Wave Financial Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Wave Financial replication to Apache Cassandra.
-
Connect to Shortcut Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Work with Landbot Data in FoxPro
Load Landbot into a FoxPro database. This article includes full code and a walk-through of the process.
-
Automate Jodoo Data Replication to Couchbase
Use CData Sync to Customize and automate Jodoo replication to Couchbase.
-
Connect to Quaderno Data in JRuby
Create a simple JRuby app with access to live Quaderno.
-
Automated Continuous Salesforce Replication to MongoDB
Use CData Sync for automated, continuous, customizable Salesforce replication to MongoDB.
-
Integrating Claude Code CLI with Smartsheet 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 CRM Accounts from QuickBooks Customers
10 steps to automate the transfer your QuickBooks customers into Dynamics CRM accounts.
-
Visualize Mailgun Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Mailgun.
-
How to Work with SendInBlue Data in ETL Validator JDBC
Connect to SendInBlue from ETL Validator jobs using the CData Software JDBC Driver.
-
Automated Continuous Phoenix Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Phoenix replication to Apache Cassandra.
-
Integrate with Live SAS Data Sets Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to SAS Data Sets from the MuleSoft Anypoint Platform to integrate live SAS Data Sets into custom reports and dashboards.
-
Automated Continuous Dynamics 365 Business Central Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Dynamics 365 Business Central replication to Google BigQuery.
-
DataBind Charts to Miro Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Miro 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.
-
Design BIRT Reports on Hugging Face Data
Provide current Hugging Face to your embedded analytics.
-
Connect to Hacker News Data in Aqua Data Studio
Access Hacker News from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Live Google Campaign Manager 360 Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Google Campaign Manager 360 in CData Connect AI and connect to your Google Campaign Manager 360 from PostgreSQL.
-
Visualize Customer.io Data in Sisense
Create an ElastiCube in Sisense app with access to Customer.io.
-
Create Datasets from Codat in Domo Workbench and Build Visualizations of Codat Data in Domo
Use the CData Software ODBC Driver for Codat to create datasets from Codat in Domo Workbench and then build visualizations in the Domo service.
-
Automate JSON Integration Tasks from PowerShell
Are you in search of a quick and easy way to access JSON from PowerShell? This article demonstrates how to utilize the JSON Cmdlets for tasks like connecting to JSON, automating operations, downloading data, and more.
-
Create Informatica Mappings From/To an ODBC Data Source for Salesforce CRM Analytics
Create an ODBC connection to Salesforce CRM Analytics in Informatica and browse and transfer Salesforce CRM Analytics.
-
Use JayDeBeApi to access LinkedIn Data in Python
Use standard Python scripting and the development environment of your choice to access live LinkedIn.
-
Access Live ShipStation Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate ShipStation into the statistical analysis tools available in SAS JMP. This article shows how to use ShipStation in the Graph Builder and Query Builder.
-
Import Real-Time CouchDB Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Apache CouchDB in ColdFusion.
-
Automated Continuous Bugsnag Replication to MySQL
Use CData Sync for automated, continuous, customizable Bugsnag replication to MySQL.
-
Create Power BI Reports on Real-Time Perigon Data
Use the CData ODBC Driver for Perigon to visualize Perigon in Power BI Desktop.
-
Build Dashboards with HubSpot Data in DBxtra
Create dynamic dashboards and perform analytics based on HubSpot in DBxtra.
-
Automated Continuous Salesloft Replication to Databricks
Use CData Sync for automated, continuous, customizable Salesloft replication to Databricks.
-
Neo4J Reporting in OBIEE with the Neo4J JDBC Driver
Deploy the Neo4J JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Visualize Live FreshBooks Data in the Power BI Service
Use CData Connect AI to connect to live FreshBooks and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Dynamics 365 Data in Claris FileMaker Pro
Use the CData ODBC Driver for Dynamics 365 in FileMaker Pro to connect to Dynamics 365 and work with Microsoft Dynamics 365 in your FileMaker applications.
-
Integrating OpenCode Terminal with Okta 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 SSAS Tabular Models from Nethunt Data
How to build a SQL Server Analysis Service Tabular Model from Nethunt using CData drivers.
-
Connect to Calendly Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Integrating Gumloop with Act-On Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Act-On within automated workflows.
-
DataBind Printify Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Printify to a chart.
-
Publish Sage 300-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Sage 300.
-
Access AdRoll Data from MySQL in PHP
Connect to AdRoll through the standard MySQL libraries in PHP.
-
Create OneNote-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to OneNote Data from Klipfolio and build custom visualizations using live Microsoft OneNote.
-
Connect to Simplesat Data in RazorSQL
Connect to Simplesat from wizards and query Simplesat from the GUI in the RazorSQL database management tool.
-
Create Dynamic HCL Domino Grids Using the Infragistics XamDataGrid
Learn how you can connect HCL Domino to Infragistics XamDataGrid to build dynamic grids.
-
Integrating GitHub Copilot CLI with Workday 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 Semantic Layer Views for WooCommerce Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for WooCommerce.
-
Bridge Retently Connectivity with Apache NiFi
Access and process Retently in Apache NiFi using the CData JDBC Driver.
-
Bannerbear Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Bannerbear facts in real time.
-
Integrate Cline with Live Monday.com Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Monday.com from within your IDE.
-
How to connect SharePoint with BigCommerce Data through external lists
Provide BigCommerce to SharePoint users as an external list.
-
Build MariaDB-Connected Apps in Choreo
Use CData Connect AI to connect to MariaDB Data from Choreo and build custom apps using live MariaDB.
-
Connect to Google Drive Data from AWS Glue
Use CData Connect AI to gain access to live Google Drive from your AWS Glue jobs.
-
Automated Continuous OData Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable OData replication to Apache Cassandra.
-
Automated Continuous Coinbase Replication to Databricks
Use CData Sync for automated, continuous, customizable Coinbase replication to Databricks.
-
Process & Analyze ConstantContact Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live ConstantContact Data.
-
Automated Continuous Sybase Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Sybase replication to Google BigQuery.
-
Build AI Agents with Freshdesk 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 Freshdesk through CData Connect AI.
-
How to Easily Query SageHR Data in OpenOffice Base
Connect to SageHR data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Bidirectional Access to Sugar CRM Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Sugar CRM in Filemaker Pro for Mac or Windows.
-
How to Connect to & Open ShipEngine Data in Microsoft Excel
This article uses the CData ODBC driver for ShipEngine to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Query Amazon Marketplace Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Amazon Marketplace and perform CRUD operations on Amazon Marketplace from Node.js.
-
Build AI/ML Models with Live PingOne Data using Dataiku
Connect PingOne Data with Dataiku using the CData JDBC Driver for PingOne.
-
Automated Continuous Microsoft Planner Replication to MySQL
Use CData Sync for automated, continuous, customizable Microsoft Planner replication to MySQL.
-
Replicate Cosmos DB Data from PowerShell
Write a quick PowerShell script to query Azure Cosmos DB. Use connectivity to the live data to replicate Azure Cosmos DB to SQL Server.
-
Access Live ZarMoney Data in Coginiti Pro
Connect to and query live ZarMoney from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
LINQ to SAS xpt 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 SAS xpt Data Provider.
-
Build Dashboards with Greenplum Data in DBxtra
Create dynamic dashboards and perform analytics based on Pivotal GreenPlum in DBxtra.
-
Create Informatica Mappings From/To an ODBC Data Source for Microsoft Dataverse
Create an ODBC connection to Microsoft Dataverse in Informatica and browse and transfer Microsoft Dataverse (CDS).
-
Visualize Live Act CRM Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Act CRM using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Publish Foursquare-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Foursquare.
-
Getting Started with the CData JDBC Driver for Microsoft Teams
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Microsoft Teams.
-
Visualize Microsoft Ads Data in Tableau
The CData ODBC driver for Microsoft Ads enables you integrate Microsoft Ads into Tableau dashboards.
-
Connect ConvertAPI Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your ConvertAPI using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Build Semantic Layer Views for Sage 200 Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Sage 200.
-
Build HCL Domino-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for HCL Domino to explore live HCL Domino Data in Claude Code to assist with building HCL Domino-powered applications.
-
Connect to Deel Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Natively Connect to Nethunt Data in PHP
The CData ODBC driver for Nethunt enables you to create PHP applications with connectivity to Nethunt. Leverage the native support for ODBC in PHP.
-
Connect to eBay Analytics Data from a Connection Pool in JBoss
Integrate eBay Analytics into Java servlets: Use the Management Console in JBoss to install the eBay Analytics JDBC Driver.
-
Automated Continuous Microsoft Teams Replication to Oracle
Use CData Sync for automated, continuous, customizable Microsoft Teams replication to Oracle.
-
How to Create Power BI Visual Reports with Real-Time Stripe Data
Use CData Power BI Connectors to visualize Stripe in Power BI.
-
Use JayDeBeApi to access Timely Data in Python
Use standard Python scripting and the development environment of your choice to access live Timely.
-
DataBind Charts to Oracle Service Cloud Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Oracle Service Cloud 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.
-
Create Zoho Projects-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Zoho Projects Data from OutSystems and build custom enterprise apps using live Zoho Projects.
-
DataBind Charts to Sage 300 Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Sage 300 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.
-
Access Live GraphQL Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate GraphQL into the statistical analysis tools available in SAS JMP. This article shows how to use GraphQL in the Graph Builder and Query Builder.
-
Build an OLAP Cube in SSAS from Insightly Data
Establish a connection to Insightly data from SQL Server Analysis Services, and use the Insightly Data Provider to build OLAP cubes for use in analytics and reporting.
-
Create a Data Access Object for Oracle Eloqua Data using JDBI
A brief overview of creating a SQL Object API for Oracle Eloqua in JDBI.
-
Use the CData Software JDBC Driver for OneNote in MicroStrategy Web
Connect to Microsoft OneNote in MicroStrategy Web using the CData Software JDBC Driver for OneNote.
-
Easily Integrate Reply.io Data in Lazarus Pascal IDE
Learn how to easily integrate live Reply.io in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Integrate with Live MySQL Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to MySQL from the MuleSoft Anypoint Platform to integrate live MySQL into custom reports and dashboards.
-
Integrate Live Monday.com Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Provide OData Services of Wrike Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Wrike by developing a WCF Service Application.
-
Create Nethunt Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Nethunt data access from reports, embedded analytics, and more.
-
How to Visualize SingleStore Data in Python with pandas
Use pandas and other modules to analyze and visualize live SingleStore in Python.