CData Software - Knowledge Base
Recent Articles
-
How to Connect DBeaver to MySQL via a JDBC Driver
Manage MySQL data with visual tools in DBeaver like the query browser.
-
Getting Started with the CData Python Connector for Office 365
Learn to install and license the CData Python Connector and configure a connection to live Office 365 data.
-
Connect to Authorize.Net Data in HULFT Integrate
Connect to Authorize.Net as a JDBC data source in HULFT Integrate
-
Visualize Mailjet 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 Mailjet data into TIBCO Spotfire.
-
Connect to SendPulse Data in Ruby
Connect to SendPulse data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Use the CData ODBC Driver for Tavily in Microsoft Power Query
You can use the CData Tavily ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Tavily data into Microsoft Power Query.
-
How to Create Power BI Visual Reports with Real-Time Trello Data
Use CData Power BI Connectors to visualize Trello data in Power BI.
-
Access Live Bitly Data in AWS Lambda
Connect to live Bitly data in AWS Lambda using the CData JDBC Driver.
-
Create SAP Ariba Procurement-Connected Dashboards in Grafana
Connect to SAP Ariba Procurement Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to SAP Ariba Procurement data.
-
Connect to Azure DevOps Data from a Connection Pool in JBoss
Integrate Azure DevOps data into Java servlets: Use the Management Console in JBoss to install the Azure DevOps JDBC Driver.
-
Publish ADP-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live ADP data.
-
Use the CData Software JDBC Driver for ClickUp in MicroStrategy Web
Connect to ClickUp data in MicroStrategy Web using the CData Software JDBC Driver for ClickUp.
-
How to Create Power BI Visual Reports with Real-Time Neo4J Data
Use CData Power BI Connectors to visualize Neo4J data in Power BI.
-
View Reports on Real-Time Tally Data in Power BI Report Server
Use the CData ODBC Driver for Tally to visualize Tally data in Power BI Desktop and then publish them to Power BI Report Server.
-
Use the CData ODBC Driver for Twilio in Microsoft Power Query
You can use the CData Twilio ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Twilio data into Microsoft Power Query.
-
Integrate with Live MarkLogic Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to MarkLogic from the MuleSoft Anypoint Platform to integrate live MarkLogic data into custom reports and dashboards.
-
Build Semantic Layer Views for Zoho Inventory Data in APOS Live Data Gateway
Use the CData Connector for Zoho Inventory in APOS Live Data Gateway to build Semantic Layer Views for Zoho Inventory data.
-
Connect to Oracle Service Cloud Data in Aqua Data Studio
Access Oracle Service Cloud data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Automated Continuous CouchDB Replication to Vertica
Use CData Sync for automated, continuous, customizable CouchDB replication to Vertica.
-
Back Up SurveyMonkey data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for SurveyMonkey. In this article, we will employ an SSIS workflow to populate a database with SurveyMonkey data data.
-
Connect to Zoho Inventory Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Zoho Inventory Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Excel Spreadsheet Automation on SAP ByDesign Data with the QUERY Formula
Pull data from SAP ByDesign, automate spreadsheets, and more with the QUERY formula.
-
Automated Continuous Outlook Replication to SQLite
Use CData Sync for automated, continuous, customizable Outlook replication to SQLite.
-
Connecting Mastra with AlloyDB 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 AlloyDB data, no replication required.
-
Automated Continuous Microsoft Teams Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Microsoft Teams replication to Amazon Redshift.
-
Connect Nuclia to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Nuclia with IBM WebSphere for seamless data integration and connectivity.
-
Connect to Highrise from Asprova with CData Software ODBC Driver for Highrise
This article shows how to connect faster to Highrise data from Asprova.
-
Use the CData ODBC Driver for Google Search in Microsoft Power Query
You can use the CData Google Search ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Google Search results into Microsoft Power Query.
-
How to connect to Google Translate Data from IntelliJ
Integrate connectivity to Google Translate data with wizards in IntelliJ.
-
Automated Continuous Shopify Replication to MySQL
Use CData Sync for automated, continuous, customizable Shopify replication to MySQL.
-
Connect IBM Cloud Object Storage to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live IBM Cloud Object Storage data using the CData Python MCP Server.
-
Integrate with Microsoft Teams Data in JReport Designer
Create charts and reports based on Microsoft Teams data in JReport Designer.
-
Query Datadog Data as a MySQL Database in Node.js
Execute MySQL queries against Datadog data from Node.js.
-
Working with Drip Data in LINQPad
Execute LINQ queries to Drip data in LINQPad.
-
How to work with Okta Data in Apache Spark using SQL
Access and process Okta Data in Apache Spark using the CData Software JDBC Driver.
-
How to Connect to Live SAP HANA XS Advanced Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your SAP HANA XS Advanced data for you.
-
Getting Started with the CData Tableau Connector for Dropbox
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Dropbox.
-
Create Dynamic Perigon Grids Using the Infragistics XamDataGrid
Learn how you can connect Perigon to Infragistics XamDataGrid to build dynamic grids.
-
Integrate Cline with Live Acumatica Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Acumatica data from within your IDE.
-
Connect MailChimp to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect MailChimp with IBM WebSphere for seamless data integration and connectivity.
-
Integrate SparkPost Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to SparkPost data and integrate live SparkPost data into your Power Automate tasks.
-
Import Real-Time Strava Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Strava data in ColdFusion.
-
Connect to and Query Figshare Data in QlikView over ODBC
Create data visualizations with Figshare data in QlikView.
-
Replicate SAP Business One Data in Heroku for Use in Salesforce Connect
Replicate SAP Business One data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Build AI Agents with Google Cloud Storage 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 Google Cloud Storage data through CData Connect AI.
-
Integrate Google's Antigravity Agent with Live EnterpriseDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live EnterpriseDB data using the Model Context Protocol.
-
Integrate Clari Data in Pentaho Data Integration
Build ETL pipelines based on Clari data in the Pentaho Data Integration tool.
-
Automated Continuous AlloyDB Replication to MySQL
Use CData Sync for automated, continuous, customizable AlloyDB replication to MySQL.
-
Query Tally Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Tally entities in PHP by modeling them as objects.
-
How to integrate Azure Data Lake Storage with Apache Airflow
Access and process Azure Data Lake Storage data in Apache Airflow using the CData JDBC Driver.
-
How to create Certinia federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Certinia data in MySQL .
-
Use the CData Software JDBC Driver for Smartsheet in MicroStrategy Web
Connect to Smartsheet data in MicroStrategy Web using the CData Software JDBC Driver for Smartsheet.
-
Import Real-Time Avaza Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Avaza data in ColdFusion.
-
Query Paddle Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Paddle data from Node.js.
-
Connect to FormSite Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to FormSite and work with FormSite data in your FileMaker application.
-
Connect to Real-Time Postmark Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Postmark data in Power Apps.
-
Enable the Simplesat JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Simplesat data.
-
DataBind Controls to SAP ByDesign Data in C++Builder
DataBind to SAP ByDesign data in C++Builder with standard components and controls.
-
Replicate MailerLite Data to Multiple Databases via the CData Sync CLI
Replicate MailerLite data to disparate databases with a single configuration.
-
Connect to Timely in SpagoBI
Create reports featuring live Timely data in SpagoBI Studio. Host Timely reports on SpagoBI Server.
-
How to Work with Intercom Data in ETL Validator JDBC
Connect to Intercom from ETL Validator jobs using the CData Software JDBC Driver.
-
Automated Continuous LinkedIn Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable LinkedIn replication to Google Cloud SQL.
-
Import Real-Time SAP SuccessFactors Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use SAP SuccessFactors data in ColdFusion.
-
Access Live SendGrid Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live SendGrid data from your Excel spreadsheets.
-
Query Close Data as a MySQL Database in Node.js
Execute MySQL queries against Close data from Node.js.
-
Access Live Instagram Data in Excel 365 Online (Excel for the web)
Connect to Instagram data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Automated Continuous QuickBooks Online Replication to Vertica
Use CData Sync for automated, continuous, customizable QuickBooks Online replication to Vertica.
-
Working with Presto Data in LINQPad
Execute LINQ queries to Presto data in LINQPad.
-
Build AI/ML Models with Live Salesforce CRM Analytics Data using Dataiku
Connect Salesforce CRM Analytics Data with Dataiku using the CData JDBC Driver for Salesforce CRM Analytics.
-
Connect to and Visualize Live Nethunt Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Nethunt data.
-
Automated Continuous Helpscout Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Helpscout replication to Azure SQL Database.
-
Connect to Office 365 Data in RapidMiner
Integrate Office 365 data with standard components and data source configuration wizards in RapidMiner Studio.
-
Connecting Pipedream with GetResponse Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on GetResponse data in real time.
-
Build Zoho CRM-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Zoho CRM data and build Zoho CRM-connected web apps with Axios.
-
Automated Continuous Cosmos DB Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Cosmos DB replication to Apache Cassandra.
-
Visualize Pinterest Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Pinterest data.
-
Connect to Oracle SCM Data in Claris FileMaker Pro
Use the CData ODBC Driver for Oracle SCM in FileMaker Pro to connect to Oracle SCM and work with Oracle SCM data in your FileMaker applications.
-
Integrating OpenCode with Pinecone 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.
-
Process & Analyze Harvest Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Harvest Data.
-
Create SageHR Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time SageHR data access from reports, embedded analytics, and more.
-
Connect to xBase from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from xBase data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Create Shippo-Connected Applications in Appsmith
Connect to Shippo Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Shippo data.
-
Connect to Live ClickUp Data in PostGresSQL Interface through CData Connect AI
Create a live connection to ClickUp in CData Connect AI and connect to your ClickUp data from PostgreSQL.
-
Access Live NetSuite 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 NetSuite data through MCP integration.
-
Connect to ZohoDesk Data in DBArtisan
Use wizards in DBArtisan to configure ZohoDesk data as a data source.
-
How to Access Egnyte Data Using Entity Framework
This article shows how to access Egnyte data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Build Semantic Layer Views for Google Contacts Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Google Contacts data.
-
Integrating Codex with CircleCI 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 create Sendwithus federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Sendwithus data in MySQL .
-
Query, Visualize, and Share live SAS Data Sets Data in Redash
Use CData Connect AI to connect to live SAS Data Sets data in Redash for querying, visualizing, and sharing.
-
Integrate Live Instagram Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Instagram data and integrate live Instagram data into apps built in Microsoft Power Apps.
-
Choosing the Best Method to Connect PhantomBuster to SQL Server: 5 Options Explained
Discover multiple ways to connect and use PhantomBuster data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Provide OData Services of Google Ads Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Google Ads data by developing a WCF Service Application.
-
Query Live GitLab Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live GitLab data directly from the development environment.
-
Connect to Copper from Asprova with CData Software ODBC Driver for Copper
This article shows how to connect faster to Copper data from Asprova.
-
How to Access Live Databricks Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Databricks enables you to integrate Databricks data into workflows built using Microsoft Power Automate Desktop.
-
Extract, Transform, and Load SendInBlue Data in Informatica PowerCenter
Create a simple Workflow for SendInBlue data in Informatica PowerCenter.
-
Query FHIR Data in DataGrip
Create a Data Source for FHIR in DataGrip and use SQL to query live FHIR data.
-
Query WordPress Data as a MySQL Database in Node.js
Execute MySQL queries against WordPress data from Node.js.
-
Automated Continuous Microsoft Entra ID Replication to MongoDB
Use CData Sync for automated, continuous, customizable Microsoft Entra ID replication to MongoDB.