CData Software - Knowledge Base
Recent Articles
-
Publish Superchat-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Superchat data.
-
Create Apps from Exa Data in Qlik Sense Cloud
Use CData Connect AI to connect to Exa Data and build apps from live Exa data in Qlik Sense Cloud.
-
Integrating Kiro with SAP 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 CapsuleCRM Replication to Snowflake
Use CData Sync for automated, continuous, customizable CapsuleCRM replication to Snowflake.
-
How to connect to SharePoint Data from IntelliJ
Integrate connectivity to SharePoint data with wizards in IntelliJ.
-
Connect to Sage 200 Data in Ruby
Connect to Sage 200 data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automate Epicor Kinetic Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Epicor Kinetic data from PowerShell? This article demonstrates how to utilize the Epicor Kinetic Cmdlets for tasks like connecting to Epicor Kinetic data, automating operations, downloading data, and more.
-
How to Connect Flowise AI Agents to Live HCL Domino 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 HCL Domino data without replication.
-
Moving Data from Google Sheets to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Google Sheets data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connecting Pipedream with Active Directory 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 Active Directory data in real time.
-
Prepare, Blend, and Analyze FreshBooks Data in Alteryx Designer (ODBC)
Build workflows to access live FreshBooks data for self-service data analytics.
-
Integrating LangGraph with Oracle SCM Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Oracle SCM data within automated workflows.
-
Work with Live Facebook Data in Power Query
Use CData Connect AI to connect to Facebook data and work with live Facebook data in Microsoft Power Query.
-
How to Connect to & Open Webex Data in Microsoft Excel
This article uses the CData ODBC driver for Webex to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to Close Data in RapidMiner
Integrate Close data with standard components and data source configuration wizards in RapidMiner Studio.
-
Automated Continuous Insightly Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Insightly replication to Amazon S3.
-
Load NASA Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load NASA data to a database.
-
Connect to Couchbase Data in CloverDX (formerly CloverETL)
Transfer Couchbase data using the visual workflow in the CloverDX data integration tool.
-
Connect LinkedIn to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect LinkedIn with IBM WebSphere for seamless data integration and connectivity.
-
Integrate Devin with Live Salesloft 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 Salesloft data.
-
Connect to Dynamics CRM Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Dynamics CRM Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Visualize Testmonitor 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 Testmonitor data into TIBCO Spotfire.
-
Create Certinia-Connected Business Apps in AppSheet
Connect to Certinia Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Certinia data.
-
A PostgreSQL Interface for Office 365 Data (MySQL Remoting via JDBC)
Use the Remoting features of the Office 365 JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Acumatica Data in Ruby
Connect to Acumatica data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build Semantic Layer Views for Stripe Data in APOS Live Data Gateway
Use the CData Connector for Stripe in APOS Live Data Gateway to build Semantic Layer Views for Stripe data.
-
Using the CData Software ODBC Driver for Azure Analysis Services in PyCharm
Connect to Azure Analysis Services as an ODBC data source in PyCharm using the CData Software ODBC Driver for Azure Analysis Services.
-
Integrate Live ShipEngine Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live ShipEngine data from within the IDE.
-
Use Claude to Talk to Your MailerLite 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 MailerLite data for you.
-
Build Hive-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Hive data.
-
Automated Continuous Pushbullet Replication to MySQL
Use CData Sync for automated, continuous, customizable Pushbullet replication to MySQL.
-
Automated Continuous Zoho Creator Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Zoho Creator replication to AlloyDB.
-
Automated Continuous Parallel Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Parallel replication to delimited files (CSV/TSV).
-
Connect to Zoho Creator Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Zoho Creator data in the Denodo Virtual DataPort Administrator.
-
Automated Continuous Figshare Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Figshare replication to IBM DB2.
-
How to Access Outlook Data Using Entity Framework
This article shows how to access Outlook data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Query CapsuleCRM Data through ODBC in Node.js
Use node-odbc to execute SQL queries against CapsuleCRM data from Node.js.
-
Configure the CData JDBC Driver for Facebook in a Connection Pool in Tomcat
Connect to Facebook data from a connection pool in Tomcat.
-
Integrating Codex with Freshservice 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.
-
DataBind Charts to Insightly Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Insightly 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 ODBC Driver for ClickTime from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for ClickTime to connect to ClickTime data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring ClickTime data in Excel.
-
Build Dashboards with Klaviyo Data in Dundas BI
Create dynamic dashboards and perform analytics based on Klaviyo data in Dundas BI.
-
How to create an RPA flow for SAP Concur Data in UiPath Studio
Use the SAP Concur ODBC Driver to create workflows that access real-time SAP Concur data without any coding.
-
View Reports on Real-Time Strava Data in Power BI Report Server
Use the CData ODBC Driver for Strava to visualize Strava data in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrate Live Sybase Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Sybase data and integrate live Sybase data into apps built in Microsoft Power Apps.
-
Replicate Multiple Simplesat Accounts via the CData Sync CLI
Replicate multiple Simplesat accounts to one or many databases.
-
Build Automated Workflows with Live Redis Data in Workato
Use CData Connect AI to connect to live Redis data and build automated workflows in Workato.
-
Create Data Visualizations in Cognos BI with TigerGraph Data
Access TigerGraph data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to Connect DBeaver to LinkedIn Ads via a JDBC Driver
Manage LinkedIn Ads data with visual tools in DBeaver like the query browser.
-
Integrating LangChain with Omnisend Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Omnisend data within automated workflows.
-
Build Voice Agents in ElevenLabs with access to Live PolarTeamPro Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live PolarTeamPro data.
-
How to integrate Bullhorn CRM with Apache Airflow
Access and process Bullhorn CRM data in Apache Airflow using the CData JDBC Driver.
-
ETL Cohere in Oracle Data Integrator
This article shows how to transfer Cohere data into a data warehouse using Oracle Data Integrator.
-
Build Visualizations of Google Analytics Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Google Analytics data in Birst.
-
Connect to Microsoft OneDrive Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Microsoft OneDrive data from Filemaker Pro on Mac.
-
Natively Connect to Shortcut Data in PHP
The CData ODBC driver for Shortcut enables you to create PHP applications with connectivity to Shortcut data. Leverage the native support for ODBC in PHP.
-
Easily Integrate Gmail Data in Lazarus Pascal IDE
Learn how to easily integrate live Gmail data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Build Semantic Layer Views for Vault CRM Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Vault CRM data.
-
Connect to ZohoDesk Data in Aqua Data Studio
Access ZohoDesk data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Visualize Instagram Data in TIBCO Spotfire through OData
Integrate Instagram data into dashboards in TIBCO Spotfire.
-
Connect to ZohoExpense 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 ZohoExpense and work with ZohoExpense data in your FileMaker application.
-
How to Connect to NetSuite Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to NetSuite data. Leverage the pyodbc module for ODBC in Python.
-
Analyze Redis Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Redis data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Connect Zoho Projects to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Zoho Projects data using the CData Python MCP Server.
-
Automated Continuous Discord Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Discord replication to Google BigQuery.
-
Automated Continuous Smartsheet Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Smartsheet replication to Google Cloud SQL.
-
How to Query Live Google Ads Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Google Ads data data in natural language using Python.
-
Build a Simple VCL Application for Pingdom Data
How to build a simple VCL Application to view Pingdom data in RAD Studio using the CData ODBC Driver for Pingdom.
-
How to Visualize Zoho CRM Data in Python with pandas
Use pandas and other modules to analyze and visualize live Zoho CRM data in Python.
-
View Reports on Real-Time Greenplum Data in Power BI Report Server
Use the CData ODBC Driver for Greenplum to visualize Greenplum data in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrating LangGraph with Dropbox Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Dropbox data within automated workflows.
-
Build MVC Applications with Connectivity to xBase Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access xBase from an ASP.NET MVC application.
-
Use Dash to Build Web Apps on Kafka Data via CData Connect AI
Build interactive Dash web apps on live Kafka data using pandas and the CData Connect AI Python SDK.
-
Automate Amazon Marketplace Data Replication to Azure Synapse
Use CData Sync to customize and automate Amazon Marketplace data replication to Azure Synapse.
-
Integrating Claude Code with Freshdesk Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Freshdesk data within assisted coding and automated development workflows.
-
Connect and Query Live Cloudant Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Cloudant data into Databricks and enable direct, live querying and analysis without replication.
-
Visualize CapsuleCRM Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to CapsuleCRM data.
-
How to Connect to Certinia Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Certinia data. Leverage the pyodbc module for ODBC in Python.
-
Access Flowlu Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Flowlu data from your Oracle system.
-
Connect to Smartsheet Data from PowerBuilder via ADO.NET
This article demonstrates how to access Smartsheet data from Appeon PowerBuilder using the CData ADO.NET Provider for Smartsheet.
-
Use Databricks Agent Bricks to Talk to Your SurveyMonkey Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your SurveyMonkey data for you.
-
Connect to Printify Data from AWS Glue
Use CData Connect AI to gain access to live Printify data from your AWS Glue jobs.
-
Publish Crystal Reports on Flowlu Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Flowlu data.
-
Integrate Google's Antigravity Agent with Live SAP Ariba Source Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live SAP Ariba Source data using the Model Context Protocol.
-
Access Live Basecamp Data in AWS Lambda
Connect to live Basecamp data in AWS Lambda using the CData JDBC Driver.
-
Connect to Billsby Data in Jaspersoft Studio
Execute SQL to remote Billsby data in Jaspersoft Studio.
-
Connect to Datadog Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Datadog and work with Datadog data in your FileMaker applications.
-
Access Live Grafana Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Grafana data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Query Adobe Analytics Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Adobe Analytics entities in PHP by modeling them as objects.
-
Rapidly Develop Google Tasks-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Google Tasks.
-
Connect to Real-Time Google Search Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Google Search and Dataflow to import and use Google Search results in Power Apps.
-
Connect to Vault CRM Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Vault CRM Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Publish Opsgenie-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Opsgenie data.
-
Create Dynamic Factorial Grids Using the Infragistics XamDataGrid
Learn how you can connect Factorial to Infragistics XamDataGrid to build dynamic grids.
-
Create SSAS Tabular Models from Google Spanner Data
How to build a SQL Server Analysis Service Tabular Model from Google Spanner data using CData drivers.
-
Connect to Bugsnag Data from a Connection Pool in Jetty
The Bugsnag JDBC Driver supports connection pooling: This article shows how to connect faster to Bugsnag data from Web apps in Jetty.
-
Provide OData Services of Tanda Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Tanda data by developing a WCF Service Application.
-
Access CloudConvert 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 CloudConvert data.
-
Connect Avaza to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Avaza with IBM WebSphere for seamless data integration and connectivity.
-
Build Pipelines with Live ZohoInvoice Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to ZohoInvoice from Google Cloud Data Fusion, enabling the integration of live ZohoInvoice data into the building and management of effective data pipelines.