CData Software - Knowledge Base
Recent Articles
-
Query Teradata Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Teradata entities in PHP by modeling them as objects.
-
Access Live PayPal Data in AWS Lambda (with IntelliJ IDEA)
Connect to live PayPal data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Automated Continuous Figshare Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Figshare replication to Google Cloud SQL.
-
Automated Continuous SAP HANA XS Advanced Replication to MySQL
Use CData Sync for automated, continuous, customizable SAP HANA XS Advanced replication to MySQL.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Accelo
Provide connectivity to Accelo data through an SAP BusinessObjects universe.
-
Build Dashboards with Clio Data in Dundas BI
Create dynamic dashboards and perform analytics based on Clio data in Dundas BI.
-
Connect to and Visualize Live Workable Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Workable data.
-
How to Connect to Live MYOB AccountRight 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 MYOB AccountRight data for you.
-
Create Data Visualizations Based On Neo4J Data in Mode
Use CData Connect AI to connect to Neo4J Data from Mode and build visualizations using live Neo4J data.
-
Enable the Instantly JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Instantly data.
-
Integrate Goose with Live Pipedrive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Pipedrive data from within the local AI agent.
-
Integrate LibreChat with Live Microsoft Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Microsoft Ads data from within the chat interface.
-
Consume IBM Informix OData Feeds in SAP Lumira
Use the API Server to create data visualizations on IBM Informix feeds that reflect any changes in SAP Lumira.
-
Integrate Cursor with Live Blackbaud FE NXT Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Blackbaud FE NXT data from within the editor.
-
How to Query Azure Analysis Services Data in MySQL Workbench
Execute MySQL queries against live Azure Analysis Services data from MySQL Workbench.
-
Integrate Cline with Live Procore Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Procore data from within your IDE.
-
Analyze SharePoint Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze SharePoint data with the CData JDBC Driver for SharePoint.
-
Automated Continuous SpaceX Replication to Amazon S3
Use CData Sync for automated, continuous, customizable SpaceX replication to Amazon S3.
-
Access Mode Data from MySQL in PHP
Connect to Mode through the standard MySQL libraries in PHP.
-
Use Claude to Talk to Your Instagram 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 Instagram data for you.
-
Use Grok to Talk to Your CapsuleCRM Data 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 CapsuleCRM data for you.
-
Query OData Services using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume OData entities in PHP by modeling them as objects.
-
Publish Reports with Google Drive Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Google Drive data.
-
Connect to Reckon Data from AWS Glue
Use CData Connect AI to gain access to live Reckon data from your AWS Glue jobs.
-
Automate Mistral AI Data Replication to SAP HANA
Use CData Sync to customize and automate Mistral AI data replication to SAP HANA.
-
Visualize Qualaroo Data in Sisense
Create an ElastiCube in Sisense app with access to Qualaroo data.
-
How to Build an ETL App for Outreach.io Data in Python with CData
Create ETL applications and real-time data pipelines for Outreach.io data in Python with petl.
-
How to Connect to Live BambooHR 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 BambooHR data through natural language.
-
Import and Visualize PabblySubscriptions Data in Power View
Create data visualizations based on PabblySubscriptions data in Excel.
-
Connect to Real-Time Discourse Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Discourse data in Power Apps.
-
Integrate Acumatica with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Acumatica with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Acumatica data.
-
Build Semantic Layer Views for Sugar CRM Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Sugar CRM data.
-
DataBind Spotify Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Spotify data to a chart.
-
Automated Continuous Mocean Replication to Databricks
Use CData Sync for automated, continuous, customizable Mocean replication to Databricks.
-
How to Connect to Live HubDB Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your HubDB data for you.
-
Replicate Multiple Avaza Accounts via the CData Sync CLI
Replicate multiple Avaza accounts to one or many databases.
-
Configure the CData JDBC Driver for Rebilly in a Connection Pool in Tomcat
Connect to Rebilly data from a connection pool in Tomcat.
-
Visualize Adobe Commerce 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 Adobe Commerce data into TIBCO Spotfire.
-
Query Jira Data in ColdFusion
Write standard ColdFusion data access code to connect to Jira data.
-
How to update Twilio from Excel
This article explains how to transfer data from Excel to Twilio using the Excel Add-In for Twilio.
-
Integrate with Square Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Square data to a JSON file on disk.
-
How to connect to Discourse Data with Squirrel SQL client
Connect to Discourse data and execute queries in the Squirrel SQL Client.
-
Integrate Cline with Live Salesforce Data 360 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Salesforce Data 360 data from within your IDE.
-
Connect to Freshteam Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Freshteam as an External Source in Dremio.
-
Integrating LangGraph with SAS Data Sets Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on SAS Data Sets data within automated workflows.
-
Getting Started with the CData Power BI Connector for Eventbrite
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Create Humanity Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Humanity from PowerBI.com to create Power BI Dataflows with real-time data.
-
Publish Lakebase-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Lakebase data.
-
Access Google Tasks Data from MySQL in Amazon QuickSight
Connect to Google Tasks and build visualizations of Google Tasks data using a MySQL Connection in Amazon QuickSight.
-
Query CircleCI Data in DataGrip
Create a Data Source for CircleCI in DataGrip and use SQL to query live CircleCI data.
-
Integrating LangGraph with Google Cloud Storage Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Google Cloud Storage data within automated workflows.
-
Validate Amplitude Data with QuerySurge
Access and validate Amplitude data in QuerySurge using the CData JDBC Driver.
-
Create Shippo-Connected Dashboards in Grafana
Connect to Shippo Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Shippo data.
-
Connect to SAP Business Warehouse Data from a Connection Pool in Jetty
The SAP Business Warehouse JDBC Driver supports connection pooling: This article shows how to connect faster to SAP Business Warehouse data from Web apps in Jetty.
-
Automated Continuous Salesforce Replication to SingleStore
Use CData Sync for automated, continuous, customizable Salesforce replication to SingleStore.
-
Getting Started with the CData Connect AI Python SDK for Google Calendar
Install the CData Connect AI Python SDK to read and write live Google Calendar data with standard DB-API 2.0 Python code.
-
Manage Jumpseller Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Jumpseller.
-
Query LinkedIn Ads Data as a SQL Server Database in Node.js
Execute SQL Server queries against LinkedIn Ads data from Node.js.
-
How to Query EnterpriseDB Data in MySQL Workbench
Execute MySQL queries against live EnterpriseDB data from MySQL Workbench.
-
Use the CData ODBC Driver for Superchat from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Superchat to connect to Superchat data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Superchat data in Excel.
-
Visualize SAP BusinessObjects BI 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 SAP BusinessObjects BI data into TIBCO Spotfire.
-
Connect to ZendeskSell Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for ZendeskSell data in the Denodo Virtual DataPort Administrator.
-
How to connect to Unbounce Data from Spring Boot
Connect to Unbounce in a Spring Boot Application using the CData API Driver for JDBC
-
Replicate Multiple Zoho Recruit Accounts via the CData Sync CLI
Replicate multiple Zoho Recruit accounts to one or many databases.
-
Automated Continuous Jodoo Replication to Vertica
Use CData Sync for automated, continuous, customizable Jodoo replication to Vertica.
-
Connect to Access Data in DBeaver
Use the CData ODBC Driver to connect to Access data in DBeaver.
-
How to Connect to Live Zoom 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 Zoom data for you.
-
Getting Started with the CData Python Connector for Zuora
Learn to install and license the CData Python Connector and configure a connection to live Zuora data.
-
Automated Continuous Templated Replication to MySQL
Use CData Sync for automated, continuous, customizable Templated replication to MySQL.
-
Use the CData Software JDBC Driver for Spotify in MicroStrategy Desktop
Connect to Spotify data in MicroStrategy Desktop using the CData Software JDBC Driver for Spotify.
-
Build SFTP-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live SFTP data.
-
Replicate ZohoExpense Data from PowerShell
Write a quick PowerShell script to query ZohoExpense data. Use connectivity to the live data to replicate ZohoExpense data to SQL Server.
-
Automated Continuous Pinterest Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Pinterest data replication to OneLake in Microsoft Fabric.
-
Connect to Aha! Data from PowerBuilder via JDBC
This article demonstrates how to access Aha! data from PowerBuilder using the Aha! JDBC Driver.
-
Connect to Clari Data in DBArtisan
Use wizards in DBArtisan to configure Clari data as a data source.
-
Building Dynamic Web Pages with Basecamp Data Using AngularJS
Create single-page applications with live connectivity to Basecamp using the CData API Server.
-
Use Biml to Build SSIS Tasks to Replicate Amplitude Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Amplitude data to SQL Server.
-
Access Live Teradata Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Teradata data from your Excel spreadsheets.
-
Use Dash to Build to Web Apps on Cosmos DB Data
Create Python applications that use pandas and Dash to build Cosmos DB-connected web apps.
-
How to Build an ETL App for ADP Data in Python with CData Connect AI
Build ETL pipelines that read and write live ADP data in Python with petl and the CData Connect AI Python SDK.
-
Publish Crystal Reports on CapsuleCRM Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date CapsuleCRM data.
-
Create Informatica Mappings From/To a JDBC Data Source for Rebilly
Create Rebilly data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to connect to HDFS Data from Spring Boot
Connect to HDFS in a Spring Boot Application using the CData JDBC Driver for HDFS
-
Automated Continuous Stack Exchange Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Stack Exchange replication to Google BigQuery.
-
Connect to Zoom Data in RazorSQL
Connect to Zoom from wizards and query Zoom data from the GUI in the RazorSQL database management tool.
-
How to Seamlessly Import Amazon Athena Data into IBM SPSS Modeler
Integrate Amazon Athena data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to Connect to Live Databricks 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 Databricks data through natural language.
-
How to connect to SendPulse Data from Spring Boot
Connect to SendPulse in a Spring Boot Application using the CData API Driver for JDBC
-
Model Mode Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Mode, enabling the direct import of real-time Mode data.
-
Use Dash to Build Web Apps on Gmail Data via CData Connect AI
Build interactive Dash web apps on live Gmail data using pandas and the CData Connect AI Python SDK.
-
Create ZohoSubscriptions-Connected Business Apps in AppSheet
Connect to ZohoSubscriptions Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to ZohoSubscriptions data.
-
Use the CData ODBC Driver for Zoho Books from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Zoho Books to connect to Zoho Books data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Zoho Books data in Excel.
-
How to work with Cvent Data in Apache Spark using SQL
Access and process Cvent Data in Apache Spark using the CData Software JDBC Driver.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for MYOB AccountRight
Provide connectivity to MYOB AccountRight data through an SAP BusinessObjects universe.
-
Natively Connect to Twilio Data in PHP
The CData ODBC driver for Twilio enables you to create PHP applications with connectivity to Twilio data. Leverage the native support for ODBC in PHP.
-
Build Voice Agents in ElevenLabs with access to Live Mailgun Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Mailgun data.
-
Access Live SAP Netweaver Gateway 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 SAP Netweaver Gateway data through MCP integration.
-
Query Helpscout Data in DataGrip
Create a Data Source for Helpscout in DataGrip and use SQL to query live Helpscout data.
-
HelloSign Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on HelloSign facts in real time.
-
Connect to Oracle Service Cloud Data in DBeaver
Use the CData ODBC Driver to connect to Oracle Service Cloud data in DBeaver.