CData Software - Knowledge Base
Recent Articles
-
Integrating GitHub Copilot with JotForm 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 Connect the Power BI Service to WordPress: Complete Guide
Connect to the CData Software Power BI Connector for WordPress from PowerBI.com to provide real-time WordPress data across the organization.
-
Visualize Live Missive Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Missive data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Visualize Live BigCommerce Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live BigCommerce data into custom reports in Power BI.
-
Access Live Greenplum Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Greenplum data from your Excel spreadsheets.
-
Visualize Live Monday.com Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Monday.com data into custom reports in Power BI.
-
Use Biml to Build SSIS Tasks to Replicate Cloudflare Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Cloudflare data to SQL Server.
-
Build SAP-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to SAP data and build web apps with connectivity to live SAP data.
-
How to Work with Azure DevOps Data in ETL Validator JDBC
Connect to Azure DevOps from ETL Validator jobs using the CData Software JDBC Driver.
-
Getting Started with the CData Excel Add-In for SAS xpt
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for SAS xpt.
-
Integrate with Live SAS xpt Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to SAS xpt from the MuleSoft Anypoint Platform to integrate live SAS xpt data into custom reports and dashboards.
-
Publish Reports with Outreach.io Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Outreach.io data.
-
Create Reports from SAP Netweaver Gateway Data in Looker Studio
Use CData Connect AI to gain access to live SAP Netweaver Gateway data and create custom reports in Looker Studio.
-
Connect to Live Paylocity Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Paylocity in CData Connect AI and connect to your Paylocity data from PostgreSQL.
-
A PostgreSQL Interface for Marketo Data using the CData ODBC Driver
Use the SQL Gateway and Marketo ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to HCL Domino from a Connection Pool in WebLogic
Use the CData JDBC Driver for HCL Domino to connect to HCL Domino data from Web applications running on WebLogic.
-
Use Dash to Build Web Apps on PolarTeamPro Data via CData Connect AI
Build interactive Dash web apps on live PolarTeamPro data using pandas and the CData Connect AI Python SDK.
-
Connect to Placid Data from a Connection Pool in Jetty
The Placid JDBC Driver supports connection pooling: This article shows how to connect faster to Placid data from Web apps in Jetty.
-
Connect to Real-Time Jodoo Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Jodoo data in Power Apps.
-
DataBind Controls to Vercel Data in Delphi
DataBind to Vercel data in Delphi with standard data access components and controls.
-
Connect to Sendwithus Data in DBArtisan
Use wizards in DBArtisan to configure Sendwithus data as a data source.
-
Connect to Salesforce Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Salesforce data in the Denodo Virtual DataPort Administrator.
-
Use CData Connect AI to Access Zoho Projects Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Zoho Projects data in the Power Pivot business intelligence tool.
-
Automated Continuous Oracle Financials Cloud Replication to MySQL
Use CData Sync for automated, continuous, customizable Oracle Financials Cloud replication to MySQL.
-
Connect to Redis Data from a Connection Pool in JBoss
Integrate Redis data into Java servlets: Use the Management Console in JBoss to install the Redis JDBC Driver.
-
Create ScrapingBee Dataflows on PowerBI.com
Connect to the CData Power BI Connector for ScrapingBee from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to Procore Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Procore data in the Denodo Virtual DataPort Administrator.
-
How to Use a Microsoft Access Database to Update Freshdesk Data in Real Time
Update Freshdesk data by creating a linked table in Microsoft Access with the CData Freshdesk ODBC Driver.
-
How to Connect SendPulse 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 SendPulse data in real time using natural language.
-
Connect to Wistia Data in RapidMiner
Integrate Wistia data with standard components and data source configuration wizards in RapidMiner Studio.
-
Analyze Live Teradata Data in SAS Viya
Use CData Connect AI to connect to Teradata data from SAS Viya and deploy self-service analytics using live Teradata data.
-
Integrating Claude Code CLI with Google Cloud Storage 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.
-
Automated Continuous LeadDesk Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable LeadDesk replication to PostgreSQL.
-
Databind Wijmo Grid to Salesforce.com Data
Use the CData API Server to add a Wijmo grid containing live Salesforce.com data to your website. The same process to access live data can be followed with any of the 80+ other supported sources.
-
ETL Aha! in Oracle Data Integrator
This article shows how to transfer Aha! data into a data warehouse using Oracle Data Integrator.
-
Build MVC Applications with Connectivity to Apify Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Apify from an ASP.NET MVC application.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Slack
Provide connectivity to Slack data through an SAP BusinessObjects universe.
-
Integrating Claude Code CLI with Pipeliner CRM 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 and Visualize Live AlloyDB Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live AlloyDB data into the Databricks platform and create visualization dashboards with real-time AlloyDB data.
-
How to create an RPA flow for MarkLogic Data in UiPath Studio
Use the MarkLogic ODBC Driver to create workflows that access real-time MarkLogic data without any coding.
-
Build Dashboards with FHIR Data in Dundas BI
Create dynamic dashboards and perform analytics based on FHIR data in Dundas BI.
-
Create Informatica Mappings From/To a JDBC Data Source for Auth0
Create Auth0 data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Import Real-Time Sentry Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Sentry data in ColdFusion.
-
Connect to Splunk Data in Claris FileMaker Pro
Use the CData ODBC Driver for Splunk in FileMaker Pro to connect to Splunk and work with Splunk data in your FileMaker applications.
-
How to Visualize Tanda Data in Python with pandas
Use pandas and other modules to analyze and visualize live Tanda data in Python.
-
Replicate Multiple Figshare Accounts
Replicate multiple Figshare accounts to one or many databases.
-
Use Grok to Talk to Your Raisers Edge NXT 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 Raisers Edge NXT data for you.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Testmonitor
Provide connectivity to Testmonitor data through an SAP BusinessObjects universe.
-
Query MailerLite Data as a MySQL Database in Node.js
Execute MySQL queries against MailerLite data from Node.js.
-
Integrate Live Jodoo Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Jodoo data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Choosing the Best Method to Connect Facebook Ads to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Facebook Ads data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Create Reports from iContact Data in Looker Studio
Use CData Connect AI to gain access to live iContact data and create custom reports in Looker Studio.
-
How to Connect to & Open Adobe Target Data in Microsoft Excel
This article uses the CData ODBC driver for Adobe Target to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Create OData Services with the Salesforce Data Provider
This article shows how to publish an OData feed of Saleforce data by creating a WCF Service Application. This article uses the ADO.NET Provider for Salesforce, but the same steps will work for any of the CData ADO.NET Providers.
-
Creating Salesforce Marketing-Connected Applications in Unqork
You can use CData Connect AI to feed Salesforce Marketing data to Unqork and build custom business apps.
-
Create Bitbucket-Connected Nintex Workflows
Use CData Connect AI to connect to Bitbucket Data from Nintex Workflow Cloud and build custom workflows using live Bitbucket data.
-
How to connect to Cvent Data in DBVisualizer
Integrate Cvent data with visual data analysis tools and data connection wizards in DBVisualizer
-
Create Reports with Rootly Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Rootly data.
-
Build Voice Agents in ElevenLabs with access to Live Redshift Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Redshift data.
-
Getting Started with the CData Power BI Connector for FTP
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for FTP.
-
Connect to HBase Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for HBase and the SQL Gateway to access HBase data from Google Apps Script.
-
Choosing the Best Method to Connect Chargebee to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Chargebee data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Using the CData Software ODBC Driver for DocuSign in PyCharm
Connect to DocuSign as an ODBC data source in PyCharm using the CData Software ODBC Driver for DocuSign.
-
Publish SendInBlue-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live SendInBlue data.
-
DataBind Controls to Adobe Experience Manager Data in C++Builder
DataBind to Adobe Experience Manager data in C++Builder with standard components and controls.
-
Replicate Multiple Asana Accounts
Replicate multiple Asana accounts to one or many databases.
-
Access iContact Data from MySQL in PHP
Connect to iContact through the standard MySQL libraries in PHP.
-
How to Access Kafka Data Using Entity Framework
This article shows how to access Kafka data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Build AI/ML Models with Live MailerLite Data using Dataiku
Connect MailerLite Data with Dataiku using the CData API Driver for JDBC.
-
Build Mode-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Mode data and build web apps with connectivity to live Mode data.
-
Create Discourse Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Discourse data access from reports, embedded analytics, and more.
-
Prepare, Blend, and Analyze XML Data in Alteryx Designer (ODBC)
Build workflows to access live XML data for self-service data analytics.
-
How to connect and process eBay Analytics data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live eBay Analytics data.
-
Create Datasets from Monday.com in Domo Workbench and Build Visualizations of Monday.com Data in Domo
Use the CData Software ODBC Driver for Monday.com to create datasets from Monday.com data in Domo Workbench and then build visualizations in the Domo service.
-
How to Access BigQuery Data Using Entity Framework
This article shows how to access BigQuery data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Import Real-Time Pushbullet Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Pushbullet data in ColdFusion.
-
Add LaunchDarkly Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for LaunchDarkly with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to Mailgun Data in DBeaver
Use the CData ODBC Driver to connect to Mailgun data in DBeaver.
-
Use Databricks Agent Bricks to Talk to Your Google Drive Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Google Drive data for you.
-
Automate Impala Data Replication to Couchbase
Use CData Sync to Customize and automate Impala data replication to Couchbase.
-
Automated Continuous SAP Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable SAP replication to Amazon Redshift.
-
Access Live GetResponse 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 GetResponse data through MCP integration.
-
Link Cohere with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Cohere data in Filemaker Pro for Mac or Windows.
-
Build SparkPost Visualizations in Tableau Cloud
Use CData Connect AI to connect to live SparkPost data and build visualizations in Tableau Cloud.
-
Excel Spreadsheet Automation on Shippo Data with the QUERY Formula
Pull data from Shippo, automate spreadsheets, and more with the QUERY formula.
-
Connecting GenSpark with Bannerbear Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Bannerbear data without any replication or custom integration required.
-
Connect to PabblySubscriptions Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to PabblySubscriptions and work with PabblySubscriptions data in your FileMaker applications.
-
How to connect to Dynamics 365 Business Central Data from Spring Boot
Connect to Dynamics 365 Business Central in a Spring Boot Application using the CData JDBC Driver for Dynamics 365 Business Central
-
Connect to Missive Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Missive and work with Missive data in your FileMaker applications.
-
Visualize Templated Data in Tableau
The CData ODBC driver for Templated enables you integrate Templated data into Tableau dashboards.
-
Build Voice Agents in ElevenLabs with access to Live Salesforce Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Salesforce data.
-
Connecting Moonlit Workflow with Salesforce Pardot 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 Salesforce Pardot data in real time.
-
Automated Continuous Yelp Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Yelp replication to Apache Cassandra.
-
Moving Data from SuiteCRM to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live SuiteCRM data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect RabbitMQ to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect RabbitMQ with IBM WebSphere for seamless data integration and connectivity.
-
How to Connect Flowise AI Agents to Live OneNote Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live OneNote data without replication.
-
Build Automated Oracle Sales-Connected Workflows in Zapier
Use CData Connect AI to connect to live Oracle Sales data and build automated workflows in Zapier.
-
Analyze Bitbucket Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Bitbucket data in Microsoft R Open.
-
How to Query Redshift Data in MySQL Workbench
Execute MySQL queries against live Redshift data from MySQL Workbench.
-
Import Real-Time Pipeliner CRM Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Pipeliner CRM data in ColdFusion.