CData Software - Knowledge Base
Recent Articles
-
Integrate Open WebUI with Live Zoho Books Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Zoho Books data from within the chat interface.
-
Operational Reporting on Sugar CRM Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Sugar CRM data.
-
Visualize eBay Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to eBay data.
-
Analyze Act-On Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Act-On data and visualize Act-On data in SAP Analytics Cloud.
-
Visualize Salesforce CRM Analytics Data in Tableau
The CData ODBC driver for Salesforce CRM Analytics enables you integrate Salesforce CRM Analytics data into Tableau dashboards.
-
Connect and Visualize Live Cosmos DB Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Cosmos DB data into the Databricks platform and create visualization dashboards with real-time Cosmos DB data.
-
Create a Data Access Object for Google Analytics Data using JDBI
A brief overview of creating a SQL Object API for Google Analytics data in JDBI.
-
Connect to SAP BusinessObjects BI from a Connection Pool in WebLogic
Use the CData JDBC Driver for SAP BusinessObjects BI to connect to SAP BusinessObjects BI data from Web applications running on WebLogic.
-
Replicate Bitbucket Data to Multiple Databases
Replicate Bitbucket data to disparate databases with a point-and-click configuration.
-
Use Grok to Talk to Your JSON Services via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your JSON services for you.
-
Manage Acumatica Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Acumatica.
-
Natively Connect to Google Tasks Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Google Tasks data. Leverage the native support for ODBC in PHP.
-
Integrating LangGraph with Active Directory Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Active Directory data within automated workflows.
-
Create a Data Access Object for MessageBird Data using JDBI
A brief overview of creating a SQL Object API for MessageBird data in JDBI.
-
Getting Started with the CData Connect AI Python SDK for Adobe Commerce
Install the CData Connect AI Python SDK to read and write live Adobe Commerce data with standard DB-API 2.0 Python code.
-
Analyze Airtable Data in Looker
Use CData Connect AI to connect to Airtable Data from Looker and build custom apps using live Airtable data.
-
Integrate Neo4J with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Neo4J with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Neo4J data.
-
How to connect Amazon QuickSight to Cloudant Data
Create a connection to Cloudant data in CData Connect AI and insert Cloudant data into Amazon QuickSight SPICE to build interactive dashboards.
-
Create SSAS Tabular Models from Twilio Data
How to build a SQL Server Analysis Service Tabular Model from Twilio data using CData drivers.
-
Create Dashboards and Visualize Live AgileCRM Data in Geckoboard
Use CData Connect AI to connect to live AgileCRM data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Getting Started with the CData Python Connector for FreshBooks
Learn to install and license the CData Python Connector and configure a connection to live FreshBooks data.
-
Integrate SAP SuccessFactors Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live SAP SuccessFactors data from Informatica Cloud.
-
Automated Continuous ZohoSubscriptions Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable ZohoSubscriptions replication to Amazon Redshift.
-
Connect to CampaignMonitor Data from PowerBuilder via ADO.NET
This article demonstrates how to access CampaignMonitor data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Connect to Cohere Data from a Connection Pool in Jetty
The Cohere JDBC Driver supports connection pooling: This article shows how to connect faster to Cohere data from Web apps in Jetty.
-
Access Live Power BI XMLA Data in Excel 365 Online (Excel for the web)
Connect to Power BI XMLA data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Bridge DB2 Connectivity with Apache NiFi
Access and process DB2 data in Apache NiFi using the CData JDBC Driver.
-
Analyze Pipeliner CRM Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Pipeliner CRM data in Microsoft R Open.
-
Automated Continuous Lakebase Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Lakebase replication to Google BigQuery.
-
Automated Continuous Oracle Service Cloud Replication to Vertica
Use CData Sync for automated, continuous, customizable Oracle Service Cloud replication to Vertica.
-
Automated Continuous AgileCRM Replication to Amazon S3
Use CData Sync for automated, continuous, customizable AgileCRM replication to Amazon S3.
-
How to Query SendPulse Data in MySQL Workbench
Execute MySQL queries against live SendPulse data from MySQL Workbench.
-
Bridge Browserless Connectivity with Apache NiFi
Access and process Browserless data in Apache NiFi using the CData JDBC Driver.
-
Connect to Impala Data in Ruby
Connect to Impala data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automated Continuous MailerSend Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable MailerSend replication to Apache Kafka.
-
Connect to Avalara AvaTax Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Avalara AvaTax to connect to Avalara AvaTax data and execute queries in PowerBuilder.
-
How to connect Amazon QuickSight to BigCommerce Data
Create a connection to BigCommerce data in CData Connect AI and insert BigCommerce data into Amazon QuickSight SPICE to build interactive dashboards.
-
Visualize Eventbrite 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 Eventbrite data into TIBCO Spotfire.
-
Deploy the ADO.NET Provider for Campaigner on an SSRS Report Server
Connect to Campaigner 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.
-
How to Work with Greenhouse Data in AWS Glue Jobs Using JDBC
Connect to Greenhouse from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automated Continuous Typeform Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Typeform replication to AlloyDB.
-
Integrating LlamaIndex with Snapchat Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Snapchat Ads data in real time.
-
Analyze QuickBooks Time Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of QuickBooks Time data and visualize live QuickBooks Time data in Infragistics Reveal.
-
Integrating Boomi Agentstudio with ZohoMarketingHub Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to ZohoMarketingHub data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Automated Continuous Factorial Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Factorial replication to AlloyDB.
-
Integrating Claude Code CLI with Salesforce Data 360 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.
-
Access Live Spotify Data in Coginiti Pro
Connect to and query live Spotify data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Analyze CSV Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of CSV data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Use the CData ODBC Driver for Zoho Inventory in Microsoft Power Query
You can use the CData Zoho Inventory ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Zoho Inventory data into Microsoft Power Query.
-
Manage Act CRM Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Act CRM.
-
Replicate Adobe Analytics Data to Multiple Databases via the CData Sync CLI
Replicate Adobe Analytics data to disparate databases with a single configuration.
-
Use Dash to Build to Web Apps on Instagram Data
Create Python applications that use pandas and Dash to build Instagram-connected web apps.
-
How to Address ‘Token has been expired or revoked.’ Errors When Using OAuth 2.0 grant_type=refresh_token with Google Cloud Platform
How to troubleshoot and resolve “Token has been expired or revoked” errors when using OAuth 2.0 grant_type=refresh_token in GCP, with recommended best practices.
-
Use the CData Software JDBC Driver for Postmark in MicroStrategy Web
Connect to Postmark data in MicroStrategy Web using the CData Software JDBC Driver for Postmark.
-
Build Agents in Relevance AI with Access to Live Aweber Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Aweber data within intelligent agent workflows.
-
Building Dynamic Web Pages with Salesforce Pardot Data Using AngularJS
Create single-page applications with live connectivity to Salesforce Pardot using the CData API Server.
-
Connect to ChartMogul Data in NetBeans
Connect to ChartMogul data in NetBeans with the data source configuration wizard.
-
Automated Continuous PhantomBuster Replication to AlloyDB
Use CData Sync for automated, continuous, customizable PhantomBuster replication to AlloyDB.
-
Manage Vercel Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Vercel.
-
How to use SQLAlchemy ORM to access SAP HANA XS Advanced Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of SAP HANA XS Advanced data.
-
Access Live Typeform Data in Coginiti Pro
Connect to and query live Typeform data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connecting Moonlit Workflow with QuickBooks Online Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your QuickBooks Online data in real time.
-
Build Klaviyo-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Klaviyo data and build Klaviyo-connected web apps with Axios.
-
Connect to Trello Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Trello data from Filemaker Pro on Mac.
-
Excel Spreadsheet Automation on Anaplan Data with the QUERY Formula
Pull data from Anaplan, automate spreadsheets, and more with the QUERY formula.
-
Connect to Guru Data in Google Apps Script via Connect AI
Use CData Connect AI to access Guru data in Google Apps Script.
-
Use Biml to Build SSIS Tasks to Replicate ZohoMarketingHub Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate ZohoMarketingHub data to SQL Server.
-
How to work with Bullhorn CRM Data in Apache Spark using SQL
Access and process Bullhorn CRM Data in Apache Spark using the CData Software JDBC Driver.
-
Query Anaplan Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Anaplan entities in PHP by modeling them as objects.
-
Access Live Hive Data in TIBCO Data Virtualization
Use the Hive Tibco DV Adapter to create a Hive data data source in TIBCO Data Virtualization Studio and gain access to live Hive data from your TDV Server.
-
Integrating Guru Data in Talend Cloud Data Management Platform
Connect Guru Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Access Wrike Data from MySQL in Amazon QuickSight
Connect to Wrike and build visualizations of Wrike data using a MySQL Connection in Amazon QuickSight.
-
Automated Continuous ShipEngine Replication to Amazon S3
Use CData Sync for automated, continuous, customizable ShipEngine replication to Amazon S3.
-
Bidirectional Access to SuiteCRM Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate SuiteCRM data in Filemaker Pro for Mac or Windows.
-
A PostgreSQL Interface for Pipeline CRM Data (MySQL Remoting via JDBC)
Use the Remoting features of the Pipeline CRM JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use Dash to Build to Web Apps on Google Analytics Data
Create Python applications that use pandas and Dash to build Google Analytics-connected web apps.
-
Use Biml to Build SSIS Tasks to Replicate CircleCI Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate CircleCI data to SQL Server.
-
Getting Started with the CData ODBC Driver for Opsgenie
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Opsgenie.
-
Create Reports from API Data in Looker Studio
Use CData Connect AI to gain access to live API data and create custom reports in Looker Studio.
-
Build MVC Applications with Connectivity to Zoho Inventory Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Zoho Inventory from an ASP.NET MVC application.
-
Connect to HubSpot from Asprova with CData Software ODBC Driver for HubSpot
This article shows how to connect faster to HubSpot data from Asprova.
-
Deploy the ADO.NET Provider for HubSpot on an SSRS Report Server
Connect to HubSpot 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.
-
Integrate Live Mailjet Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Mailjet data and integrate live Mailjet data into apps built in Microsoft Power Apps.
-
Visualize Hacker News Data in Sisense
Create an ElastiCube in Sisense app with access to Hacker News data.
-
Access Twitter Ads Data from MySQL in PHP
Connect to Twitter Ads through the standard MySQL libraries in PHP.
-
Automated Continuous GitLab Replication to Amazon S3
Use CData Sync for automated, continuous, customizable GitLab replication to Amazon S3.
-
Stream Sugar CRM Data into Apache Kafka Topics
Access and stream Sugar CRM data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to OnePageCrm Data in DBArtisan
Use wizards in DBArtisan to configure OnePageCrm data as a data source.
-
Integrate with Sybase IQ Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Sybase IQ data in SnapLogic.
-
Build Salesforce-Connected Apps in Choreo
Use CData Connect AI to connect to Salesforce Data from Choreo and build custom apps using live Salesforce data.
-
Build MVC Applications with Connectivity to Databricks Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Databricks from an ASP.NET MVC application.
-
Access Basecamp Data from MySQL in Amazon QuickSight
Connect to Basecamp and build visualizations of Basecamp data using a MySQL Connection in Amazon QuickSight.
-
How to connect to Zoho Recruit Data from Spring Boot
Connect to Zoho Recruit in a Spring Boot Application using the CData API Driver for JDBC
-
Automated Continuous IBM Informix Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable IBM Informix replication to Apache Cassandra.
-
Import Real-Time Phoenix Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Phoenix data in ColdFusion.
-
Automated Continuous Nethunt Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Nethunt replication to Amazon S3.
-
Connect to Optimizely Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Optimizely data.
-
Connect to Cassandra Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Cassandra data using standard SQL.
-
Integrating Claude Code CLI with Amplitude 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 Microsoft Exchange Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Microsoft Exchange data replication to OneLake in Microsoft Fabric.