CData Software - Knowledge Base
Recent Articles
-
Publish Reports with BigCommerce Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date BigCommerce.
-
Automated Continuous ADP Replication to Amazon S3
Use CData Sync for automated, continuous, customizable ADP replication to Amazon S3.
-
Build a Simple VCL Application for Zendesk Data
How to build a simple VCL Application to view Zendesk in RAD Studio using the CData ODBC Driver for Zendesk.
-
Build Everhour-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Everhour.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Odoo ERP to Power BI dashboards. Simply drag and drop Odoo ERP into data visuals on the Power BI canvas.
-
Create Stripe-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Stripe Data from Klipfolio and build custom visualizations using live Stripe.
-
Build AI Agents with Blackbaud FE NXT 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 Blackbaud FE NXT through CData Connect AI.
-
How to Visualize Dynamics 365 Data in Python with pandas
Use pandas and other modules to analyze and visualize live Microsoft Dynamics 365 in Python.
-
Use Dash to Build Web Apps on MYOB AccountRight Data via CData Connect AI
Build interactive Dash web apps on live MYOB AccountRight using pandas and the CData Connect AI Python SDK.
-
Connect to Real-Time MariaDB Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for MariaDB and Dataflow to import and use MariaDB in Power Apps.
-
How to import Stack Exchange Data into Apache Solr
Use the CData Software JDBC Driver for Stack Exchange in Data Import Handler and create an automated import of Stack Exchange to Apache Solr Enterprise Search platform.
-
How to Connect to Live Klaviyo Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Klaviyo for you.
-
How to connect SharePoint with Azure Table Data through external lists
Provide Azure Table Storage to SharePoint users as an external list.
-
Automated Continuous Clari Replication to Vertica
Use CData Sync for automated, continuous, customizable Clari replication to Vertica.
-
Create Power BI Reports on Real-Time Sugar CRM Data
Use the CData ODBC Driver for Sugar CRM to visualize Sugar CRM in Power BI Desktop.
-
Access Kintone Data from MySQL in Amazon QuickSight
Connect to Kintone and build visualizations of Kintone using a MySQL Connection in Amazon QuickSight.
-
Enable the SAP Netweaver Gateway JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with SAP Netweaver Gateway.
-
Automate Certinia Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Certinia from PowerShell? This article demonstrates how to utilize the Certinia Cmdlets for tasks like connecting to Certinia, automating operations, downloading data, and more.
-
Automated Continuous Chargebee Replication to Databricks
Use CData Sync for automated, continuous, customizable Chargebee replication to Databricks.
-
Integrating Claude Code with Trello Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Trello within assisted coding and automated development workflows.
-
Rapidly Develop Spark-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Spark.
-
How to Seamlessly Import Nuclia Data into IBM SPSS Modeler
Integrate Nuclia data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build AI/ML Models with Live JDBC-ODBC Bridge Data using Dataiku
Connect JDBC-ODBC Bridge Data with Dataiku using the CData JDBC-ODBC Bridge.
-
How to connect to Azure DevOps Data with Squirrel SQL client
Connect to Azure DevOps and execute queries in the Squirrel SQL Client.
-
Configure the CData JDBC Driver for NetSuite in a Connection Pool in Tomcat
Connect to NetSuite CRM & ERP from a connection pool in Tomcat.
-
A PostgreSQL Interface for Anaplan Data (MySQL Remoting via JDBC)
Use the Remoting features of the Anaplan JDBC Driver to create a PostgreSQL entry-point for data access.
-
Stream Microsoft OneDrive Data into Apache Kafka Topics
Access and stream Microsoft OneDrive in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Build a PostgreSQL Interface for CapsuleCRM Data using the CData JDBC Driver
Use the Remoting features of the CapsuleCRM JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Webflow
Provide connectivity to Webflow through an SAP BusinessObjects universe.
-
Build Apps with Live Microsoft Dynamics CRM in Adalo using CData Connect AI
Use CData Connect AI to integrate live Microsoft Dynamics CRM into the Adalo platform and build custom mobile and web applications with real-time Microsoft Dynamics CRM.
-
Analyze Drift Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Drift in Microsoft R Open.
-
Easily Integrate CircleCI Data in Lazarus Pascal IDE
Learn how to easily integrate live CircleCI in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Automated Continuous Microsoft Ads Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Microsoft Ads replication to Apache Kafka.
-
Publish FormSite-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live FormSite.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Microsoft OneDrive using the Model Context Protocol.
-
Natively Connect to Optimizely Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Optimizely. Leverage the native support for ODBC in PHP.
-
Import Twitter Ads Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Twitter Ads. In this article, you will use the OData format to import Twitter Ads into Microsoft Power Query.
-
Create Data Visualizations Based On Basecamp Data in Mode
Use CData Connect AI to connect to Basecamp Data from Mode and build visualizations using live
-
Back Up Suadeo to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Suadeo. In this article, we will employ an SSIS workflow to populate a database with Suadeo data.
-
Easily Integrate Acumatica Data in Lazarus Pascal IDE
Learn how to easily integrate live Acumatica ERP in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Getting Started with the CData SSIS Components for Front
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Front.
-
How to Access Telegram Data Using Entity Framework
This article shows how to access Telegram using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Create Data Visualizations in Cognos BI with Stack Exchange Data
Access Stack Exchange as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Create Airtable-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Airtable Data from Klipfolio and build custom visualizations using live Airtable.
-
Query Strava Data in DataGrip
Create a Data Source for Strava in DataGrip and use SQL to query live Strava.
-
Access Live SAP ByDesign Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate SAP Business ByDesign into the statistical analysis tools available in SAS JMP. This article shows how to use SAP Business ByDesign in the Graph Builder and Query Builder.
-
Connect to Microsoft Entra ID Data in NetBeans
Connect to Microsoft Entra ID in NetBeans with the data source configuration wizard.
-
Integrate Oracle Eloqua Reporting with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Oracle Eloqua Reporting with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Oracle Eloqua Reporting.
-
Automated Continuous BambooHR Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable BambooHR replication to OneLake in Microsoft Fabric.
-
Automate Testmonitor Data Replication to SAP HANA
Use CData Sync to customize and automate Testmonitor replication to SAP HANA.
-
Visualize Live MYOB AccountRight Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live MYOB AccountRight.
-
How to Access Live Twilio Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Twilio enables you to integrate Twilio into workflows built using Microsoft Power Automate Desktop.
-
Create Dynamic Zoom Grids Using the Infragistics XamDataGrid
Learn how you can connect Zoom to Infragistics XamDataGrid to build dynamic grids.
-
Publish Reports with SparkPost Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SparkPost.
-
Connect to Mailjet Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Mailjet.
-
Replicate Multiple Dynamics CRM Accounts via the CData Sync CLI
Replicate multiple Dynamics CRM accounts to one or many databases.
-
Create Data Visualizations Based On Bullhorn CRM Data in Mode
Use CData Connect AI to connect to Bullhorn CRM Data from Mode and build visualizations using live
-
Use Grok to Talk to Your Zendesk 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 Zendesk for you.
-
Build Agents in Relevance AI with Access to Live Twilio Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Twilio within intelligent agent workflows.
-
How to load PDFMonkey data into Elasticsearch via Logstash
Introducing a simple method to load PDFMonkey data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Build Authorize.Net-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Authorize.Net and build web apps with connectivity to live Authorize.Net.
-
Build a Singer.io Tap for Webex With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Webex data using
-
Query SQL Server Data in DataGrip
Create a Data Source for SQL Server in DataGrip and use SQL to query live Microsoft SQL Server.
-
MongoDB Reporting in OBIEE with the MongoDB JDBC Driver
Deploy the MongoDB JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Getting Started with the CData Power BI Connector for Instagram
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Instagram.
-
Connect to Harvest Data in CloverDX (formerly CloverETL)
Transfer Harvest using the visual workflow in the CloverDX data integration tool.
-
How to Connect to Live SAP BusinessObjects BI Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live SAP BusinessObjects BI without replication.
-
Integrating Claude Code CLI with Power BI XMLA 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.
-
Configure the CData JDBC Driver for SAP SuccessFactors in a Connection Pool in Tomcat
Connect to SAP SuccessFactors from a connection pool in Tomcat.
-
Connect to Cloudant Data in Jaspersoft Studio
Execute SQL to remote IBM Cloudant in Jaspersoft Studio.
-
Integrating GitHub Copilot CLI with Freshsales 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 Access Adobe Target Data Using Entity Framework
This article shows how to access Adobe Target using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Build AI/ML Models with Live Mailjet Data using Dataiku
Connect Mailjet Data with Dataiku using the CData API Driver for JDBC.
-
Operational Reporting on Guru Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Guru.
-
How to use SQLAlchemy ORM to access RSS Feeds in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of RSS Feeds.
-
Provide OData Services of GetResponse Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for GetResponse by developing a WCF Service Application.
-
Use the CData ODBC Driver for SAS Data Sets in Microsoft Power Query
You can use the CData SAS Data Sets ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import SAS Data Sets into Microsoft Power Query.
-
Query MailerLite Data in DataGrip
Create a Data Source for MailerLite in DataGrip and use SQL to query live MailerLite.
-
A PostgreSQL Interface for HubSpot Data (MySQL Remoting via JDBC)
Use the Remoting features of the HubSpot JDBC Driver to create a PostgreSQL entry-point for data access.
-
Publish Crystal Reports on Parallel Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Parallel.
-
Establish a Live Connection with Microsoft Ads Data using Tableau Bridge
The CData ODBC Driver for Microsoft Ads enables you to integrate live Microsoft Ads into Tableau Cloud dashboards using the Tableau Bridge.
-
Publish Reports with Vercel Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Vercel.
-
Integrating Kiro CLI with CockroachDB 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 Tally Data in DBeaver
Use the CData ODBC Driver to connect to Tally ERP in DBeaver.
-
Use JayDeBeApi to access MessageBird Data in Python
Use standard Python scripting and the development environment of your choice to access live MessageBird.
-
Migrating data from Amazon S3 to Databricks using CData SSIS Components.
Easily push Amazon S3 to Databricks using the CData SSIS Tasks for Amazon S3 and Databricks.
-
Connecting GenSpark with Sage 200 Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Sage 200 without any replication or custom integration required.
-
Visualize Live Oracle Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Oracle Database using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Access Live Microsoft Entra ID Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Microsoft Entra ID enables you to integrate Microsoft Entra ID into workflows built using Microsoft Power Automate Desktop.
-
Integrating Claude Code CLI with Yelp 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 SAP ByDesign Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with SAP ByDesign Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Connect to Presto Data in Aqua Data Studio
Access Presto from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to BigCommerce Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for BigCommerce in Airbyte.
-
Query Eventbrite Data in DataGrip
Create a Data Source for Eventbrite in DataGrip and use SQL to query live Eventbrite.
-
Use the CData ODBC Driver for Miro from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Miro to connect to Miro from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Miro in Excel.
-
Create Klaviyo-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Klaviyo Data from Klipfolio and build custom visualizations using live Klaviyo.
-
Query Active Directory Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Active Directory from Node.js.
-
Create Datasets from SharePoint Excel Services in Domo Workbench and Build Visualizations of SharePoint Excel Services Data in Domo
Use the CData Software ODBC Driver for SharePoint Excel Services to create datasets from SharePoint Excel Services in Domo Workbench and then build visualizations in the Domo service.
-
Integrate Live Snapchat Ads Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Snapchat Ads from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Snapchat Ads.
-
How to Design Azure Table Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Azure Table from mobile and tablet Power Apps.