CData Software - Knowledge Base
Recent Articles
-
Connecting Mastra with HubDB 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 HubDB data, no replication required.
-
Use the CData Software ODBC Driver for Sage Intacct in MicroStrategy Desktop
Connect to Sage Intacct data in MicroStrategy Desktop using the CData Software ODBC Driver for Sage Intacct.
-
Connect to Azure Table Data in NetBeans
Connect to Azure Table data in NetBeans with the data source configuration wizard.
-
How to Build an ETL App for ZohoExpense Data in Python with CData Connect AI
Extract and transform live ZohoExpense data in Python with petl and the CData Connect AI Python SDK.
-
View Reports on Real-Time SAP Business One Data in Power BI Report Server
Use the CData ODBC Driver for SAP Business One to visualize SAP Business One data in Power BI Desktop and then publish them to Power BI Report Server.
-
How to Access PDFMonkey Data Using Entity Framework
This article shows how to access PDFMonkey data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Prepare, Blend, and Analyze JSON Services in Alteryx Designer (Connect AI)
Build workflows to access live JSON services for self-service data analytics.
-
Integrate Live TigerGraph Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live TigerGraph data to Blue Prism using the CData ODBC Driver for TigerGraph to create automated workflows for repetitive business tasks.
-
Publish Reports with Freshteam Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Freshteam data.
-
Integrate Goose with Live Tavily Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Tavily data from within the local AI agent.
-
Create Reports with Asana Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Asana data.
-
Visualize Invoiced Data in Sisense
Create an ElastiCube in Sisense app with access to Invoiced data.
-
Connect to Real-Time Mouseflow Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Mouseflow data in Power Apps.
-
How to Connect to Live Oracle SCM 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 Oracle SCM data for you.
-
Automated Continuous Recurly Replication to Snowflake
Use CData Sync for automated, continuous, customizable Recurly replication to Snowflake.
-
Access Toggl Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Toggl data from your Oracle system.
-
Connect to Ontraport Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Ontraport data.
-
How to import Freshservice Data into Apache Solr
Use the CData Software JDBC Driver for Freshservice in Data Import Handler and create an automated import of Freshservice data to Apache Solr Enterprise Search platform.
-
Analyze Omnisend Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Omnisend from Power Pivot. You will use the Table Import Wizard to load Omnisend data. You can visually build the import query or use any SQL supported by the driver.
-
Access Live Float Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Float data into the statistical analysis tools available in SAS JMP. This article shows how to use Float data in the Graph Builder and Query Builder.
-
Connect and Query Live ShipEngine Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live ShipEngine data into Databricks and enable direct, live querying and analysis without replication.
-
Integrate Kintone Data in Pentaho Data Integration
Build ETL pipelines based on Kintone data in the Pentaho Data Integration tool.
-
How to load PagerDuty data into Elasticsearch via Logstash
Introducing a simple method to load PagerDuty data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Build Pipelines with Live SendGrid Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to SendGrid from Google Cloud Data Fusion, enabling the integration of live SendGrid data into the building and management of effective data pipelines.
-
Build Zoho Creator-Connected Apps in Choreo
Use CData Connect AI to connect to Zoho Creator Data from Choreo and build custom apps using live Zoho Creator data.
-
Query Live Egnyte Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Egnyte data through a conversational interface.
-
How to Create Power BI Visual Reports with Real-Time Sybase Data
Use CData Power BI Connectors to visualize Sybase data in Power BI.
-
Connect to Confluence Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Confluence data in Airbyte.
-
How to connect to Keap Data with Squirrel SQL client
Connect to Keap data and execute queries in the Squirrel SQL Client.
-
How to Connect to Live SendPulse Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live SendPulse data securely in real time.
-
Analyze HBase Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of HBase data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Build Apps with Live ZohoSubscriptions Data Using the Low-Code Development Platform of Mendix
Connect ZohoSubscriptions data with Mendix to build apps using the CData API Driver for JDBC.
-
Connect to LinkedIn Data from a Connection Pool in Jetty
The LinkedIn JDBC Driver supports connection pooling: This article shows how to connect faster to LinkedIn data from Web apps in Jetty.
-
Integrate Gmail Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Gmail data from Informatica Cloud.
-
Visualize Live Printful Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Printful data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build Xero-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Xero data.
-
Connect to Reckon Data in DBArtisan
Use wizards in DBArtisan to configure Reckon data as a data source.
-
Use JayDeBeApi to access Vault CRM Data in Python
Use standard Python scripting and the development environment of your choice to access live Vault CRM data.
-
Connect to Microsoft Teams Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Microsoft Teams and the Script function in FileMaker Pro to connect to Microsoft Teams and work with Microsoft Teams data in your FileMaker application.
-
Build AI Agents with GitLab 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 GitLab data through CData Connect AI.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for GitLab
Provide connectivity to GitLab data through an SAP BusinessObjects universe.
-
How to work with Planio Data in Apache Spark using SQL
Access and process Planio Data in Apache Spark using the CData Software JDBC Driver.
-
Access Live Guru Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Guru data through MCP integration.
-
Publish Intercom-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Intercom data.
-
Use Microsoft Copilot Studio to talk to your Grafana 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 Grafana data for you.
-
ETL Aircall in Oracle Data Integrator
This article shows how to transfer Aircall data into a data warehouse using Oracle Data Integrator.
-
Publish ZohoInvoice-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live ZohoInvoice data.
-
Integrating OpenCode with Access 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.
-
A PostgreSQL Interface for SAP Business Warehouse Data using the CData ODBC Driver
Use the SQL Gateway and SAP Business Warehouse ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to JSON Services in Claris FileMaker Pro
Use the CData ODBC Driver for JSON in FileMaker Pro to connect to JSON and work with JSON services in your FileMaker applications.
-
Build Apps with Live ZohoMarketingHub Data Using the Low-Code Development Platform of Mendix
Connect ZohoMarketingHub data with Mendix to build apps using the CData API Driver for JDBC.
-
Connect to Spark Data from a Connection Pool in Jetty
The Spark JDBC Driver supports connection pooling: This article shows how to connect faster to Spark data from Web apps in Jetty.
-
Automated Continuous OData Replication to IBM DB2
Use CData Sync for automated, continuous, customizable OData replication to IBM DB2.
-
Integrate Zoho Recruit Data in the Pentaho Report Designer
Publish reports based on Zoho Recruit data in the Pentaho BI tool.
-
Build Certinia-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Certinia data and build Certinia-connected web apps with Axios.
-
Integrating GitHub Copilot with Act 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.
-
How to Connect to Live Google Spanner 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 Google Spanner data for you.
-
Connect to Moosend Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Moosend data.
-
How to Query Live Samanage Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Samanage data data in natural language using Python.
-
Access Live ZohoInvoice Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live ZohoInvoice data from your Excel spreadsheets.
-
How to load JDBC-ODBC Bridge data into Elasticsearch via Logstash
Introducing a simple method to load JDBC-ODBC Bridge data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to QuickBooks Time Data in RazorSQL
Connect to QuickBooks Time from wizards and query QuickBooks Time data from the GUI in the RazorSQL database management tool.
-
Create Greenhouse-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Greenhouse Data from Klipfolio and build custom visualizations using live Greenhouse data.
-
Back Up Recurly data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Recurly data data.
-
Explore Geographical Relationships in Short.io Data with Power Map
Create data visualizations with Short.io data in Power Map.
-
Import and Visualize Square Data in Power View
Create data visualizations based on Square data in Excel.
-
Load SAP SuccessFactors LMS Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load SAP SuccessFactors LMS data to a database.
-
Use Manus AI to Talk to Your OData Services via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on OData services.
-
Connect to SAP Business One Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with SAP Business One Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Connect to Helpscout Data in Ruby
Connect to Helpscout data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Replicate Opsgenie Data to Multiple Databases
Replicate Opsgenie data to disparate databases with a point-and-click configuration.
-
Automated Continuous Landbot Replication to Databricks
Use CData Sync for automated, continuous, customizable Landbot replication to Databricks.
-
Model iContact Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and iContact, enabling the direct import of real-time iContact data.
-
Integrating GitHub Copilot with Wistia 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.
-
Use Claude to Talk to Your Sybase 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 Sybase data for you.
-
How to Access OpenWeatherMap Data Using Entity Framework
This article shows how to access OpenWeatherMap data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to SQL Analysis Services Data from HeidiSQL
Use CData Connect AI to connect to and query live SQL Analysis Services data from HeidiSQL.
-
Query SharePoint Data as a MySQL Database in Node.js
Execute MySQL queries against SharePoint data from Node.js.
-
Automate Typeform Data Replication to Azure Synapse
Use CData Sync to customize and automate Typeform data replication to Azure Synapse.
-
DataBind Controls to HCL Domino Data in Delphi
DataBind to HCL Domino data in Delphi with standard data access components and controls.
-
Create Informatica Mappings From/To a JDBC Data Source for Dynamics CRM
Create Dynamics CRM data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to SAP Fieldglass Data from AWS Glue
Use CData Connect AI to gain access to live SAP Fieldglass data from your AWS Glue jobs.
-
How to Connect to Live SAP ByDesign Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live SAP ByDesign data securely in real time.
-
Analyze Live Salesforce Data in SAS Viya
Use CData Connect AI to connect to Salesforce data from SAS Viya and deploy self-service analytics using live Salesforce data.
-
Connect JotForm Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your JotForm data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Getting Started with the CData ODBC Driver for Greenhouse
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Greenhouse.
-
Natively Connect to Zoho Projects Data in PHP
The CData ODBC driver for Zoho Projects enables you to create PHP applications with connectivity to Zoho Projects data. Leverage the native support for ODBC in PHP.
-
Connect to Excel Data in Jaspersoft Studio
Execute SQL to remote Excel data in Jaspersoft Studio.
-
Analyze Amazon DynamoDB Data in Looker
Use CData Connect AI to connect to Amazon DynamoDB Data from Looker and build custom apps using live Amazon DynamoDB data.
-
Automated Continuous Jodoo Replication to Oracle
Use CData Sync for automated, continuous, customizable Jodoo replication to Oracle.
-
How to Connect the Power BI Service to Excel: Complete Guide
Connect to the CData Software Power BI Connector for Excel from PowerBI.com to provide real-time Excel data across the organization.
-
Integrate Cursor with Live Basecamp Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Basecamp data from within the editor.
-
Build a PostgreSQL Interface for Adobe Commerce Data using the CData JDBC Driver
Use the Remoting features of the Adobe Commerce JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating OpenCode with Placid 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 Live Ontraport Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Ontraport data data in natural language using Python.
-
Create Dynamic Aircall Grids Using the Infragistics XamDataGrid
Learn how you can connect Aircall to Infragistics XamDataGrid to build dynamic grids.
-
Replicate Multiple Box Accounts
Replicate multiple Box accounts to one or many databases.
-
Connect to Bullhorn CRM Data from PowerBuilder via ADO.NET
This article demonstrates how to access Bullhorn CRM data from Appeon PowerBuilder using the CData ADO.NET Provider for Bullhorn CRM.
-
Access Live Sybase Data in AWS Lambda
Connect to live Sybase data in AWS Lambda using the CData JDBC Driver.
-
Build a PostgreSQL Interface for JSON Services using the CData JDBC Driver
Use the Remoting features of the JSON JDBC Driver to create a PostgreSQL entry-point for data access.