CData Software - Knowledge Base
Recent Articles
-
Query NetSuite Data in DataGrip
Create a Data Source for NetSuite in DataGrip and use SQL to query live NetSuite CRM & ERP.
-
Connect to BigQuery Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Google BigQuery from Filemaker Pro on Mac.
-
Analyze Jira Assets Data in Cognos Analytics
Use CData Connect AI to connect to Jira Assets Data from Cognos Analytics and analyze live Jira Assets.
-
Create SAP ByDesign-Connected Applications in Appsmith
Connect to SAP ByDesign Data via CData Connect AI in Appsmith and create custom business applications with real-time access to SAP Business ByDesign.
-
How to Seamlessly Import Azure Data Catalog Data into IBM SPSS Modeler
Integrate Azure Data Catalog data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Integrate with SAP Ariba Source Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy SAP Ariba Source to a JSON file on disk.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Salesloft
Provide connectivity to Salesloft through an SAP BusinessObjects universe.
-
Getting Started with the CData SSIS Components for Google Translate
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Google Translate.
-
How to Work with Kafka Data in ETL Validator JDBC
Connect to Kafka from ETL Validator jobs using the CData Software JDBC Driver.
-
Query Omnisend Data in DataGrip
Create a Data Source for Omnisend in DataGrip and use SQL to query live Omnisend.
-
Connect to Wistia Data from a Connection Pool in JBoss
Integrate Wistia into Java servlets: Use the Management Console in JBoss to install the Wistia JDBC Driver.
-
Build Dashboards with SAP Hybris C4C Data in Dundas BI
Create dynamic dashboards and perform analytics based on SAP Hybris C4C in Dundas BI.
-
Automated Continuous Mode Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Mode replication to Amazon S3.
-
Build Azure Table-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Azure Table Storage and build web apps with connectivity to live Azure Table Storage.
-
Publish Timely-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Timely.
-
Excel Spreadsheet Automation on ClickTime Data with the QUERY Formula
Pull data from ClickTime, automate spreadsheets, and more with the QUERY formula.
-
Access DB2 Data from MySQL in Amazon QuickSight
Connect to DB2 and build visualizations of IBM DB2 using a MySQL Connection in Amazon QuickSight.
-
Integrating LlamaIndex with Oracle Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Oracle Database in real time.
-
Figshare Reporting in OBIEE with the Figshare JDBC Driver
Deploy the Figshare JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Integrate LibreChat with Live SAP Business One Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live SAP Business One from within the chat interface.
-
Getting Started with the CData SSIS Components for Smartsheet
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Smartsheet.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed eBay to Power BI dashboards. Simply drag and drop eBay into data visuals on the Power BI canvas.
-
Build a Singer.io Tap for Oracle Sales With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Oracle Sales data using
-
DataBind Charts to Certinia Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Certinia 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.
-
Getting Started with the CData JDBC Driver for Office 365
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Office 365.
-
Analyze Jira Assets Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Jira Assets and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Build Smartsheet-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Smartsheet to explore live Smartsheet Data in Cursor to assist with building Smartsheet-powered applications.
-
Automated Continuous Google Ads Replication to Databricks
Use CData Sync for automated, continuous, customizable Google Ads replication to Databricks.
-
DataBind Bright Data Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Bright Data to a chart.
-
Import Real-Time Accelo Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Accelo in ColdFusion.
-
How to Query Live Vault CRM Data in Claude Desktop
Connect to and query live Vault CRM Data in Claude Desktop using CData MCP Server.
-
Query Microsoft Entra ID Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Microsoft Entra ID entities in PHP by modeling them as objects.
-
Automated Continuous Google Ad Manager Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Google Ad Manager replication to Apache Cassandra.
-
Object-Relational Mapping (ORM) with Oracle Eloqua Reporting Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Oracle Eloqua Reporting into a Java-based ORM framework, Hibernate.
-
Create Dynamic Avro Grids Using the Infragistics XamDataGrid
Learn how you can connect Avro to Infragistics XamDataGrid to build dynamic grids.
-
How to work with Superchat Data in Apache Spark using SQL
Access and process Superchat Data in Apache Spark using the CData Software JDBC Driver.
-
How to Connect the Power BI Service to Facebook: Complete Guide
Connect to the CData Software Power BI Connector for Facebook from PowerBI.com to provide real-time Facebook across the organization.
-
How to connect to SQL Server Data with Squirrel SQL client
Connect to Microsoft SQL Server and execute queries in the Squirrel SQL Client.
-
Object-Relational Mapping (ORM) with HubSpot Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to HubSpot into a Java-based ORM framework, Hibernate.
-
Build Dashboards with SAP Ariba Procurement Data in Dundas BI
Create dynamic dashboards and perform analytics based on SAP Ariba Procurement in Dundas BI.
-
How to integrate Amazon DynamoDB with Apache Airflow
Access and process Amazon DynamoDB in Apache Airflow using the CData JDBC Driver.
-
How to Seamlessly Import GitLab Data into IBM SPSS Modeler
Integrate GitLab data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to Access DocuSign Data Using Entity Framework
This article shows how to access DocuSign using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Access Live Redis Data in AWS Lambda
Connect to live Redis in AWS Lambda using the CData JDBC Driver.
-
Query AdRoll Data as a MySQL Database in Node.js
Execute MySQL queries against AdRoll from Node.js.
-
Connecting Pipedream with Shopify 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 Shopify data in real time.
-
Access PostgreSQL Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access PostgreSQL from your Oracle system.
-
Query Azure Table Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Azure Table Storage from Node.js.
-
Integrating Claude Code CLI with Webflow 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 Delighted Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Delighted.
-
Connect to Authorize.Net from a Connection Pool in WebLogic
Use the CData JDBC Driver for Authorize.Net to connect to Authorize.Net from Web applications running on WebLogic.
-
Visualize PingOne Data in TIBCO Spotfire through OData
Integrate PingOne into dashboards in TIBCO Spotfire.
-
Create Chargebee Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Chargebee data access from reports, embedded analytics, and more.
-
Integrating LangGraph with Freshdesk Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Freshdesk within automated workflows.
-
Viewing Datadog Data in RAD Studio Data Explorer
How to view Datadog in RAD Studio Data Explorer using the CData ODBC Driver for Datadog.
-
Back Up Oracle Eloqua Reporting to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Oracle Eloqua Reporting. In this article, we will employ an SSIS workflow to populate a database with Oracle Eloqua Reporting data.
-
DataBind Controls to Google Translate Data in Delphi
DataBind to Google Translate in Delphi with standard data access components and controls.
-
Analyze QuickBooks Time Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of QuickBooks Time and visualize QuickBooks Time in SAP Analytics Cloud.
-
Operational Reporting on HubSpot Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote HubSpot.
-
Integrate Cline with Live API Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live API from within your IDE.
-
Getting Started with the CData ODBC Driver for SAP
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for SAP.
-
Automate ZohoDesk Data Replication to SAP HANA
Use CData Sync to customize and automate ZohoDesk replication to SAP HANA.
-
Operational Reporting on Scrapfly Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Scrapfly.
-
Connect to Microsoft Teams Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Microsoft Teams from Filemaker Pro on Mac.
-
Build Salesforce Data 360-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Salesforce Data 360 to explore live Salesforce Data 360 Data in Cursor to assist with building Salesforce Data 360-powered applications.
-
Integrating Claude Code CLI with ZohoInvoice 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.
-
Integrate Live CockroachDB Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to CockroachDB from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live CockroachDB.
-
Getting Started with the CData Tableau Connector for Anaplan
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Anaplan.
-
Build a Simple VCL Application for QuickBooks Time Data
How to build a simple VCL Application to view QuickBooks Time in RAD Studio using the CData ODBC Driver for QuickBooks Time.
-
Connect to Campaigner Data in RapidMiner
Integrate Campaigner with standard components and data source configuration wizards in RapidMiner Studio.
-
Automate Microsoft OneLake Data Replication to SAP HANA
Use CData Sync to customize and automate Microsoft OneLake replication to SAP HANA.
-
Use the CData Software ODBC Driver for MarkLogic in SAS for Real-Time Reporting and Analytics
Connect to real-time MarkLogic in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for MarkLogic.
-
A PostgreSQL Interface for Campaigner Data (MySQL Remoting via JDBC)
Use the Remoting features of the Campaigner JDBC Driver to create a PostgreSQL entry-point for data access.
-
Replicate Printify Data to Multiple Databases via the CData Sync CLI
Replicate Printify to disparate databases with a single configuration.
-
Migrating data from Aircall to Snowflake using CData SSIS Components.
Easily push Aircall to Snowflake using the CData SSIS Tasks for Aircall and Snowflake.
-
Build AI Agents with Oracle Service Cloud 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 Oracle Service Cloud through CData Connect AI.
-
Integrating Kiro CLI with Zoho Inventory 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.
-
Integrating GitHub Copilot CLI with Perigon 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 JDBC Driver for PagerDuty
Provide connectivity to PagerDuty through an SAP BusinessObjects universe.
-
Integrating Antigravity CLI with Microsoft Exchange via CData CLI
Connect Microsoft Exchange to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to Hugging Face Data in JRuby
Create a simple JRuby app with access to live Hugging Face.
-
Integrating Boomi Agentstudio with Jira Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Atlassian Jira, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Connecting Moonlit Workflow with Acumatica Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Acumatica ERP in real time.
-
Getting Started with the CData Connect AI Python SDK for Oracle
Install the CData Connect AI Python SDK to read and write live Oracle Database with standard DB-API 2.0 Python code.
-
How to Access Dynamics 365 Data Using Entity Framework
This article shows how to access Microsoft Dynamics 365 using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Access Live Sage Cloud Accounting Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Sage Business Cloud Accounting from your Excel spreadsheets.
-
Connect to Office 365 Data from a Connection Pool in JBoss
Integrate Microsoft Office 365 into Java servlets: Use the Management Console in JBoss to install the Office 365 JDBC Driver.
-
Use the CData Software ODBC Driver for CloudConvert in MicroStrategy Web
Connect to CloudConvert in MicroStrategy Web using the CData Software ODBC Driver for CloudConvert.
-
Connect to JotForm Data as an External Source in Dremio
Use the CData JDBC Driver to connect to JotForm as an External Source in Dremio.
-
How to publish and share Facebook Ads Data dashboards with Tableau Server
The CData ODBC driver for Facebook Ads enables you integrate Facebook Ads into Tableau dashboards.
-
Build MVC Applications with Connectivity to Instantly Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Instantly from an ASP.NET MVC application.
-
Use Databricks Agent Bricks to Talk to Your HBase Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Apache HBase for you.
-
Create a Data Access Object for Exact Online Data using JDBI
A brief overview of creating a SQL Object API for Exact Online in JDBI.
-
Automated Continuous Avalara AvaTax Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Avalara AvaTax replication to Azure SQL Database.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Active Directory to Power BI dashboards. Simply drag and drop Active Directory into data visuals on the Power BI canvas.
-
Connect to and Query iContact Data in QlikView over ODBC
Create data visualizations with iContact in QlikView.
-
Automated Continuous ZohoPeople Replication to Vertica
Use CData Sync for automated, continuous, customizable ZohoPeople replication to Vertica.
-
Create Google Analytics Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Google Analytics from PowerBI.com to create Power BI Dataflows with real-time data.
-
Automated Continuous FHIR Replication to Databricks
Use CData Sync for automated, continuous, customizable FHIR replication to Databricks.
-
Bridge Oracle HCM Cloud Connectivity with Apache NiFi
Access and process Oracle HCM Cloud in Apache NiFi using the CData JDBC Driver.