CData Software - Knowledge Base
Recent Articles
-
Publish Reports with Sage 300 Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Sage 300.
-
Connect to Dropbox Data in RapidMiner
Integrate Dropbox with standard components and data source configuration wizards in RapidMiner Studio.
-
Load Google Spanner Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Google Spanner to a database.
-
Connect to Google Directory Data in Google Apps Script via Connect AI
Use CData Connect AI to access Google Directory in Google Apps Script.
-
Access Live Certinia Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Certinia in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to Connect to Amazon Athena Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Amazon Athena. Leverage the pyodbc module for ODBC in Python.
-
Integrating LangChain with Sage 200 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Sage 200 within automated workflows.
-
Connect to MariaDB Data from PowerBuilder via JDBC
This article demonstrates how to access MariaDB from PowerBuilder using the MariaDB JDBC Driver.
-
DataBind Charts to Freshdesk Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Freshdesk 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.
-
How to Build an ETL App for LDAP Objects in Python with CData
Create ETL applications and real-time data pipelines for LDAP in Python with petl.
-
How to Create Power BI Visual Reports with Real-Time Amazon Athena Data
Use CData Power BI Connectors to visualize Amazon Athena in Power BI.
-
Analyze Asana Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Asana from Power Pivot. You will use the Table Import Wizard to load Asana. You can visually build the import query or use any SQL supported by the driver.
-
Use the CData Software ODBC Driver for Google Search in SAS for Real-Time Reporting and Analytics
Connect to real-time Google Search in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Google Search.
-
How to Seamlessly Import Facebook Data into IBM SPSS Modeler
Integrate Facebook data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
DataBind Perplexity Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Perplexity to a chart.
-
Access Highrise Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Highrise CRM.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Facebook Ads
Provide connectivity to Facebook Ads through an SAP BusinessObjects universe.
-
Getting Started with the CData Excel Add-In for Printful
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Printful.
-
Integrate Goose with Live Azure Data Lake Storage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Azure Data Lake Storage from within the local AI agent.
-
Access Salesforce Marketing Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Salesforce Marketing Cloud from HeidiSQL.
-
Easily Integrate Retently Data in Lazarus Pascal IDE
Learn how to easily integrate live Retently in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Automated Continuous Intercom Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Intercom replication to Apache Kafka.
-
Connect to Google Sheets Data in NetBeans
Connect to Google Sheets in NetBeans with the data source configuration wizard.
-
Visualize Monday.com Data in TIBCO Spotfire through ADO.NET
Integrate Monday.com into dashboards in TIBCO Spotfire.
-
Replicate Multiple SAP Netweaver Gateway Accounts via the CData Sync CLI
Replicate multiple SAP Netweaver Gateway accounts to one or many databases.
-
How to Connect to Live PostgreSQL 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 PostgreSQL for you.
-
How to integrate Aha! with Apache Airflow
Access and process Aha! in Apache Airflow using the CData JDBC Driver.
-
Integrate Rebilly Data in the Pentaho Report Designer
Publish reports based on Rebilly in the Pentaho BI tool.
-
How to connect to Rebilly Data from Spring Boot
Connect to Rebilly in a Spring Boot Application using the CData API Driver for JDBC
-
Connect to Microsoft OneDrive Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Microsoft OneDrive in the Denodo Virtual DataPort Administrator.
-
How to Use a Microsoft Access Database to Update Microsoft Teams Data in Real Time
Update Microsoft Teams data by creating a linked table in Microsoft Access with the CData Microsoft Teams ODBC Driver.
-
Build a Simple VCL Application for ClickTime Data
How to build a simple VCL Application to view ClickTime in RAD Studio using the CData ODBC Driver for ClickTime.
-
Build Oracle Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Oracle Database and build visualizations in Tableau.
-
How to Query SendInBlue Data in MySQL Workbench
Execute MySQL queries against live SendInBlue from MySQL Workbench.
-
Integrate Live Salesforce Marketing Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Salesforce Marketing from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Salesforce Marketing Cloud.
-
Easily Integrate Cloudflare Data in Lazarus Pascal IDE
Learn how to easily integrate live Cloudflare in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Automated Clio Data Replication to Teradata
Use CData Sync to Customize and automate Clio replication to Teradata.
-
Connect to and Visualize Live CapsuleCRM Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live CapsuleCRM.
-
How to Connect to Trello Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Trello. Leverage the pyodbc module for ODBC in Python.
-
Use the CData Software ODBC Driver for Coda in MicroStrategy
Connect to Coda in MicroStrategy Developer using the CData Software ODBC Driver for Coda.
-
Connect SendPulse Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your SendPulse using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to Real-Time Odoo Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Odoo and Dataflow to import and use Odoo ERP in Power Apps.
-
Automate Couchbase Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Couchbase and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Build Semantic Layer Views for SQL Analysis Services Data in APOS Live Data Gateway
Use the CData Connector for SQL Analysis Services in APOS Live Data Gateway to build Semantic Layer Views for SQL Analysis Services.
-
Integrating Gumloop with SAP HANA Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on SAP HANA within automated workflows.
-
Working with ZeroBounce Data in LINQPad
Execute LINQ queries to ZeroBounce in LINQPad.
-
Build AI/ML Models with Live Guru Data using Dataiku
Connect Guru Data with Dataiku using the CData API Driver for JDBC.
-
Integrate CampaignMonitor with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate CampaignMonitor with External Services.
-
Automated Continuous Salesforce CRM Analytics Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Salesforce CRM Analytics replication to Apache Cassandra.
-
Back Up Reckon Accounts Hosted to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Reckon Accounts Hosted. In this article, we will employ an SSIS workflow to populate a database with Reckon Accounts Hosted data.
-
Create Reports from Google Ads Data in Looker Studio
Use CData Connect AI to gain access to live Google Ads and create custom reports in Looker Studio.
-
Integrating GitHub Copilot CLI with Brex 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.
-
Migrating data from Sage Cloud Accounting to Databricks using CData SSIS Components.
Easily push Sage Business Cloud Accounting to Databricks using the CData SSIS Tasks for Sage Cloud Accounting and Databricks.
-
Connect to LinkedIn from Asprova with CData Software ODBC Driver for LinkedIn
This article shows how to connect faster to LinkedIn data from Asprova.
-
Access Coda Data from MySQL in Amazon QuickSight
Connect to Coda and build visualizations of Coda using a MySQL Connection in Amazon QuickSight.
-
How to work with Typeform Data in Apache Spark using SQL
Access and process Typeform Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to Live MailChimp Data in MicroStrategy through CData Connect AI
Create a live connection to MailChimp Data in CData Connect AI and connect to your MailChimp from MicroStrategy.
-
Visualize Acumatica 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 Acumatica ERP into TIBCO Spotfire.
-
Build Phoenix-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Apache Phoenix and build Phoenix-connected web apps with Axios.
-
Import Sybase IQ Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Sybase IQ Data and provide access to live Sybase IQ for custom reports in the Power BI Service.
-
DataBind Controls to Azure Synapse Data in Delphi
DataBind to Azure Synapse in Delphi with standard data access components and controls.
-
Build a Singer.io Tap for Tally With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Tally data using
-
Use the CData ODBC Driver for Planio in Microsoft Power Query
You can use the CData Planio ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Planio into Microsoft Power Query.
-
Using the CData Software ODBC Driver for ZohoExpense in PyCharm
Connect to ZohoExpense as an ODBC data source in PyCharm using the CData Software ODBC Driver for ZohoExpense.
-
Build Dashboards with REST Data in DBxtra
Create dynamic dashboards and perform analytics based on REST in DBxtra.
-
How to Connect to Live Epicor Kinetic Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Epicor Kinetic securely in real time.
-
A PostgreSQL Interface for WooCommerce Data using the CData ODBC Driver
Use the SQL Gateway and WooCommerce ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Notion Data in RazorSQL
Connect to Notion from wizards and query Notion from the GUI in the RazorSQL database management tool.
-
Connect to Toggl Data in Aqua Data Studio
Access Toggl from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to publish and share Coinbase Data dashboards with Tableau Server
The CData ODBC driver for Coinbase enables you integrate Coinbase into Tableau dashboards.
-
Create Reports with Hugging Face Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Hugging Face.
-
How to Query Live MYOB AccountRight Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live MYOB AccountRight data in natural language using Python.
-
Import Real-Time ConstantContact Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use ConstantContact in ColdFusion.
-
How to import Bitbucket Data into Apache Solr
Use the CData Software JDBC Driver for Bitbucket in Data Import Handler and create an automated import of Bitbucket to Apache Solr Enterprise Search platform.
-
Connect and Query Live Act-On Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Act-On into Databricks
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for ZohoExpense
Provide connectivity to ZohoExpense through an SAP BusinessObjects universe.
-
Connect to Presto Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Presto.
-
Analyze Azure DevOps Data in Looker
Use CData Connect AI to connect to Azure DevOps Data from Looker and build custom apps using live Azure DevOps.
-
Access Live Blackbaud FE NXT Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Blackbaud FE NXT in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Provide OData Services of SQL Analysis Services Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for SQL Analysis Services by developing a WCF Service Application.
-
DataBind HCL Domino Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for HCL Domino with the DevExpress Windows Forms and Web controls to provide HCL Domino to a chart.
-
DataBind Charts to Mistral AI Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Mistral AI 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.
-
How to Connect DBeaver to SparkPost via a JDBC Driver
Manage SparkPost with visual tools in DBeaver like the query browser.
-
Connect to Teamgate 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 Teamgate and work with Teamgate in your FileMaker application.
-
Connect to SQL Analysis Services Data from a Connection Pool in JBoss
Integrate SQL Analysis Services into Java servlets: Use the Management Console in JBoss to install the SQL Analysis Services JDBC Driver.
-
Create EnterpriseDB-Connected Applications in Appsmith
Connect to EnterpriseDB Data via CData Connect AI in Appsmith and create custom business applications with real-time access to EnterpriseDB.
-
Integrate Perigon with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Perigon with External Services.
-
Getting Started with the CData SSIS Components for Copper
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Copper.
-
Create a Data Access Object for Sage Intacct Data using JDBI
A brief overview of creating a SQL Object API for Sage Intacct in JDBI.
-
Build Lakebase Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Lakebase and build visualizations in Tableau.
-
How to connect to CloudConvert Data from IntelliJ
Integrate connectivity to CloudConvert with wizards in IntelliJ.
-
Integrating Antigravity CLI with Wrike via CData CLI
Connect Wrike to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to update SAP Ariba Source from Excel
This article explains how to transfer data from Excel to SAP Ariba Source using the Excel Add-In for SAP Ariba Source.
-
Viewing Act-On Data in RAD Studio Data Explorer
How to view Act-On in RAD Studio Data Explorer using the CData ODBC Driver for Act-On.
-
Use Microsoft Copilot Studio to talk to your Instagram 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 Instagram for you.
-
Getting Started with the CData Tableau Connector for BigQuery
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for BigQuery.
-
Create Data Visualizations in Cognos BI with Zoom Data
Access Zoom as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Publish SharePoint Excel Services-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live SharePoint Excel Services.
-
Analyze Elasticsearch Data in Looker
Use CData Connect AI to connect to Elasticsearch Data from Looker and build custom apps using live Elasticsearch.
-
Integrating GitHub Copilot CLI with MYOB AccountRight 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.