CData Software - Knowledge Base
Recent Articles
-
Operational Reporting on Kintone Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Kintone data.
-
Visualize Live SAS Data Sets Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live SAS Data Sets data.
-
How to Connect DBeaver to Marketo via a JDBC Driver
Manage Marketo data with visual tools in DBeaver like the query browser.
-
Operational Reporting on Superchat Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Superchat data.
-
Excel Spreadsheet Automation on Salesforce Pardot Data with the QUERY Formula
Pull data from Salesforce Pardot, automate spreadsheets, and more with the QUERY formula.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for MYOB AccountRight
Provide connectivity to MYOB AccountRight data through an SAP BusinessObjects universe.
-
Integrate with Power BI XMLA Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Power BI XMLA data to a JSON file on disk.
-
Use Dash to Build to Web Apps on Dynamics CRM Data
Create Python applications that use pandas and Dash to build Dynamics CRM-connected web apps.
-
How to Work with LightSpeedRetail Data in ETL Validator JDBC
Connect to LightSpeedRetail from ETL Validator jobs using the CData Software JDBC Driver.
-
Perform Batch Operations with MongoDB Data in Apache NiFi
Connect to MongoDB data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Build MVC Applications with Connectivity to JotForm Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access JotForm from an ASP.NET MVC application.
-
Create SSAS Tabular Models from Factorial Data
How to build a SQL Server Analysis Service Tabular Model from Factorial data using CData drivers.
-
Analyze VWO Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze VWO data with the CData JDBC Driver for VWO.
-
Using the CData Software ODBC Driver for Raisers Edge NXT in PyCharm
Connect to Raisers Edge NXT as an ODBC data source in PyCharm using the CData Software ODBC Driver for Raisers Edge NXT.
-
Getting Started with the CData Tableau Connector for Google Drive
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Google Drive.
-
Use ChatGPT to Talk to Your Redis Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Redis data for you.
-
Model, Search, and Visualize Live Databricks Data in ThoughtSpot
Use CData Connect AI to connect to live Databricks data for modeling, searching, and visualizing.
-
Automated Continuous Presto Replication to Databricks
Use CData Sync for automated, continuous, customizable Presto replication to Databricks.
-
Automated Continuous SparkPost Replication to SQL Server
Use CData Sync for automated, continuous, customizable SparkPost replication to SQL Server.
-
Integrating Cursor with Kafka 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 Live Active Directory Data in the Power BI Service
Use CData Connect AI to connect to live Active Directory data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Automated Continuous Figshare Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Figshare replication to PostgreSQL.
-
Integrate SAS xpt Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live SAS xpt data from Informatica Cloud.
-
Create Power BI Reports on Real-Time Klipfolio Data
Use the CData ODBC Driver for Klipfolio to visualize Klipfolio data in Power BI Desktop.
-
Bridge HDFS Connectivity with Apache NiFi
Access and process HDFS data in Apache NiFi using the CData JDBC Driver.
-
Visualize Live Neo4J Data in the Power BI Service
Use CData Connect AI to connect to live Neo4J data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Access Square Data from MySQL in Amazon QuickSight
Connect to Square and build visualizations of Square data using a MySQL Connection in Amazon QuickSight.
-
How to create an RPA flow for Missive Data in UiPath Studio
Use the Missive ODBC Driver to create workflows that access real-time Missive data without any coding.
-
Back Up BambooHR data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with BambooHR data data.
-
Automated Continuous Google Calendar Replication to Oracle
Use CData Sync for automated, continuous, customizable Google Calendar replication to Oracle.
-
DataBind Controls to Parquet Data in Delphi
DataBind to Parquet data in Delphi with standard data access components and controls.
-
Visualize Pingdom Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Pingdom data.
-
Bridge Discourse Connectivity with Apache NiFi
Access and process Discourse data in Apache NiFi using the CData JDBC Driver.
-
Build Visualizations of Figshare Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Figshare data in Birst.
-
Use the CData Software JDBC Driver for Azure Synapse in MicroStrategy Web
Connect to Azure Synapse data in MicroStrategy Web using the CData Software JDBC Driver for Azure Synapse.
-
Import and Visualize Smartsheet Data in Power View
Create data visualizations based on Smartsheet data in Excel.
-
Feed Act-On Data into FineReport
How to set Act-On data as a JDBC data source in FineReport.
-
Connect to Suadeo Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Suadeo data.
-
Use ChatGPT to Talk to Your Monday.com Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Monday.com data for you.
-
Moving Data from Bitbucket to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Bitbucket data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Enable the Google Sheets JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Google Sheets data.
-
Connect to Twitter Ads Data in CloverDX (formerly CloverETL)
Transfer Twitter Ads data using the visual workflow in the CloverDX data integration tool.
-
Getting Started with the CData ADO.NET Provider for GraphQL
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for GraphQL.
-
How to Connect to Live Microsoft Dataverse 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 Microsoft Dataverse data for you.
-
Integrating GitHub Copilot with Pingdom 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 Oracle Financials Cloud Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Oracle Financials Cloud data into TIBCO Spotfire.
-
Integrate Microsoft Dataverse Data in Pentaho Data Integration
Build ETL pipelines based on Microsoft Dataverse data in the Pentaho Data Integration tool.
-
Automated Databricks Data Replication to Teradata
Use CData Sync to Customize and automate Databricks data replication to Teradata.
-
Automated Continuous Oracle Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Oracle replication to IBM DB2.
-
Manage CapsuleCRM Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for CapsuleCRM.
-
Build MVC Applications with Connectivity to Shippo Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Shippo from an ASP.NET MVC application.
-
Use JayDeBeApi to access Greenplum Data in Python
Use standard Python scripting and the development environment of your choice to access live Greenplum data.
-
How to integrate SAP Fieldglass with Apache Airflow
Access and process SAP Fieldglass data in Apache Airflow using the CData JDBC Driver.
-
Connect to Zoho Books Data in HULFT Integrate
Connect to Zoho Books as a JDBC data source in HULFT Integrate
-
Analyze ZendeskSell Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze ZendeskSell data with the CData JDBC Driver for ZendeskSell.
-
Automated Continuous Workable Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Workable replication to Amazon Redshift.
-
Replicate Timely Data from PowerShell
Write a quick PowerShell script to query Timely data. Use connectivity to the live data to replicate Timely data to SQL Server.
-
Automated Continuous Cvent Replication to SQL Server
Use CData Sync for automated, continuous, customizable Cvent replication to SQL Server.
-
Use Dash to Build to Web Apps on Pipeline CRM Data
Create Python applications that use pandas and Dash to build Pipeline CRM-connected web apps.
-
Integrate Devin with Live Snapchat Ads Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Snapchat Ads data.
-
Moving Data from ScrapingBee to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live ScrapingBee data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to QuickBooks Time Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time QuickBooks Time data using standard SQL.
-
Use the CData ODBC Driver for Wave Financial in Microsoft Power Query
You can use the CData Wave Financial ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Wave Financial data into Microsoft Power Query.
-
Integrate Google's Vertex AI Agent with Live Amazon S3 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Amazon S3 data within intelligent workflows.
-
How to Connect to Front Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Front data. Leverage the pyodbc module for ODBC in Python.
-
Build Cloudant-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Cloudant Data from Zoho Analytics and import live Cloudant data.
-
Bidirectional Access to BigCommerce Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate BigCommerce data in Filemaker Pro for Mac or Windows.
-
Connect to Paymo Data in Ruby
Connect to Paymo data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automated Continuous Float Replication to Oracle
Use CData Sync for automated, continuous, customizable Float replication to Oracle.
-
Migrating data from PDFMonkey to Google BigQuery using CData SSIS Components.
Easily push PDFMonkey data to Google BigQuery using the CData SSIS Tasks for PDFMonkey and Google BigQuery.
-
Operational Reporting on Snowflake Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Snowflake data.
-
Create Data Visualizations in Cognos BI with Printify Data
Access Printify data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Moving Data from Hive to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Hive data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Validate Shortcut Data with QuerySurge
Access and validate Shortcut data in QuerySurge using the CData JDBC Driver.
-
Visualize LightSpeedRetail Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load LightSpeedRetail data into TIBCO Spotfire.
-
How to Connect to Live Sage 200 Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Sage 200 data for you.
-
Connect to Pushbullet Data from a Connection Pool in Jetty
The Pushbullet JDBC Driver supports connection pooling: This article shows how to connect faster to Pushbullet data from Web apps in Jetty.
-
DataBind Charts to Pipeline CRM Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Pipeline CRM data 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.
-
Visualize Access Data in Sisense
Create an ElastiCube in Sisense app with access to Access data.
-
Integrate Live API Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to API from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live API data.
-
Connect to ShipStation Data in Ruby
Connect to ShipStation data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automated Continuous Pipedrive Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Pipedrive replication to IBM DB2.
-
Extract, Transform, and Load AfterShip Data in Informatica PowerCenter
Create a simple Workflow for AfterShip data in Informatica PowerCenter.
-
Automated Continuous Close Replication to SQL Server
Use CData Sync for automated, continuous, customizable Close replication to SQL Server.
-
How to Connect Raisers Edge NXT Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Raisers Edge NXT data in real time using natural language.
-
Use the CData ODBC Driver for Timely in Microsoft Power Query
You can use the CData Timely ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Timely data into Microsoft Power Query.
-
Create Data Visualizations in Cognos BI with DB2 Data
Access DB2 data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Import Elasticsearch Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Elasticsearch Data and provide access to live Elasticsearch data for custom reports in the Power BI Service.
-
Integrate Supabase Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Supabase data and integrate live Supabase data into your Power Automate tasks.
-
Object-Relational Mapping (ORM) with XML 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 XML data into a Java-based ORM framework, Hibernate.
-
Access Anaplan Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Anaplan data from your Oracle system.
-
Build Agents in Relevance AI with Access to Live Highrise Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Highrise data within intelligent agent workflows.
-
Provide OData Services of Productboard Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Productboard data by developing a WCF Service Application.
-
Work with Live Xero Data in Power Query
Use CData Connect AI to connect to Xero data and work with live Xero data in Microsoft Power Query.
-
Viewing ShipEngine Data in RAD Studio Data Explorer
How to view ShipEngine data in RAD Studio Data Explorer using the CData ODBC Driver for ShipEngine.
-
Connect PhantomBuster Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your PhantomBuster data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Integrate LibreChat with Live Guru Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Guru data from within the chat interface.
-
How to Connect the Power BI Service to Pipeliner CRM: Complete Guide
Connect to the CData Software Power BI Connector for Pipeliner CRM from PowerBI.com to provide real-time Pipeliner CRM data across the organization.
-
Visualize Live Presto Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Presto data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Kafka Data from HeidiSQL
Use CData Connect AI to connect to and query live Kafka data from HeidiSQL.