CData Software - Knowledge Base
Recent Articles
-
Connect to YouTube Analytics Data in NetBeans
Connect to YouTube Analytics in NetBeans with the data source configuration wizard.
-
Access SAP SuccessFactors LMS 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 SAP SuccessFactors LMS.
-
Integrate Cursor with Live Zuora Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Zuora from within the editor.
-
Write a Simple Go Application to work with ShipStation Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to ShipStation.
-
How to connect to Sage 200 Data from Spring Boot
Connect to Sage 200 in a Spring Boot Application using the CData JDBC Driver for Sage 200
-
Use Biml to Build SSIS Tasks to Replicate MailerSend Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate MailerSend to SQL Server.
-
Use Microsoft Copilot Studio to talk to your Airtable 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 Airtable for you.
-
Connect to PDFMonkey Data in NetBeans
Connect to PDFMonkey in NetBeans with the data source configuration wizard.
-
How to Access Live ScrapingBee Data in Power Automate Desktop via ODBC
The CData ODBC Driver for ScrapingBee enables you to integrate ScrapingBee into workflows built using Microsoft Power Automate Desktop.
-
How to Access BigCommerce Data Using Entity Framework
This article shows how to access BigCommerce using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Integrating Claude Code with CSV Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on CSV/TSV Files within assisted coding and automated development workflows.
-
Getting Started with the CData Power BI Connector for Ontraport
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Import Real-Time Okta Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Okta in ColdFusion.
-
Moving Data from Omnisend to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Omnisend data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Build AI Agents with SQL Server 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 SQL Server through CData Connect AI.
-
Publish Grafana-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Grafana.
-
Automated Continuous ZohoExpense Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable ZohoExpense replication to Apache Kafka.
-
Publish Aweber-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Aweber.
-
How to Query Live Reckon Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Reckon data in natural language using Python.
-
Build Apps with Live MariaDB Data Using the Low-Code Development Platform of Mendix
Connect MariaDB with Mendix to build apps using the CData JDBC Driver for MariaDB.
-
Create SAP Concur Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time SAP Concur data access from reports, embedded analytics, and more.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Google Ad Manager within intelligent workflows.
-
Automated Continuous Elorus Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Elorus replication to Amazon Redshift.
-
Connect to HDFS Data in CloverDX (formerly CloverETL)
Transfer Apache HDFS using the visual workflow in the CloverDX data integration tool.
-
Build OData-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to OData and build web apps with connectivity to live OData.
-
Connect to Salesforce Pardot Data in RapidMiner
Integrate Salesforce Pardot with standard components and data source configuration wizards in RapidMiner Studio.
-
Use Azure AI Foundry to Talk to Your Twitter Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Twitter Ads for you.
-
How to Easily Query Stack Exchange Data in OpenOffice Base
Connect to Stack Exchange data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Visualize Parquet Data in Tableau
The CData ODBC driver for Parquet enables you integrate Apache Parquet into Tableau dashboards.
-
Work with Gmail Data in FoxPro
Load Gmail into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to SendGrid Data in JRuby
Create a simple JRuby app with access to live SendGrid.
-
Connect to SendInBlue Data in CloverDX (formerly CloverETL)
Transfer SendInBlue using the visual workflow in the CloverDX data integration tool.
-
Bidirectional Access to LinkedIn Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate LinkedIn in Filemaker Pro for Mac or Windows.
-
Import Real-Time GitLab Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use GitLab in ColdFusion.
-
Automate HubDB Data Replication to Azure Data Lake
Use CData Sync to customize and automate HubDB replication to Azure Data Lake.
-
Integrating Cursor CLI with Clockify 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.
-
Integrate Theia IDE with Live Sage 200 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Use the CData Software ODBC Driver for Clio in MicroStrategy
Connect to Clio in MicroStrategy Developer using the CData Software ODBC Driver for Clio.
-
Build Charts with Productboard Data in Clear Analytics
Create dynamic charts and perform analytics based on Productboard in Clear Analytics.
-
Connect to and Query Quickbase Data in QlikView over ODBC
Create data visualizations with Quickbase in QlikView.
-
Integrate Aweber with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Aweber with External Services.
-
Query Facebook Ads Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Facebook Ads entities in PHP by modeling them as objects.
-
Connect to EnterpriseDB Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with EnterpriseDB Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
DataBind Controls to Mixpanel Data in C++Builder
DataBind to Mixpanel in C++Builder with standard components and controls.
-
Use the CData Software ODBC Driver for Shippo in MicroStrategy
Connect to Shippo in MicroStrategy Developer using the CData Software ODBC Driver for Shippo.
-
Connect to Email in SpagoBI
Create reports featuring live Email in SpagoBI Studio. Host Email reports on SpagoBI Server.
-
Create Dropbox-Connected Dashboards in Grafana
Connect to Dropbox Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Dropbox.
-
Analyze Lakebase Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Lakebase from Power Pivot. You will use the Table Import Wizard to load Lakebase. You can visually build the import query or use any SQL supported by the driver.
-
Import Real-Time Deel Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Deel in ColdFusion.
-
Create Informatica Mappings From/To a JDBC Data Source for MariaDB
Create MariaDB data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Build AI/ML Models with Live ShipEngine Data using Dataiku
Connect ShipEngine Data with Dataiku using the CData API Driver for JDBC.
-
How to connect to Insightly Data from IntelliJ
Integrate connectivity to Insightly with wizards in IntelliJ.
-
Replicate Cloudflare Data from PowerShell
Write a quick PowerShell script to query Cloudflare. Use connectivity to the live data to replicate Cloudflare to SQL Server.
-
Getting Started with the CData SSIS Components for Odoo
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Odoo.
-
How to Query Live XML Data in Perplexity MacOS Desktop
Connect to and query live XML Data in Perplexity Desktop using CData MCP Server.
-
How to Query Live Google Search Results in Perplexity MacOS Desktop
Connect to and query live Google Search Results in Perplexity Desktop using CData MCP Server.
-
Use JayDeBeApi to access Oracle Eloqua Reporting Data in Python
Use standard Python scripting and the development environment of your choice to access live Oracle Eloqua Reporting.
-
Build AI/ML Models with Live Tally Data using Dataiku
Connect Tally Data with Dataiku using the CData JDBC Driver for Tally.
-
Use the CData Software JDBC Driver for Oracle Eloqua Reporting in MicroStrategy
Connect to Oracle Eloqua Reporting in MicroStrategy Developer using the CData Software JDBC Driver for Oracle Eloqua Reporting.
-
Moving Data from Google Cloud Storage to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Google Cloud Storage data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Google Cloud Storage Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Google Cloud Storage facts in real time.
-
Update Required: HubSpot Connectivity
HubSpot is modifying the contacts scope of their API and CData has updated the OAuth implentation for their HubSpot connectivity solutions to accommodate.
-
Build Amazon Athena-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Amazon Athena.
-
Connect to SAP SuccessFactors LMS Data from AWS Glue
Use CData Connect AI to gain access to live SAP SuccessFactors LMS from your AWS Glue jobs.
-
Automated Continuous Flowlu Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Flowlu replication to Amazon Redshift.
-
Deploy the ADO.NET Provider for Workable on an SSRS Report Server
Connect to Workable 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.
-
Natively Connect to Hugging Face Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Hugging Face. Leverage the native support for ODBC in PHP.
-
Publish Crystal Reports on Printful Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Printful.
-
Build MVC Applications with Connectivity to SharePoint Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access SharePoint from an ASP.NET MVC application.
-
Integrating Bitbucket Data in Talend Cloud Data Management Platform
Connect Bitbucket Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Bitbucket.
-
How to Connect Authorize.Net Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Authorize.Net data in real time using natural language.
-
Automated Continuous Perplexity Replication to Snowflake
Use CData Sync for automated, continuous, customizable Perplexity replication to Snowflake.
-
Build Data Flows from SQL Server to TaxJar through SSIS
Easily push SQL Server data to TaxJar using the CData SSIS Tasks for TaxJar.
-
How to Connect DBeaver to ConstantContact via a JDBC Driver
Manage ConstantContact with visual tools in DBeaver like the query browser.
-
Integrating Boomi Agentstudio with Exact Online Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Exact Online, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Publish Reports with Tally Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Tally ERP.
-
Import Jira Assets Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Jira Assets. In this article, you will use the OData format to import Jira Assets into Microsoft Power Query.
-
Design BIRT Reports on SpaceX Data
Provide current SpaceX to your embedded analytics.
-
Getting Started with the CData Tableau Connector for Office 365
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Office 365.
-
Create Apps from PayPal Data in Qlik Sense Cloud
Use CData Connect AI to connect to PayPal Data and build apps from live PayPal in Qlik Sense Cloud.
-
Visualize Oracle Sales Data in Tableau
The CData ODBC driver for Oracle Sales enables you integrate Oracle Sales into Tableau dashboards.
-
Load HubSpot Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load HubSpot to a database.
-
Connecting Pipedream with Oracle Financials Cloud Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Oracle Financials Cloud data in real time.
-
How to Connect the Power BI Service to Chargebee: Complete Guide
Connect to the CData Software Power BI Connector for Chargebee from PowerBI.com to provide real-time Chargebee across the organization.
-
Connect to Browserless Data in DBeaver
Use the CData ODBC Driver to connect to Browserless in DBeaver.
-
Build Google Analytics-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Google Analytics to explore live Google Analytics Data in Gemini Code Assist to assist with building Google Analytics-powered applications.
-
Access ElevenLabs 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 ElevenLabs.
-
Automate BigCommerce Data Replication to Azure Data Lake
Use CData Sync to customize and automate BigCommerce replication to Azure Data Lake.
-
Connect to and Query Monday.com Data in QlikView over ODBC
Create data visualizations with Monday.com in QlikView.
-
Publish Perplexity-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Perplexity.
-
How to Connect to Live Authorize.Net Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Authorize.Net securely in real time.
-
Use Biml to Build SSIS Tasks to Replicate BigCommerce Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate BigCommerce to SQL Server.
-
Visualize Live Avalara AvaTax Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Avalara AvaTax using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrating Claude Code CLI with Couchbase 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.
-
Build Charts with Procore Data in Clear Analytics
Create dynamic charts and perform analytics based on Procore in Clear Analytics.
-
Create Data Visualizations in Cognos BI with Klaviyo Data
Access Klaviyo as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Use the CData Software JDBC Driver for Gmail in MicroStrategy Web
Connect to Gmail in MicroStrategy Web using the CData Software JDBC Driver for Gmail.
-
Integrate Act-On with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Act-On with External Services.
-
Use the CData ODBC Driver for Basecamp from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Basecamp to connect to Basecamp from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Basecamp in Excel.
-
Automate Google Ads Data Replication to Couchbase
Use CData Sync to Customize and automate Google Ads replication to Couchbase.