CData Software - Knowledge Base
Recent Articles
-
Connect to OnePageCrm from a Connection Pool in WebLogic
Use the CData JDBC Driver for OnePageCrm to connect to OnePageCrm data from Web applications running on WebLogic.
-
Build Data Flows from SQL Server to REST through SSIS
Easily push SQL Server data to REST using the CData SSIS Tasks for REST.
-
Analyze Certinia Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Certinia data with the CData JDBC Driver for Certinia.
-
How to Connect the Power BI Service to Reply.io: Complete Guide
Connect to the CData Software Power BI Connector for Reply.io from PowerBI.com to provide real-time Reply.io data across the organization.
-
Connect to Google Cloud Storage Data in Ruby
Connect to Google Cloud Storage data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Explore Geographical Relationships in HBase Data with Power Map
Create data visualizations with HBase data in Power Map.
-
Connect to Zoho Projects Data in Jaspersoft Studio
Execute SQL to remote Zoho Projects data in Jaspersoft Studio.
-
Automated Continuous Smartsheet Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Smartsheet replication to delimited files (CSV/TSV).
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Impala
Provide connectivity to Impala data through an SAP BusinessObjects universe.
-
QuickBooks Time Reporting in OBIEE with the QuickBooks Time JDBC Driver
Deploy the QuickBooks Time JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Use Microsoft Copilot Studio to talk to your Sage 200 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Sage 200 data for you.
-
Integrate Avro with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Avro with External Services.
-
Connect to Suadeo Data in RapidMiner
Integrate Suadeo data with standard components and data source configuration wizards in RapidMiner Studio.
-
How to use SQLAlchemy ORM to access Printful Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Printful data.
-
Automated Continuous Freshsales Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Freshsales replication to PostgreSQL.
-
Integrate Perplexity Data in Pentaho Data Integration
Build ETL pipelines based on Perplexity data in the Pentaho Data Integration tool.
-
How to create Facebook federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Facebook data in MySQL .
-
Integrating Claude Code CLI with MySQL 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.
-
How to Query DB2 Data in MySQL Workbench
Execute MySQL queries against live DB2 data from MySQL Workbench.
-
Connect and Query Live Sage 200 Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Sage 200 data into Databricks and enable direct, live querying and analysis without replication.
-
Connect to SparkPost Data from HeidiSQL
Use CData Connect AI to connect to and query live SparkPost data from HeidiSQL.
-
Build a PostgreSQL Interface for Adobe Analytics Data using the CData JDBC Driver
Use the Remoting features of the Adobe Analytics JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect to Live CapsuleCRM Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your CapsuleCRM data for you.
-
Getting Started with the CData Python Connector for Webex
Learn to install and license the CData Python Connector and configure a connection to live Webex data.
-
Build SAP ByDesign-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for SAP ByDesign Data and create custom apps in Bubble.
-
How to Connect to & Open OneNote Data in Microsoft Excel
This article uses the CData ODBC driver for OneNote to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connecting Mastra with Excel Online Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Excel Online data, no replication required.
-
How to connect PolyBase to SAP Business Warehouse
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live SAP Business Warehouse data.
-
Build Dashboards with Printful Data in DBxtra
Create dynamic dashboards and perform analytics based on Printful data in DBxtra.
-
Query Zendesk Data as a SQL Server Database in Node.js
Execute SQL Server queries against Zendesk data from Node.js.
-
How to integrate Spark with Apache Airflow
Access and process Spark data in Apache Airflow using the CData JDBC Driver.
-
Access Live Telegram Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Telegram data into the statistical analysis tools available in SAS JMP. This article shows how to use Telegram data in the Graph Builder and Query Builder.
-
Connect to Grafana Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Grafana.
-
Integrate with Live Email Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Email from the MuleSoft Anypoint Platform to integrate live Email data into custom reports and dashboards.
-
Visualize SuiteCRM Data in Tableau
The CData ODBC driver for SuiteCRM enables you integrate SuiteCRM data into Tableau dashboards.
-
Integrate Real-Time Access to Oracle Financials Cloud in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Oracle Financials Cloud data in real time.
-
Integrating Boomi Agentstudio with Box Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Box data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Analyze Live Moosend Data in SAS Viya
Use CData Connect AI to connect to Moosend data from SAS Viya and deploy self-service analytics using live Moosend data.
-
How to Access MySQL Data Using Entity Framework
This article shows how to access MySQL data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Create Power BI Reports on Real-Time Oracle Financials Cloud Data
Use the CData ODBC Driver for Oracle Financials Cloud to visualize Oracle Financials Cloud data in Power BI Desktop.
-
How to Connect the Power BI Service to Oracle Eloqua: Complete Guide
Connect to the CData Software Power BI Connector for Oracle Eloqua from PowerBI.com to provide real-time Oracle Eloqua data across the organization.
-
Getting Started with the CData ODBC Driver for SAP Business One
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for SAP Business One.
-
Automated Continuous Greenhouse Replication to MongoDB
Use CData Sync for automated, continuous, customizable Greenhouse replication to MongoDB.
-
DataBind Charts to Deel Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Deel 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.
-
DataBind Facebook Ads Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Facebook Ads with the DevExpress Windows Forms and Web controls to provide Facebook Ads data to a chart.
-
Access Live Excel Online Data in TIBCO Data Virtualization
Use the Excel Online Tibco DV Adapter to create a Excel Online data data source in TIBCO Data Virtualization Studio and gain access to live Excel Online data from your TDV Server.
-
Automated Continuous ShipStation Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable ShipStation replication to Azure SQL Database.
-
Build Semantic Layer Views for Pingdom Data in APOS Live Data Gateway
Use the CData Connector for Pingdom in APOS Live Data Gateway to build Semantic Layer Views for Pingdom data.
-
Add Asana Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Asana with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to BenchmarkEmail Data in DBeaver
Use the CData ODBC Driver to connect to BenchmarkEmail data in DBeaver.
-
Analyze EmailOctopus Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze EmailOctopus data with the CData JDBC Driver for EmailOctopus.
-
Automated Continuous Mixpanel Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Mixpanel replication to Apache Kafka.
-
Integrating Claude Code CLI with Hacker News 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 Cvent Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Cvent from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to use SQLAlchemy ORM to access Datadog Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Datadog data.
-
Manage ScrapingBee Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for ScrapingBee.
-
Use Azure AI Foundry to Talk to Your SAP ByDesign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your SAP ByDesign data for you.
-
A PostgreSQL Interface for Airtable Data using the CData ODBC Driver
Use the SQL Gateway and Airtable ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Twilio Data from Crystal Reports
Use CData Connect AI to connect to and report on live Twilio data from Crystal Reports.
-
Replicate Multiple JSON Accounts via the CData Sync CLI
Replicate multiple JSON accounts to one or many databases.
-
Use Dash to Build to Web Apps on Timely Data
Create Python applications that use pandas and Dash to build Timely-connected web apps.
-
Access Zoho Inventory Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Zoho Inventory data.
-
Connect to FHIR Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for FHIR and the SQL Gateway to access FHIR data from Google Apps Script.
-
Import Bright Data Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Bright Data Data and provide access to live Bright Data data for custom reports in the Power BI Service.
-
Integrate Cursor with Live BambooHR Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live BambooHR data from within the editor.
-
How to Work with PayPal Data in ETL Validator JDBC
Connect to PayPal from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Coda Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Coda and work with Coda data in your FileMaker applications.
-
Build Exa-Connected Apps in Choreo
Use CData Connect AI to connect to Exa Data from Choreo and build custom apps using live Exa data.
-
Integrating LangGraph with Google Ad Manager Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Google Ad Manager data within automated workflows.
-
Visualize ConstantContact Data in Sisense
Create an ElastiCube in Sisense app with access to ConstantContact data.
-
Getting Started with the CData ADO.NET Provider for Salesforce
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Salesforce.
-
Interact with Live SendPulse Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live SendPulse data.
-
Use the CData ODBC Driver for Front from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Front to connect to Front data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Front data in Excel.
-
How to connect to ChartMogul Data from Spring Boot
Connect to ChartMogul in a Spring Boot Application using the CData API Driver for JDBC
-
Work with Pipedrive Data in FoxPro
Load Pipedrive data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to PDFMonkey Data in HULFT Integrate
Connect to PDFMonkey as a JDBC data source in HULFT Integrate
-
DataBind Charts to Facebook Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Facebook 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.
-
Use the CData Software JDBC Driver for SingleStore in MicroStrategy Web
Connect to SingleStore data in MicroStrategy Web using the CData Software JDBC Driver for SingleStore.
-
Import and Visualize Omnisend Data in Power View
Create data visualizations based on Omnisend data in Excel.
-
Getting Started with the CData Excel Add-In for SAP HANA XS Advanced
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for SAP HANA XS Advanced.
-
How to Connect DBeaver to Google Tasks via a JDBC Driver
Manage Google Tasks data with visual tools in DBeaver like the query browser.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for CloudConvert
Provide connectivity to CloudConvert data through an SAP BusinessObjects universe.
-
How to Use a Microsoft Access Database to Update Microsoft Ads Data in Real Time
Update Microsoft Ads data by creating a linked table in Microsoft Access with the CData Microsoft Ads ODBC Driver.
-
How to Query Beeminder Data in MySQL Workbench
Execute MySQL queries against live Beeminder data from MySQL Workbench.
-
Access Live iContact Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live iContact data through MCP integration.
-
Create Dynamic Apollo Grids Using the Infragistics XamDataGrid
Learn how you can connect Apollo to Infragistics XamDataGrid to build dynamic grids.
-
Replicate Multiple Close Accounts via the CData Sync CLI
Replicate multiple Close accounts to one or many databases.
-
Import and Visualize Box Data in Power View
Create data visualizations based on Box data in Excel.
-
Connect to JobNimbus Data from PowerBuilder via JDBC
This article demonstrates how to access JobNimbus data from PowerBuilder using the JobNimbus JDBC Driver.
-
Validate Hubstaff Data with QuerySurge
Access and validate Hubstaff data in QuerySurge using the CData JDBC Driver.
-
Planio Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Planio facts in real time.
-
Consume Sage 200 OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Sage 200 feeds that reflect any changes in SAP Lumira.
-
Build Apps with Live GitHub data in Adalo using CData Connect AI
Use CData Connect AI to integrate live GitHub data into the Adalo platform and build custom mobile and web applications with real-time GitHub data.
-
Build Visualizations of Aweber Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Aweber data in Birst.
-
Connect to Azure Data Catalog Data in RapidMiner
Integrate Azure Data Catalog data with standard components and data source configuration wizards in RapidMiner Studio.
-
Choosing the Best Method to Connect CircleCI to SQL Server: 5 Options Explained
Discover multiple ways to connect and use CircleCI data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Build PingOne Visualizations in Tableau Desktop
Use CData Connect AI to connect to live PingOne data and build visualizations in Tableau.
-
How to Query Outlook Data in MySQL Workbench
Execute MySQL queries against live Outlook data from MySQL Workbench.
-
Analyze Live Sage 200 Data in SAS Viya
Use CData Connect AI to connect to Sage 200 data from SAS Viya and deploy self-service analytics using live Sage 200 data.
-
Build Automated Grafana-Connected Workflows in Zapier
Use CData Connect AI to connect to live Grafana data and build automated workflows in Zapier.