CData Software - Knowledge Base
Recent Articles
-
Integrating Claude Code with Sage 200 Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Sage 200 within assisted coding and automated development workflows.
-
Excel Spreadsheet Automation on Templated Data with the QUERY Formula
Pull data from Templated, automate spreadsheets, and more with the QUERY formula.
-
Connect to SAP Concur Data from HeidiSQL
Use CData Connect AI to connect to and query live SAP Concur from HeidiSQL.
-
Stream Jira Assets Data into Apache Kafka Topics
Access and stream Jira Assets in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Build a Simple VCL Application for Gong Data
How to build a simple VCL Application to view Gong in RAD Studio using the CData ODBC Driver for Gong.
-
Automated Continuous Sage 200 Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Sage 200 replication to Google Cloud SQL.
-
Integrate with Act CRM Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Act CRM to a JSON file on disk.
-
Configure the CData JDBC Driver for Sugar CRM in a Connection Pool in Tomcat
Connect to Sugar CRM from a connection pool in Tomcat.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live SendGrid using the Model Context Protocol.
-
Automated Continuous HDFS Replication to SingleStore
Use CData Sync for automated, continuous, customizable HDFS replication to SingleStore.
-
Automate SAP Business One Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live SAP Business One and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
How to Connect to Live QuickBooks Time Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your QuickBooks Time for you.
-
Use Grok to Talk to Your Highrise 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 Highrise CRM for you.
-
How to Connect DBeaver to Auth0 via a JDBC Driver
Manage Auth0 with visual tools in DBeaver like the query browser.
-
Access Live Chargebee Data in AWS Lambda
Connect to live Chargebee in AWS Lambda using the CData JDBC Driver.
-
How to Seamlessly Import Zuora Data into IBM SPSS Modeler
Integrate Zuora data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Create Dashboards and Visualize Live Sage Intacct Data in Geckoboard
Use CData Connect AI to connect to live Sage Intacct and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Access HubDB Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live HubDB from HeidiSQL.
-
Build Data Flows from ZohoInvoice to SQL Server using SSIS
Easily back up ZohoInvoice to SQL Server using the SSIS components for ZohoInvoice.
-
Scrapfly Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Scrapfly facts in real time.
-
Integrating Claude Code with FTP Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on FTP Servers within assisted coding and automated development workflows.
-
Build Zendesk-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Zendesk to explore live Zendesk Data in Claude Code to assist with building Zendesk-powered applications.
-
How to use SQLAlchemy ORM to access HubDB Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of HubDB.
-
Build Charts with SparkPost Data in Clear Analytics
Create dynamic charts and perform analytics based on SparkPost in Clear Analytics.
-
Connect to Oracle Financials Cloud from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Oracle Financials Cloud, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Getting Started with the CData SSIS Components for Exa
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Exa.
-
Connect to MYOB AccountRight Data in DBArtisan
Use wizards in DBArtisan to configure MYOB AccountRight as a data source.
-
Visualize Live Google Directory Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Google Directory into custom reports in Power BI.
-
Getting Started with the CData Power BI Connector for Grafana
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Connecting Moonlit Workflow with Cassandra 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 Apache Cassandra in real time.
-
Create Reports with Deel Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Deel.
-
Access Live SQL Analysis Services Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live SQL Analysis Services from your Excel spreadsheets.
-
Create Informatica Mappings From/To a JDBC Data Source for SAP HANA XS Advanced
Create SAP HANA XS Advanced data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Create Data Visualizations in Cognos BI with Highrise Data
Access Highrise CRM as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Getting Started with the CData Tableau Connector for Campaigner
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Analyze ServiceDesk Plus Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze ServiceDesk Plus in Microsoft R Open.
-
Create Informatica Mappings From/To a JDBC Data Source for Slack
Create Slack data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Bridge ChartMogul Connectivity with Apache NiFi
Access and process ChartMogul in Apache NiFi using the CData JDBC Driver.
-
Connecting Moonlit Workflow with SAP BusinessObjects BI 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 SAP BusinessObjects BI in real time.
-
Automated Continuous HubDB Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable HubDB replication to Azure SQL Database.
-
Connect to Workday Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Workday Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Visualize Live Neo4J Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Neo4J.
-
Connect to Snapchat Ads Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Snapchat Ads in Airbyte.
-
Natively Connect to Microsoft Teams Data in PHP
The CData ODBC driver for Microsoft Teams enables you to create PHP applications with connectivity to Microsoft Teams. Leverage the native support for ODBC in PHP.
-
Moving Data from Flowlu to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Flowlu data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Automated Continuous CapsuleCRM Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable CapsuleCRM replication to Apache Cassandra.
-
Integrate with Live Certinia Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Certinia from the MuleSoft Anypoint Platform to integrate live Certinia into custom reports and dashboards.
-
Visualize Zendesk Data in Sisense
Create an ElastiCube in Sisense app with access to Zendesk.
-
Build a Simple VCL Application for FreeAgent Data
How to build a simple VCL Application to view FreeAgent in RAD Studio using the CData ODBC Driver for FreeAgent.
-
Create Informatica Mappings From/To a JDBC Data Source for ServiceDesk Plus
Create ServiceDesk Plus data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
ETL SAP ByDesign in Oracle Data Integrator
This article shows how to transfer SAP Business ByDesign into a data warehouse using Oracle Data Integrator.
-
How to Visualize Salesforce CRM Analytics Data in Python with pandas
Use pandas and other modules to analyze and visualize live Salesforce CRM Analytics in Python.
-
Paylocity Reporting in OBIEE with the Paylocity JDBC Driver
Deploy the Paylocity JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automated Continuous Presto Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Presto replication to delimited files (CSV/TSV).
-
Use the CData Software JDBC Driver for WordPress in MicroStrategy
Connect to WordPress in MicroStrategy Developer using the CData Software JDBC Driver for WordPress.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Elorus
Provide connectivity to Elorus through an SAP BusinessObjects universe.
-
Build CockroachDB-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to CockroachDB and build web apps with connectivity to live CockroachDB.
-
Connect to MYOB AccountRight Data in Aqua Data Studio
Access MYOB AccountRight from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Create Power BI Reports on Real-Time HubDB Data
Use the CData ODBC Driver for HubDB to visualize HubDB in Power BI Desktop.
-
Prepare, Blend, and Analyze Google Spanner Data in Alteryx Designer (Connect AI)
Build workflows to access live Google Spanner for self-service data analytics.
-
Back Up Paymo to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Paymo data.
-
Getting Started with the CData Python Connector for Clockify
Learn to install and license the CData Python Connector
-
Bind Live ADP Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live ADP data
-
Connect to Egnyte Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Egnyte using standard SQL.
-
Connect to ServiceNow Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for ServiceNow in the Denodo Virtual DataPort Administrator.
-
How to use SQLAlchemy ORM to access Oracle Sales Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Oracle Sales.
-
Connect to Apollo Data from PowerBuilder via JDBC
This article demonstrates how to access Apollo from PowerBuilder using the Apollo JDBC Driver.
-
Use Microsoft Copilot Studio to talk to your Power BI XMLA Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Power BI XMLA for you.
-
Import SAP BusinessObjects BI Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to SAP BusinessObjects BI Data and provide access to live SAP BusinessObjects BI for custom reports in the Power BI Service.
-
Connect to Amazon DynamoDB from a Connection Pool in WebLogic
Use the CData JDBC Driver for Amazon DynamoDB to connect to Amazon DynamoDB from Web applications running on WebLogic.
-
Connect to ConvertKit Data in DBeaver
Use the CData ODBC Driver to connect to ConvertKit in DBeaver.
-
Connect to and Visualize Live HCL Domino Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live HCL Domino.
-
Build Agents in Relevance AI with Access to Live SAP Ariba Source Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on SAP Ariba Source within intelligent agent workflows.
-
Connect to Paddle Data from a Connection Pool in Jetty
The Paddle JDBC Driver supports connection pooling: This article shows how to connect faster to Paddle from Web apps in Jetty.
-
Leverage the Full Potential of Workday data with CData Sync
This article compares the CData Sync Workday Connector with Workday connectors from other ETL/ELT platforms.
-
Build Apps with Live Pingdom Data Using the Low-Code Development Platform of Mendix
Connect Pingdom with Mendix to build apps using the CData API Driver for JDBC.
-
Connect to Google Campaign Manager 360 Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Google Campaign Manager 360.
-
Getting Started with the CData JDBC Driver for Contentful
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Contentful.
-
Connect to QuickBooks Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for QuickBooks Desktop in the Denodo Virtual DataPort Administrator.
-
Connect to Reckon Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Reckon as an External Source in Dremio.
-
Create Dynamic Jira Assets Grids Using the Infragistics XamDataGrid
Learn how you can connect Jira Assets to Infragistics XamDataGrid to build dynamic grids.
-
Excel Spreadsheet Automation on Greenhouse Data with the QUERY Formula
Pull data from Greenhouse, automate spreadsheets, and more with the QUERY formula.
-
Connect to and Query Contentful Data in QlikView over ODBC
Create data visualizations with Contentful in QlikView.
-
Integrating Antigravity CLI with Sendwithus via CData CLI
Connect Sendwithus to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Import SingleStore Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to SingleStore Data and provide access to live SingleStore for custom reports in the Power BI Service.
-
Build MVC Applications with Connectivity to SageHR Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access SageHR from an ASP.NET MVC application.
-
How to Work with Adobe Analytics Data in ETL Validator JDBC
Connect to Adobe Analytics from ETL Validator jobs using the CData Software JDBC Driver.
-
How to Connect DBeaver to Parquet via a JDBC Driver
Manage Apache Parquet with visual tools in DBeaver like the query browser.
-
Connecting GenSpark with Sage Cloud Accounting Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Sage Business Cloud Accounting without any replication or custom integration required.
-
Import and Visualize MailChimp Data in Power View
Create data visualizations based on MailChimp in Excel.
-
Query Elorus Data in DataGrip
Create a Data Source for Elorus in DataGrip and use SQL to query live Elorus.
-
Access Live WooCommerce Data in TIBCO Data Virtualization
Use the WooCommerce Tibco DV Adapter to create a WooCommerce data source in TIBCO Data Virtualization Studio and gain access to live WooCommerce from your TDV Server.
-
Process & Analyze CloudConvert Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live CloudConvert Data.
-
Integrate Dotmailer Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Dotmailer from Informatica Cloud.
-
Migrating data from Xero to Databricks using CData SSIS Components.
Easily push Xero Accounting to Databricks using the CData SSIS Tasks for Xero and Databricks.
-
Connect to Tavily Data in RapidMiner
Integrate Tavily with standard components and data source configuration wizards in RapidMiner Studio.
-
A PostgreSQL Interface for FHIR Data using the CData ODBC Driver
Use the SQL Gateway and FHIR ODBC Driver to create a PostgreSQL entry-point for data access.
-
Visualize Live SAP SuccessFactors LMS Data in the Power BI Service
Use CData Connect AI to connect to live SAP SuccessFactors LMS and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build HubDB-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for HubDB to explore live HubDB Data in Cursor to assist with building HubDB-powered applications.
-
Connect to Coinbase Data from a Connection Pool in Jetty
The Coinbase JDBC Driver supports connection pooling: This article shows how to connect faster to Coinbase from Web apps in Jetty.