CData Software - Knowledge Base
Recent Articles
-
Create Teradata-Connected Nintex Workflows
Use CData Connect AI to connect to Teradata Data from Nintex Workflow Cloud and build custom workflows using live Teradata data.
-
Access Live Discourse Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Discourse data into the statistical analysis tools available in SAS JMP. This article shows how to use Discourse data in the Graph Builder and Query Builder.
-
Build Pipelines with Live Box Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Box from Google Cloud Data Fusion, enabling the integration of live Box data into the building and management of effective data pipelines.
-
Bidirectional Access to Outreach.io Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Outreach.io data in Filemaker Pro for Mac or Windows.
-
Establish a Live Connection with Mistral AI Data using Tableau Bridge
The CData ODBC Driver for Mistral AI enables you to integrate live Mistral AI data into Tableau Cloud dashboards using the Tableau Bridge.
-
Access Live SAP Concur Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate SAP Concur data into the statistical analysis tools available in SAS JMP. This article shows how to use SAP Concur data in the Graph Builder and Query Builder.
-
How to Connect to Live Google Contacts 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 Google Contacts data for you.
-
Process & Analyze Google Calendar Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Google Calendar Data.
-
Enable the Pipeliner CRM JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Pipeliner CRM data.
-
Create Kafka-Connected Dashboards in Grafana
Connect to Kafka Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Kafka data.
-
Create ZohoInvoice Dataflows on PowerBI.com
Connect to the CData Power BI Connector for ZohoInvoice from PowerBI.com to create Power BI Dataflows with real-time data.
-
Getting Started with the CData Python Connector for ZeroBounce
Learn to install and license the CData Python Connector and configure a connection to live ZeroBounce data.
-
Query Oracle Eloqua Reporting Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Oracle Eloqua Reporting entities in PHP by modeling them as objects.
-
How to Access Sage Intacct Data Using Entity Framework
This article shows how to access Sage Intacct data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to work with Twilio Data in Apache Spark using SQL
Access and process Twilio Data in Apache Spark using the CData Software JDBC Driver.
-
Automated Continuous Avaza Replication to SQL Server
Use CData Sync for automated, continuous, customizable Avaza replication to SQL Server.
-
Using the CData Software ODBC Driver for Exa in PyCharm
Connect to Exa as an ODBC data source in PyCharm using the CData Software ODBC Driver for Exa.
-
Build PingOne-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live PingOne data and build PingOne-connected web apps with Axios.
-
Create Data Visualizations in Cognos BI with ShipEngine Data
Access ShipEngine data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to MongoDB Data in JRuby
Create a simple JRuby app with access to live MongoDB data.
-
Build Data Flows from Acumatica to SQL Server using SSIS
Easily back up Acumatica data to SQL Server using the SSIS components for Acumatica.
-
Access HDFS Data from MySQL in PHP
Connect to HDFS through the standard MySQL libraries in PHP.
-
Create MailChimp Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time MailChimp data access from reports, embedded analytics, and more.
-
Integrate with Coinbase Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Coinbase data to a JSON file on disk.
-
How to Easily Query Greenhouse Data in OpenOffice Base
Connect to Greenhouse data in OpenOffice Base using the CData ODBC Driver for Greenhouse and generate reports with live data insights.
-
How to Create Power BI Visual Reports with Real-Time Klipfolio Data
Use CData Power BI Connectors to visualize Klipfolio data in Power BI.
-
Import SharePoint Data Using Azure Data Factory
Use CData Connect AI to connect to SharePoint Data from Azure Data Factory and import live SharePoint data.
-
Analyze Sybase IQ Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Sybase IQ data and visualize Sybase IQ data in SAP Analytics Cloud.
-
Connect to Microsoft Planner Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Microsoft Planner Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Create Datasets from Excel Online in Domo Workbench and Build Visualizations of Excel Online Data in Domo
Use the CData Software ODBC Driver for Excel Online to create datasets from Excel Online data in Domo Workbench and then build visualizations in the Domo service.
-
Integrating OpenCode with SendGrid 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.
-
Deploy the ADO.NET Provider for WordPress on an SSRS Report Server
Connect to WordPress data from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Analyze Pipedrive Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Pipedrive from Power Pivot. You will use the Table Import Wizard to load Pipedrive data. You can visually build the import query or use any SQL supported by the driver.
-
Connect to Adobe Commerce Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Adobe Commerce data.
-
How to create SAP Hybris C4C federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for SAP Hybris C4C data in MySQL .
-
How to Access SageHR Data Using Entity Framework
This article shows how to access SageHR data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Create Dynamic ClickUp Grids Using the Infragistics XamDataGrid
Learn how you can connect ClickUp to Infragistics XamDataGrid to build dynamic grids.
-
Integrating Dataiku with Bright Data Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Bright Data data.
-
Search External Adobe Target Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Adobe Target data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Adobe Target Data objects that you can access from apps and the dashboard.
-
Build Twitter Ads-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Twitter Ads Data and create custom apps in Mendix.
-
Getting Started with the CData Excel Add-In for SpaceX
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for SpaceX.
-
Build AI/ML Models with Live LinkedIn Data using Dataiku
Connect LinkedIn Data with Dataiku using the CData JDBC Driver for LinkedIn.
-
Connect to BenchmarkEmail Data from HeidiSQL
Use CData Connect AI to connect to and query live BenchmarkEmail data from HeidiSQL.
-
Automated Continuous QuickBooks Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable QuickBooks replication to Google BigQuery.
-
Connect to Bitbucket Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Bitbucket.
-
Use JayDeBeApi to access BambooHR Data in Python
Use standard Python scripting and the development environment of your choice to access live BambooHR data.
-
Automated Continuous Slack Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Slack replication to Apache Kafka.
-
Integrating Claude Code CLI with GitLab 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 with Avalara AvaTax 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.
-
Link GraphQL with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate GraphQL data in Filemaker Pro for Mac or Windows.
-
How to update CockroachDB from Excel
This article explains how to transfer data from Excel to CockroachDB using the Excel Add-In for CockroachDB.
-
Publish Reports with Teamgate Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Teamgate data.
-
Build Oracle-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Oracle data without replication.
-
Use Claude to Talk to Your Google Directory Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Google Directory data for you.
-
Integrate LibreChat with Live Greenhouse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Greenhouse data from within the chat interface.
-
Replicate ConvertKit Data in Heroku for Use in Salesforce Connect
Replicate ConvertKit data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to Connect to Samanage Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Samanage data. Leverage the pyodbc module for ODBC in Python.
-
Replicate Multiple Mixpanel Accounts
Replicate multiple Mixpanel accounts to one or many databases.
-
Visualize Live Google Sheets Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Google Sheets data into custom reports in Power BI.
-
How to Connect to Live Stripe Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Stripe data through natural language.
-
Use Biml to Build SSIS Tasks to Replicate Workday Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Workday data to SQL Server.
-
Create Reports from BigCommerce Data in Looker Studio
Use CData Connect AI to gain access to live BigCommerce data and create custom reports in Looker Studio.
-
Configure the CData JDBC Driver for Coda in a Connection Pool in Tomcat
Connect to Coda data from a connection pool in Tomcat.
-
Integrate Smartsheet Data into Power Automate Desktop using CData Connect
CData Connect for Smartsheet Data enables you to integrate Smartsheet data into workflows built using Microsoft Power Automate Desktop.
-
How to Access Live SFTP Data in Power Automate Desktop via ODBC
The CData ODBC Driver for SFTP enables you to integrate SFTP data into workflows built using Microsoft Power Automate Desktop.
-
Model SAP Ariba Procurement Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and SAP Ariba Procurement, enabling the direct import of real-time SAP Ariba Procurement data.
-
Working with ZohoSubscriptions Data in LINQPad
Execute LINQ queries to ZohoSubscriptions data in LINQPad.
-
Working with Exa Data in LINQPad
Execute LINQ queries to Exa data in LINQPad.
-
Getting Started with the CData SSIS Components for Quickbase
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Quickbase.
-
Integrate Dify with Live Sage Cloud Accounting Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Sage Cloud Accounting data.
-
Integrate LibreChat with Live Amazon Marketplace Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Amazon Marketplace data from within the chat interface.
-
Integrate with Spark Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Spark data in SnapLogic.
-
How to work with Quickbase Data in Apache Spark using SQL
Access and process Quickbase Data in Apache Spark using the CData Software JDBC Driver.
-
Build Azure DevOps-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Azure DevOps data.
-
Seamlessly Bring SAS Data Sets Data into Retool Using CData Connect AI
Integrate SAS Data Sets data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Automate Airtable Data Replication to Azure Data Lake
Use CData Sync to customize and automate Airtable data replication to Azure Data Lake.
-
How to connect SharePoint with Acumatica Data through external lists
Provide Acumatica data to SharePoint users as an external list.
-
Build Apps with Live Exa Data Using the Low-Code Development Platform of Mendix
Connect Exa data with Mendix to build apps using the CData API Driver for JDBC.
-
Automated Continuous Excel Online Replication to MySQL
Use CData Sync for automated, continuous, customizable Excel Online replication to MySQL.
-
Create Exa Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Exa data access from reports, embedded analytics, and more.
-
Integrate with Live Klaviyo Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Klaviyo from the MuleSoft Anypoint Platform to integrate live Klaviyo data into custom reports and dashboards.
-
Use the CData Software JDBC Driver for Google Search in MicroStrategy
Connect to Google Search results in MicroStrategy Developer using the CData Software JDBC Driver for Google Search.
-
Access Live Jodoo Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Jodoo data into the statistical analysis tools available in SAS JMP. This article shows how to use Jodoo data in the Graph Builder and Query Builder.
-
Natively Connect to SAP SuccessFactors Data in PHP
The CData ODBC driver for SAP SuccessFactors enables you to create PHP applications with connectivity to SAP SuccessFactors data. Leverage the native support for ODBC in PHP.
-
How to Connect DBeaver to ChartMogul via a JDBC Driver
Manage ChartMogul data with visual tools in DBeaver like the query browser.
-
Use the CData Software ODBC Driver for Twilio in MicroStrategy Web
Connect to Twilio data in MicroStrategy Web using the CData Software ODBC Driver for Twilio.
-
Create Apps from ZohoMarketingHub Data in Qlik Sense Cloud
Use CData Connect AI to connect to ZohoMarketingHub Data and build apps from live ZohoMarketingHub data in Qlik Sense Cloud.
-
Build Data Flows from MariaDB to SQL Server using SSIS
Easily back up MariaDB data to SQL Server using the SSIS components for MariaDB.
-
Automated Continuous Pipeliner CRM Replication to MySQL
Use CData Sync for automated, continuous, customizable Pipeliner CRM replication to MySQL.
-
Seamlessly Bring Bullhorn CRM Data into Retool Using CData Connect AI
Integrate Bullhorn CRM data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Automated Continuous Certinia Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Certinia replication to delimited files (CSV/TSV).
-
Connect to WordPress Data in RapidMiner
Integrate WordPress data with standard components and data source configuration wizards in RapidMiner Studio.
-
Power BI XMLA Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Power BI XMLA data through CData Connect AI using different applications and tools.
-
Create ZohoExpense-Connected Nintex Workflows
Use CData Connect AI to connect to ZohoExpense Data from Nintex Workflow Cloud and build custom workflows using live ZohoExpense data.
-
Use the CData Software ODBC Driver for Hive in MicroStrategy Desktop
Connect to Hive data in MicroStrategy Desktop using the CData Software ODBC Driver for Hive.
-
Automated Continuous Placid Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Placid replication to PostgreSQL.
-
Getting Started with the CData Tableau Connector for Opsgenie
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for FTP
Provide connectivity to FTP data through an SAP BusinessObjects universe.
-
Create Power BI Reports on Real-Time Gong Data
Use the CData ODBC Driver for Gong to visualize Gong data in Power BI Desktop.
-
Create GetResponse Dataflows on PowerBI.com
Connect to the CData Power BI Connector for GetResponse from PowerBI.com to create Power BI Dataflows with real-time data.