CData Software - Knowledge Base
Recent Articles
-
Automated Continuous SuiteCRM Replication to MongoDB
Use CData Sync for automated, continuous, customizable SuiteCRM replication to MongoDB.
-
Build Short.io-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Short.io.
-
Access Live Float Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Float in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Replicate Multiple Sugar CRM Accounts via the CData Sync CLI
Replicate multiple Sugar CRM accounts to one or many databases.
-
How to create Visio diagrams from GitHub Data
Automatically update GitHub with the changes you make to Visio master shapes.
-
Create Informatica Mappings From/To a JDBC Data Source for TigerGraph
Create TigerGraph data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to Keap from a Connection Pool in WebLogic
Use the CData JDBC Driver for Keap to connect to Keap from Web applications running on WebLogic.
-
How to Access Live Teamgate Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Teamgate enables you to integrate Teamgate into workflows built using Microsoft Power Automate Desktop.
-
Build Visualizations of BigQuery Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Google BigQuery in Birst.
-
DataBind Controls to Demio Data in Delphi
DataBind to Demio in Delphi with standard data access components and controls.
-
How to Connect to & Open Dropbox Data in Microsoft Excel
This article uses the CData ODBC driver for Dropbox to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Enable the ClickUp JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with ClickUp.
-
Analyze LaunchDarkly Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze LaunchDarkly with the CData JDBC Driver for LaunchDarkly.
-
Build Dashboards with SAS xpt Data in Dundas BI
Create dynamic dashboards and perform analytics based on SAS XPORT in Dundas BI.
-
Visualize SharePoint Excel Services Data in Sisense
Create an ElastiCube in Sisense app with access to SharePoint Excel Services.
-
Build MVC Applications with Connectivity to Pinecone Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Pinecone from an ASP.NET MVC application.
-
Integrate Open WebUI with Live CouchDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Apache CouchDB from within the chat interface.
-
Connect to Google Search Results from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Google Search to connect to Google Search and execute queries in PowerBuilder.
-
Integrate with live Freshdesk Data in Jitterbit
Use CData Connect AI to connect to and integrate live Freshdesk in Jitterbit.
-
How to connect to Wistia Data from IntelliJ
Integrate connectivity to Wistia with wizards in IntelliJ.
-
Natively Connect to Salesforce Data 360 Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Salesforce Data 360. Leverage the native support for ODBC in PHP.
-
Automate Toggl Data Replication to Azure Synapse
Use CData Sync to customize and automate Toggl replication to Azure Synapse.
-
Analyze Pipedrive Data in Looker
Use CData Connect AI to connect to Pipedrive Data from Looker and build custom apps using live Pipedrive.
-
Connect to Xero Data from a Connection Pool in JBoss
Integrate Xero Accounting into Java servlets: Use the Management Console in JBoss to install the Xero JDBC Driver.
-
Connect to Live Salesforce Pardot Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Salesforce Pardot in CData Connect AI and connect to your Salesforce Pardot from PostgreSQL.
-
Trigger Sugar CRM IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Sugar CRM with standard wizards in Logic Apps.
-
Build Charts with AgileCRM Data in Clear Analytics
Create dynamic charts and perform analytics based on AgileCRM in Clear Analytics.
-
Use JayDeBeApi to access SharePoint Excel Services Data in Python
Use standard Python scripting and the development environment of your choice to access live SharePoint Excel Services.
-
Connect Clari to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Clari using the CData Python MCP Server.
-
How to Connect the Power BI Service to Wistia: Complete Guide
Connect to the CData Software Power BI Connector for Wistia from PowerBI.com to provide real-time Wistia across the organization.
-
How to Connect to Live Zoho Books 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 Zoho Books for you.
-
Integrate with BambooHR Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy BambooHR to a JSON file on disk.
-
Connect to TigerGraph Data in CloverDX (formerly CloverETL)
Transfer TigerGraph using the visual workflow in the CloverDX data integration tool.
-
How to Query Live Basecamp Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Basecamp data in natural language using Python.
-
Connect to OpenWeatherMap Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to OpenWeatherMap and work with OpenWeatherMap in your FileMaker applications.
-
How to Seamlessly Import Wistia Data into IBM SPSS Modeler
Integrate Wistia data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
View Reports on Real-Time Zoho Projects Data in Power BI Report Server
Use the CData ODBC Driver for Zoho Projects to visualize Zoho Projects in Power BI Desktop and then publish them to Power BI Report Server.
-
Automated Continuous Nethunt Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Nethunt replication to AlloyDB.
-
How to Query Live SAP HANA XS Advanced Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live SAP HANA XS Advanced data in natural language using Python.
-
How to Connect the Power BI Service to Neo4J: Complete Guide
Connect to the CData Software Power BI Connector for Neo4J from PowerBI.com to provide real-time Neo4J across the organization.
-
Connect to and Query SAS xpt Data in QlikView over ODBC
Create data visualizations with SAS XPORT in QlikView.
-
Extend Google Sheets with WooCommerce Data
Make calls to WooCommerce from Google Apps Script via the API Server.
-
Access Live Retently Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Retently in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to Authorize.Net Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Authorize.Net and the SQL Gateway to access Authorize.Net from Google Apps Script.
-
Build a PostgreSQL Interface for SingleStore Data using the CData JDBC Driver
Use the Remoting features of the SingleStore JDBC Driver to create a PostgreSQL entry-point for data access.
-
Choosing the Best Method to Connect Mode to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Mode from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Build Dashboards with Jodoo Data in DBxtra
Create dynamic dashboards and perform analytics based on Jodoo in DBxtra.
-
Connect to Live Google Directory Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Google Directory in CData Connect AI and connect to your Google Directory from PostgreSQL.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed SAP Ariba Source to Power BI dashboards. Simply drag and drop SAP Ariba Source into data visuals on the Power BI canvas.
-
Connect to QuickBooks Time Data in JRuby
Create a simple JRuby app with access to live QuickBooks Time.
-
How to integrate HCL Domino with Apache Airflow
Access and process HCL Domino in Apache Airflow using the CData JDBC Driver.
-
Connect to Google Search Results in Aqua Data Studio
Access Google Search from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Provide OData Services of Acumatica Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Acumatica ERP by developing a WCF Service Application.
-
Import Sugar CRM Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Sugar CRM. In this article, you will use the OData format to import Sugar CRM into Microsoft Power Query.
-
Connect to Real-Time BenchmarkEmail Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use BenchmarkEmail in Power Apps.
-
Connect to SingleStore from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from SingleStore, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Access Live Zendesk 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 Zendesk through MCP integration.
-
Build a Simple VCL Application for Pipeliner CRM Data
How to build a simple VCL Application to view Pipeliner CRM in RAD Studio using the CData ODBC Driver for Pipeliner CRM.
-
Analyze Azure Data Catalog Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Azure Data Catalog and visualize live Azure Data Catalog in Infragistics Reveal.
-
Build Hacker News-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Hacker News.
-
Publish Adobe Experience Manager-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Adobe Experience Manager.
-
How to Query Onfleet Data in MySQL Workbench
Execute MySQL queries against live Onfleet from MySQL Workbench.
-
Connect to SuiteCRM from Asprova with CData Software ODBC Driver for SuiteCRM
This article shows how to connect faster to SuiteCRM data from Asprova.
-
Stream Perplexity Data into Apache Kafka Topics
Access and stream Perplexity in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrating Antigravity CLI with Microsoft OneDrive via CData CLI
Connect Microsoft OneDrive to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Visualize Apify Data in Tableau
The CData ODBC driver for Apify enables you integrate Apify into Tableau dashboards.
-
Integrating Kiro CLI with SQL Analysis Services 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 ByDesign Data (MySQL Remoting via JDBC)
Use the Remoting features of the SAP ByDesign JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to SendPulse 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 SendPulse and work with SendPulse in your FileMaker application.
-
Connect to Instantly Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Instantly using standard SQL.
-
Use Agno to Talk to Your MarkLogic Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your MarkLogic for you.
-
Analyze Discord Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Discord in Microsoft R Open.
-
Use the CData Software ODBC Driver for Pingdom in MicroStrategy
Connect to Pingdom in MicroStrategy Developer using the CData Software ODBC Driver for Pingdom.
-
Build Marketo Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Marketo and build visualizations in Tableau.
-
Use Databricks Agent Bricks to Talk to Your AlloyDB Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Google AlloyDB for you.
-
Connect to GitHub Data from HeidiSQL
Use CData Connect AI to connect to and query live GitHub from HeidiSQL.
-
Templated Reporting in OBIEE with the Templated JDBC Driver
Deploy the Templated JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to Slack Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Publish SQL Analysis Services-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live SQL Analysis Services.
-
Access Azure Data Catalog Data from MySQL in Amazon QuickSight
Connect to Azure Data Catalog and build visualizations of Azure Data Catalog using a MySQL Connection in Amazon QuickSight.
-
How to publish and share HBase Data dashboards with Tableau Server
The CData ODBC driver for HBase enables you integrate Apache HBase into Tableau dashboards.
-
How to integrate Unbounce with Apache Airflow
Access and process Unbounce in Apache Airflow using the CData JDBC Driver.
-
Replicate Multiple Todoist Accounts
Replicate multiple Todoist accounts to one or many databases.
-
Integrate Zoho Inventory Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Zoho Inventory from Informatica Cloud.
-
Build NetSuite SuiteAnalytics-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for NetSuite SuiteAnalytics Data and create custom apps in Mendix.
-
Publish Coda-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Coda.
-
Connect to HelloSign Data in RazorSQL
Connect to HelloSign from wizards and query HelloSign from the GUI in the RazorSQL database management tool.
-
Load CockroachDB Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load CockroachDB to a database.
-
How to Connect to Live Vertica 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 Vertica through natural language.
-
Connect to SAP Hybris C4C Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for SAP Hybris C4C and the Script function in FileMaker Pro to connect to SAP Hybris C4C and work with SAP Hybris C4C in your FileMaker application.
-
Integrating Antigravity CLI with Workday via CData CLI
Connect Workday to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
A Comparison of Drivers for Elasticsearch
In this article, we compare the read performance and resource usage of the CData Software JDBC Driver for Elasticsearch with the native JDBC Driver.
-
Getting Started with the CData Power BI Connector for Teradata
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Teradata.
-
Replicate Multiple Couchbase Accounts via the CData Sync CLI
Replicate multiple Couchbase accounts to one or many databases.
-
Analyze Wrike Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Wrike in Microsoft R Open.
-
Automated Continuous Vertica Replication to MySQL
Use CData Sync for automated, continuous, customizable Vertica replication to MySQL.
-
Connect to and Visualize Live Facebook Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Facebook.
-
Create a Data Access Object for SQL Server Data using JDBI
A brief overview of creating a SQL Object API for Microsoft SQL Server in JDBI.
-
How to Query Live SharePoint Data in Perplexity MacOS Desktop
Connect to and query live SharePoint Data in Perplexity Desktop using CData MCP Server.
-
DataBind Controls to Oracle Sales Data in C++Builder
DataBind to Oracle Sales in C++Builder with standard components and controls.