CData Software - Knowledge Base
Recent Articles
-
Import Real-Time Jumpseller Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Jumpseller in ColdFusion.
-
Connect to Email Data from HeidiSQL
Use CData Connect AI to connect to and query live Email from HeidiSQL.
-
Connect SpaceX to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect SpaceX with IBM WebSphere for seamless data integration and connectivity.
-
Integrate Keap Data in the Pentaho Report Designer
Publish reports based on Keap in the Pentaho BI tool.
-
Query Amazon Athena Data in DataGrip
Create a Data Source for Amazon Athena in DataGrip and use SQL to query live Amazon Athena.
-
Create Dynamic Airtable Grids Using the Infragistics XamDataGrid
Learn how you can connect Airtable to Infragistics XamDataGrid to build dynamic grids.
-
How to Query HubSpot Data in MySQL Workbench
Execute MySQL queries against live HubSpot from MySQL Workbench.
-
Stream TigerGraph Data into Apache Kafka Topics
Access and stream TigerGraph in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Visualize Live Zoho Books Data in the Power BI Service
Use CData Connect AI to connect to live Zoho Books and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect Nuclia to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Nuclia using the CData Python MCP Server.
-
Object-Relational Mapping (ORM) with Amazon S3 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 Amazon S3 into a Java-based ORM framework, Hibernate.
-
Back Up MariaDB to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for MariaDB. In this article, we will employ an SSIS workflow to populate a database with MariaDB data.
-
Create Dynamic Vault CRM Grids Using the Infragistics XamDataGrid
Learn how you can connect Vault CRM to Infragistics XamDataGrid to build dynamic grids.
-
Build Pipelines with Live NetSuite SuiteAnalytics Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to NetSuite SuiteAnalytics from Google Cloud Data Fusion, enabling the integration of live NetSuite SuiteAnalytics into the building and management of effective data pipelines.
-
Use the CData Software ODBC Driver for Klipfolio in MicroStrategy
Connect to Klipfolio in MicroStrategy Developer using the CData Software ODBC Driver for Klipfolio.
-
Edit and Search External MYOB AccountRight Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of MYOB AccountRight to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create MYOB AccountRight Data objects that you can access from apps and the dashboard.
-
Working with Google Tasks Data in LINQPad
Execute LINQ queries to Google Tasks in LINQPad.
-
Connect to Dynamics 365 Business Central Data in RazorSQL
Connect to Dynamics 365 Business Central from wizards and query Dynamics 365 Business Central from the GUI in the RazorSQL database management tool.
-
Build Greenplum-Connected Apps in Choreo
Use CData Connect AI to connect to Greenplum Data from Choreo and build custom apps using live Pivotal GreenPlum.
-
Connecting Agentforce with DB2 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 IBM DB2 for you.
-
Create Informatica Mappings From/To a JDBC Data Source for Sage Cloud Accounting
Create Sage Cloud Accounting data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Create Apps from FTP Data in Qlik Sense Cloud
Use CData Connect AI to connect to FTP Data and build apps from live FTP Servers in Qlik Sense Cloud.
-
Integrate Live LDAP Objects into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live LDAP to Blue Prism using the CData ODBC Driver for LDAP to create automated workflows for repetitive business tasks.
-
Integrating GitHub Copilot CLI with ShipStation 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 Workday Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Workday replication to Apache Cassandra.
-
Connect to Presto from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Presto, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Use the CData Software ODBC Driver for Gong in MicroStrategy
Connect to Gong in MicroStrategy Developer using the CData Software ODBC Driver for Gong.
-
Publish Crystal Reports on Zoho Recruit Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Zoho Recruit.
-
Integrate LibreChat with Live Workday Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Workday from within the chat interface.
-
Connect to Dynamics NAV Data from a Connection Pool in JBoss
Integrate Microsoft Dynamics NAV into Java servlets: Use the Management Console in JBoss to install the Dynamics NAV JDBC Driver.
-
How to Connect the Power BI Service to SAP Ariba Source: Complete Guide
Connect to the CData Software Power BI Connector for SAP Ariba Source from PowerBI.com to provide real-time SAP Ariba Source across the organization.
-
Integrating Square Data in Talend Cloud Data Management Platform
Connect Square Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Square.
-
Integrate Live Adobe Target Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Adobe Target to Blue Prism using the CData ODBC Driver for Adobe Target to create automated workflows for repetitive business tasks.
-
DataBind Everhour Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Everhour to a chart.
-
Automate SAP Business One Data Replication to Couchbase
Use CData Sync to Customize and automate SAP Business One replication to Couchbase.
-
Provide OData Services of Mailgun Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Mailgun by developing a WCF Service Application.
-
Automated Continuous SurveyMonkey Replication to Amazon S3
Use CData Sync for automated, continuous, customizable SurveyMonkey replication to Amazon S3.
-
Build Agents in Relevance AI with Access to Live LinkedIn Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on LinkedIn Ads within intelligent agent workflows.
-
Replicate Zoom Data in Heroku for Use in Salesforce Connect
Replicate Zoom to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Query SingleStore Data in DataGrip
Create a Data Source for SingleStore in DataGrip and use SQL to query live SingleStore.
-
Use Manus AI to Talk to Your BambooHR 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 BambooHR.
-
Access Yelp Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Yelp from your Oracle system.
-
Integrate with Aha! Data in JReport Designer
Create charts and reports based on Aha! in JReport Designer.
-
How to connect Amazon QuickSight to Gmail Data
Create a connection to Gmail in CData Connect AI and insert Gmail into Amazon QuickSight SPICE to build interactive dashboards.
-
Replicate Multiple Microsoft Ads Accounts
Replicate multiple Microsoft Ads accounts to one or many databases.
-
Use Biml to Build SSIS Tasks to Replicate Telegram Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Telegram to SQL Server.
-
Deploy the ADO.NET Provider for Zoho Books on an SSRS Report Server
Connect to Zoho Books 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 Query Adobe Analytics Data in MySQL Workbench
Execute MySQL queries against live Adobe Analytics from MySQL Workbench.
-
Query, Visualize, and Share live Paylocity Data in Redash
Use CData Connect AI to connect to live Paylocity in Redash for querying, visualizing, and sharing.
-
How to Connect to Live Oracle SCM Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Oracle SCM without replication.
-
Automated Continuous Mailgun Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Mailgun replication to Google Cloud SQL.
-
Build Automated BigCommerce-Connected Workflows in Zapier
Use CData Connect AI to connect to live BigCommerce and build automated workflows in Zapier.
-
Use the CData Software ODBC Driver for Rebilly in MicroStrategy Web
Connect to Rebilly in MicroStrategy Web using the CData Software ODBC Driver for Rebilly.
-
Connect to Landbot Data from a Connection Pool in Jetty
The Landbot JDBC Driver supports connection pooling: This article shows how to connect faster to Landbot from Web apps in Jetty.
-
Connect Smartsheet to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Smartsheet with IBM WebSphere for seamless data integration and connectivity.
-
Integrating Kiro CLI with Figshare 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.
-
Model, Search, and Visualize Live Oracle Eloqua Data in ThoughtSpot
Use CData Connect AI to connect to live Oracle Eloqua for modeling, searching, and visualizing.
-
Consume Microsoft Dataverse OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Microsoft Dataverse feeds that reflect any changes in SAP Lumira.
-
Bridge Teamgate Connectivity with Apache NiFi
Access and process Teamgate in Apache NiFi using the CData JDBC Driver.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Excel Online
Provide connectivity to Microsoft Excel Online through an SAP BusinessObjects universe.
-
Access ZendeskSell Data from MySQL in PHP
Connect to ZendeskSell through the standard MySQL libraries in PHP.
-
Query, Visualize, and Share live Oracle SCM Data in Redash
Use CData Connect AI to connect to live Oracle SCM in Redash for querying, visualizing, and sharing.
-
DataBind Charts to Google Analytics Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Google Analytics from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Build MVC Applications with Connectivity to Oracle Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Oracle from an ASP.NET MVC application.
-
Create Informatica Mappings From/To a JDBC Data Source for Guru
Create Guru data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Integrate Sybase IQ Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Sybase IQ from Informatica Cloud.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for ShipEngine
Provide connectivity to ShipEngine through an SAP BusinessObjects universe.
-
Bidirectional Access to Exact Online Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Exact Online in Filemaker Pro for Mac or Windows.
-
Connect to Exact Online from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Exact Online, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Process & Analyze Bitly Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Bitly Data.
-
Automate ClickTime Data Replication to SAP HANA
Use CData Sync to customize and automate ClickTime replication to SAP HANA.
-
Publish Reports with Instantly Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Instantly.
-
Model Stripe Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Stripe, enabling the direct import of real-time Stripe.
-
Automated Continuous Greenhouse Replication to MySQL
Use CData Sync for automated, continuous, customizable Greenhouse replication to MySQL.
-
Replicate LDAP Objects to Multiple Databases via the CData Sync CLI
Replicate LDAP to disparate databases with a single configuration.
-
How to work with Oracle Service Cloud Data in Apache Spark using SQL
Access and process Oracle Service Cloud Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to Blackbaud FE NXT Data from PowerBuilder via JDBC
This article demonstrates how to access Blackbaud FE NXT from PowerBuilder using the Blackbaud FE NXT JDBC Driver.
-
Build Dashboards with Active Directory Data in DBxtra
Create dynamic dashboards and perform analytics based on Active Directory in DBxtra.
-
Validate ZohoDesk Data with QuerySurge
Access and validate ZohoDesk in QuerySurge using the CData JDBC Driver.
-
Integrate Drift Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Drift from Informatica Cloud.
-
Connect to Zendesk Data in Claris FileMaker Pro
Use the CData ODBC Driver for Zendesk in FileMaker Pro to connect to Zendesk and work with Zendesk in your FileMaker applications.
-
Work with Live Oracle Data in Power Query
Use CData Connect AI to connect to Oracle Database and work with live Oracle Database in Microsoft Power Query.
-
How to Connect to Live DocuSign 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 DocuSign through natural language.
-
Connect to SpaceX in SpagoBI
Create reports featuring live SpaceX in SpagoBI Studio. Host SpaceX reports on SpagoBI Server.
-
Connect to Confluence Data from Crystal Reports
Use CData Connect AI to connect to and report on live Atlassian Confluence from Crystal Reports.
-
Configure the CData JDBC Driver for Humanity in a Connection Pool in Tomcat
Connect to Humanity from a connection pool in Tomcat.
-
Query Microsoft OneDrive Data as a MySQL Database in Node.js
Execute MySQL queries against Microsoft OneDrive from Node.js.
-
Natively Connect to Adobe Commerce Data in PHP
The CData ODBC driver for Adobe Commerce enables you to create PHP applications with connectivity to Adobe Commerce. Leverage the native support for ODBC in PHP.
-
Migrating data from Beeminder to Databricks using CData SSIS Components.
Easily push Beeminder to Databricks using the CData SSIS Tasks for Beeminder and Databricks.
-
Import Okta Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Okta. In this article, you will use the OData format to import Okta into Microsoft Power Query.
-
Build Semantic Layer Views for Box Data in APOS Live Data Gateway
Use the CData Connector for Box in APOS Live Data Gateway to build Semantic Layer Views for Box.
-
Build Dashboards with NASA Data in DBxtra
Create dynamic dashboards and perform analytics based on NASA in DBxtra.
-
How to Work with FreeAgent Data in AWS Glue Jobs Using JDBC
Connect to FreeAgent from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Process & Analyze Twilio Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Twilio Data.
-
Build Email-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Email and build Email-connected web apps with Axios.
-
Use the CData Software ODBC Driver for FreeAgent in MicroStrategy Desktop
Connect to FreeAgent in MicroStrategy Desktop using the CData Software ODBC Driver for FreeAgent.
-
Getting Started with the CData Power BI Connector for MariaDB
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for MariaDB.
-
Operational Reporting on Yelp Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Yelp.
-
Connect to Shortcut Data in CloverDX (formerly CloverETL)
Transfer Shortcut using the visual workflow in the CloverDX data integration tool.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Paymo
Provide connectivity to Paymo through an SAP BusinessObjects universe.