CData Software - Knowledge Base
Recent Articles
-
Build Charts with GraphQL Data in Clear Analytics
Create dynamic charts and perform analytics based on GraphQL in Clear Analytics.
-
Query eBay Data as a MySQL Database in Node.js
Execute MySQL queries against eBay from Node.js.
-
Model, Search, and Visualize Live Microsoft Dataverse Data in ThoughtSpot
Use CData Connect AI to connect to live Microsoft Dataverse (CDS) for modeling, searching, and visualizing.
-
Connect to Amazon Marketplace Data from AWS Glue
Use CData Connect AI to gain access to live Amazon Marketplace from your AWS Glue jobs.
-
Edit and Search Active Directory External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Active Directory to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Active Directory objects that you can access from apps and the dashboard.
-
Connect to Mode Data in Aqua Data Studio
Access Mode from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Create Reports with Marketo Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Marketo.
-
How to create an RPA flow for AfterShip Data in UiPath Studio
Use the AfterShip ODBC Driver to create workflows that access real-time AfterShip without any coding.
-
Replicate GraphQL Data in Heroku for Use in Salesforce Connect
Replicate GraphQL to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Load Postmark Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Postmark to a database.
-
How to Create Power BI Visual Reports with Real-Time Salesforce CRM Analytics Data
Use CData Power BI Connectors to visualize Salesforce CRM Analytics in Power BI.
-
Build AI Agents with Microsoft Planner 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 Microsoft Planner through CData Connect AI.
-
Migrating data from Oracle HCM Cloud to Google BigQuery using CData SSIS Components.
Easily push Oracle HCM Cloud to Google BigQuery using the CData SSIS Tasks for Oracle HCM Cloud and Google BigQuery.
-
Getting Started with the CData JDBC Driver for Google Cloud Storage
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Google Cloud Storage.
-
Visualize Zoom Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Zoom.
-
Integrate PolarTeamPro with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate PolarTeamPro with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to PolarTeamPro.
-
Build a Singer.io Tap for Cloudant With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Cloudant data using
-
Automated Continuous Oracle HCM Cloud Replication to SQLite
Use CData Sync for automated, continuous, customizable Oracle HCM Cloud replication to SQLite.
-
Access Workable Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Workable from HeidiSQL.
-
Integrate ConvertAPI with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate ConvertAPI with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to ConvertAPI.
-
Connect to TigerGraph Data from PowerBuilder via JDBC
This article demonstrates how to access TigerGraph from PowerBuilder using the TigerGraph JDBC Driver.
-
Create Xero-Connected Applications in Appsmith
Connect to Xero Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Xero Accounting.
-
Connect to Gumroad Data in NetBeans
Connect to Gumroad in NetBeans with the data source configuration wizard.
-
Connect to Drip Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Drip and work with Drip in your FileMaker applications.
-
Use Dash to Build to Web Apps on Helpscout Data
Create Python applications that use pandas and Dash to build Helpscout-connected web apps.
-
Build Data Flows from Reckon Accounts Hosted to SQL Server using SSIS
Easily back up Reckon Accounts Hosted to SQL Server using the SSIS components for Reckon Accounts Hosted.
-
How to Connect to SpaceX Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to SpaceX. Leverage the pyodbc module for ODBC in Python.
-
Connect Access Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Microsoft Access using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Write a Simple Go Application to work with Shortcut Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Shortcut.
-
Integrating OpenCode Terminal with Highrise 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.
-
Analyze SAP Hybris C4C Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of SAP Hybris C4C and visualize live SAP Hybris C4C in Infragistics Reveal.
-
Access Excel Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Microsoft Excel from HeidiSQL.
-
Integrating BigCommerce Data in Talend Cloud Data Management Platform
Connect BigCommerce Data with Talend Cloud Data Management Platform using the CData JDBC Driver for BigCommerce.
-
Establish a Live Connection with BigCommerce Data using Tableau Bridge
The CData ODBC Driver for BigCommerce enables you to integrate live BigCommerce into Tableau Cloud dashboards using the Tableau Bridge.
-
Build a Simple VCL Application for Splunk Data
How to build a simple VCL Application to view Splunk in RAD Studio using the CData ODBC Driver for Splunk.
-
Write a Simple Go Application to work with ZohoExpense Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to ZohoExpense.
-
Build Data Flows from Bugsnag to SQL Server using SSIS
Easily back up Bugsnag to SQL Server using the SSIS components for Bugsnag.
-
Visualize Live Oracle Service Cloud Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Oracle Service Cloud using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Replicate ZohoPeople Data from PowerShell
Write a quick PowerShell script to query ZohoPeople. Use connectivity to the live data to replicate ZohoPeople to SQL Server.
-
Connect to Phoenix Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Phoenix and the Script function in FileMaker Pro to connect to Phoenix and work with Apache Phoenix in your FileMaker application.
-
Automate MySQL Data Replication to Azure Data Lake
Use CData Sync to customize and automate MySQL replication to Azure Data Lake.
-
Automated Continuous Cassandra Replication to SQLite
Use CData Sync for automated, continuous, customizable Cassandra replication to SQLite.
-
Use Agno to Talk to Your Microsoft Ads 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 Microsoft Ads for you.
-
Build CockroachDB-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live CockroachDB.
-
Feed iContact Data into FineReport
How to set iContact as a JDBC data source in FineReport.
-
Integrating Kiro CLI with Pinterest 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.
-
Connect to Paddle Data in JRuby
Create a simple JRuby app with access to live Paddle.
-
Create YouTube Analytics Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time YouTube Analytics data access from reports, embedded analytics, and more.
-
Connect to Azure Synapse Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Azure Synapse.
-
Create SSAS Tabular Models from Salesloft Data
How to build a SQL Server Analysis Service Tabular Model from Salesloft using CData drivers.
-
Integrating Claude Code with Google Directory Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Google Directory within assisted coding and automated development workflows.
-
Connect and Query Live Confluence Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Atlassian Confluence into Databricks
-
How to Connect to Live Okta 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 Okta through natural language.
-
Create SSAS Tabular Models from Egnyte Data
How to build a SQL Server Analysis Service Tabular Model from Egnyte using CData drivers.
-
Use Manus AI to Talk to Your Elasticsearch Data 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 Elasticsearch.
-
Build Charts with SAP Netweaver Gateway Data in Clear Analytics
Create dynamic charts and perform analytics based on SAP Netweaver Gateway in Clear Analytics.
-
How to connect and process Figshare from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Figshare.
-
How to connect PolyBase to Nuclia
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Nuclia.
-
Connect to Oracle Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Oracle Data and connect to Oracle Database in Akorbi Digital RunMyProcess.
-
Replicate Wave Financial Data in Heroku for Use in Salesforce Connect
Replicate Wave Financial to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Building Dynamic Web Pages with Google Cloud Storage Data Using AngularJS
Create single-page applications with live connectivity to Google Cloud Storage using the CData API Server.
-
How to Query Zoho Projects Data in MySQL Workbench
Execute MySQL queries against live Zoho Projects from MySQL Workbench.
-
Publish Clio-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Clio.
-
Object-Relational Mapping (ORM) with JotForm Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to JotForm into a Java-based ORM framework, Hibernate.
-
Integrating Boomi Agentstudio with LinkedIn Ads Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to LinkedIn Ads, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Build Apps with Live Mistral AI Data Using the Low-Code Development Platform of Mendix
Connect Mistral AI with Mendix to build apps using the CData API Driver for JDBC.
-
Automated Continuous Teamwork Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Teamwork replication to Amazon S3.
-
Easily Integrate Exact Online Data in Lazarus Pascal IDE
Learn how to easily integrate live Exact Online in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to Cohere Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Cohere in the Denodo Virtual DataPort Administrator.
-
Automate Google Directory Data Replication to SAP HANA
Use CData Sync to customize and automate Google Directory replication to SAP HANA.
-
Connect to Landbot Data in RazorSQL
Connect to Landbot from wizards and query Landbot from the GUI in the RazorSQL database management tool.
-
How to Connect DBeaver to ShipEngine via a JDBC Driver
Manage ShipEngine with visual tools in DBeaver like the query browser.
-
Automated Continuous Dotmailer Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Dotmailer replication to PostgreSQL.
-
Access eBay Data from MySQL in Amazon QuickSight
Connect to eBay and build visualizations of eBay using a MySQL Connection in Amazon QuickSight.
-
Viewing Clockify Data in RAD Studio Data Explorer
How to view Clockify in RAD Studio Data Explorer using the CData ODBC Driver for Clockify.
-
Build SAS Data Sets-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live SAS Data Sets and build SAS Data Sets-connected web apps with Axios.
-
Getting Started with the CData Python Connector for Acumatica
Learn to install and license the CData Python Connector
-
Connect to and Query Salesforce Marketing Data in QlikView over ODBC
Create data visualizations with Salesforce Marketing Cloud in QlikView.
-
How to connect to SAP Data with Squirrel SQL client
Connect to SAP ERP/NetWeaver and execute queries in the Squirrel SQL Client.
-
Migrating data from Egnyte to Google BigQuery using CData SSIS Components.
Easily push Egnyte to Google BigQuery using the CData SSIS Tasks for Egnyte and Google BigQuery.
-
Connecting Agentforce with FTP Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your FTP Servers for you.
-
Connect to Live Raisers Edge NXT Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Raisers Edge NXT in CData Connect AI and connect to your Raisers Edge NXT from PostgreSQL.
-
Build a Simple VCL Application for Impala Data
How to build a simple VCL Application to view Apache Impala in RAD Studio using the CData ODBC Driver for Impala.
-
Create Microsoft Planner-Connected Business Apps in AppSheet
Connect to Microsoft Planner Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Microsoft Planner.
-
Process & Analyze Coinbase Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Coinbase Data.
-
Create Reports with Float Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Float.
-
Object-Relational Mapping (ORM) with LaunchDarkly Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to LaunchDarkly into a Java-based ORM framework, Hibernate.
-
Natively Connect to Presto Data in PHP
The CData ODBC driver for Presto enables you to create PHP applications with connectivity to Presto. Leverage the native support for ODBC in PHP.
-
Create Power BI Reports on Real-Time Sybase IQ Data
Use the CData ODBC Driver for Sybase IQ to visualize Sybase IQ in Power BI Desktop.
-
Connect to Pushbullet Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Pushbullet.
-
Build Quickbase-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Quickbase to explore live Quickbase Data in Gemini Code Assist to assist with building Quickbase-powered applications.
-
Access Live OneNote Data in AWS Lambda
Connect to live Microsoft OneNote in AWS Lambda using the CData JDBC Driver.
-
Connect to QuickBooks Online Data from PowerBuilder via JDBC
This article demonstrates how to access QuickBooks Online from PowerBuilder using the QuickBooks Online JDBC Driver.
-
Connect QuickBooks Time to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect QuickBooks Time with IBM WebSphere for seamless data integration and connectivity.
-
Analyze Google Ads Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Google Ads and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Automated Continuous FreeAgent Replication to Amazon S3
Use CData Sync for automated, continuous, customizable FreeAgent replication to Amazon S3.
-
Getting Started with the CData ODBC Driver for Slack
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Slack.
-
Access Live Sybase Data in TIBCO Data Virtualization
Use the Sybase Tibco DV Adapter to create a Sybase data source in TIBCO Data Virtualization Studio and gain access to live Sybase from your TDV Server.
-
Connect Apollo to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Apollo using the CData Python MCP Server.
-
Connect to GitLab 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 GitLab and work with GitLab in your FileMaker application.