CData Software - Knowledge Base
Recent Articles
-
Use the CData API Server to Access TaxJar Data in Microsoft PowerPivot
Use the CData API Server to connect to live TaxJar in the Power Pivot business intelligence tool.
-
Create Freshdesk-Connected Business Apps in AppSheet
Connect to Freshdesk Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Freshdesk.
-
Integrate with Snapchat Ads Data in JReport Designer
Create charts and reports based on Snapchat Ads in JReport Designer.
-
Create Couchbase-Connected Applications in Appsmith
Connect to Couchbase Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Couchbase.
-
Extract, Transform, and Load Chargebee Data in Informatica PowerCenter
Create a simple Workflow for Chargebee in Informatica PowerCenter.
-
Build Data Flows from Airtable to SQL Server using SSIS
Easily back up Airtable to SQL Server using the SSIS components for Airtable.
-
Connect to SAS xpt Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for SAS XPORT in the Denodo Virtual DataPort Administrator.
-
Use CData Connect AI to Access Slack Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Slack in the Power Pivot business intelligence tool.
-
Connect to Marketo Data in JRuby
Create a simple JRuby app with access to live Marketo.
-
Create Dynamic Mailgun Grids Using the Infragistics XamDataGrid
Learn how you can connect Mailgun to Infragistics XamDataGrid to build dynamic grids.
-
LINQ to ClickTime Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the ClickTime Data Provider.
-
Create Power BI Reports on Real-Time Oracle Financials Cloud Data
Use the CData ODBC Driver for Oracle Financials Cloud to visualize Oracle Financials Cloud in Power BI Desktop.
-
Bridge Drift Connectivity with Apache NiFi
Access and process Drift in Apache NiFi using the CData JDBC Driver.
-
Integrating Cursor CLI with Insightly 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 Ariba Source Data in Looker
Use CData Connect AI to connect to SAP Ariba Source Data from Looker and build custom apps using live SAP Ariba Source.
-
How to Easily Query CampaignMonitor Data in OpenOffice Base
Connect to CampaignMonitor data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Object-Relational Mapping (ORM) with Wave Financial 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 Wave Financial into a Java-based ORM framework, Hibernate.
-
Create Act-On Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Act-On from PowerBI.com to create Power BI Dataflows with real-time data.
-
Design BIRT Reports on Procore Data
Provide current Procore to your embedded analytics.
-
Replicate Multiple PabblySubscriptions Accounts
Replicate multiple PabblySubscriptions accounts to one or many databases.
-
Connect to SpaceX from Asprova with CData Software ODBC Driver for SpaceX
This article shows how to connect faster to SpaceX data from Asprova.
-
Integrating Codex CLI with Sugar CRM 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 MariaDB Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for MariaDB from Power Pivot. You will use the Table Import Wizard to load MariaDB. You can visually build the import query or use any SQL supported by the driver.
-
Integrate Live Zoho Recruit Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Zoho Recruit to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Analyze SQL Server Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for SQL Server from Power Pivot. You will use the Table Import Wizard to load Microsoft SQL Server. You can visually build the import query or use any SQL supported by the driver.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Azure Cosmos DB within intelligent workflows.
-
Integrate with Microsoft Entra ID Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Microsoft Entra ID in SnapLogic.
-
Access SparkPost Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SparkPost from your Oracle system.
-
Visualize Live Oracle Sales Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Oracle Sales.
-
Build Apps with Live SAP ByDesign Data Using the Low-Code Development Platform of Mendix
Connect SAP Business ByDesign with Mendix to build apps using the CData JDBC Driver for SAP ByDesign.
-
Create Reports with HCL Domino Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date HCL Domino.
-
Trigger Excel Online IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Excel Online with standard wizards in Logic Apps.
-
Connect to Coda from Asprova with CData Software ODBC Driver for Coda
This article shows how to connect faster to Coda data from Asprova.
-
Connect to SAP Concur Data from Crystal Reports
Use CData Connect AI to connect to and report on live SAP Concur from Crystal Reports.
-
Access ZohoDesk Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access ZohoDesk from your Oracle system.
-
Connect to ZohoMarketingHub Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for ZohoMarketingHub.
-
Connect to VWO Data in DBeaver
Use the CData ODBC Driver to connect to VWO in DBeaver.
-
How to create an RPA flow for Dynamics NAV Data in UiPath Studio
Use the Dynamics NAV ODBC Driver to create workflows that access real-time Microsoft Dynamics NAV without any coding.
-
Integrating Claude Code with Oracle SCM Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Oracle SCM within assisted coding and automated development workflows.
-
How to Import Data from ActiveCampaign into Google Sheets
Import ActiveCampaign into a Google spreadsheet that is automatically refreshed.
-
Connect Google Contacts to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Google Contacts with IBM WebSphere for seamless data integration and connectivity.
-
Build Visualizations of Postmark Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Postmark in Birst.
-
Use the CData Software JDBC Driver for PayPal in MicroStrategy
Connect to PayPal in MicroStrategy Developer using the CData Software JDBC Driver for PayPal.
-
Connect and Query Live Elasticsearch Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Elasticsearch into Databricks
-
Create SSAS Tabular Models from Coinbase Data
How to build a SQL Server Analysis Service Tabular Model from Coinbase using CData drivers.
-
Automated Continuous Pipedrive Replication to Vertica
Use CData Sync for automated, continuous, customizable Pipedrive replication to Vertica.
-
Use Microsoft Copilot Studio to talk to your CSV 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 CSV/TSV Files for you.
-
DataBind Controls to Reply.io Data in Delphi
DataBind to Reply.io in Delphi with standard data access components and controls.
-
View Reports on Real-Time Contentful Data in Power BI Report Server
Use the CData ODBC Driver for Contentful to visualize Contentful in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to Gmail Data in Claris FileMaker Pro
Use the CData ODBC Driver for Gmail in FileMaker Pro to connect to Gmail and work with Gmail in your FileMaker applications.
-
Build SAP Business One-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for SAP Business One to explore live SAP Business One Data in GitHub Copilot to assist with building SAP Business One-powered applications.
-
Migrating data from Mailgun to Databricks using CData SSIS Components.
Easily push Mailgun to Databricks using the CData SSIS Tasks for Mailgun and Databricks.
-
Create Dynamic Sendwithus Grids Using the Infragistics XamDataGrid
Learn how you can connect Sendwithus to Infragistics XamDataGrid to build dynamic grids.
-
How to Import Data from Airtable into Google Sheets
Import Airtable into a Google spreadsheet that is automatically refreshed.
-
Connect to Missive Data from PowerBuilder via ADO.NET
This article demonstrates how to access Missive from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Create Apps from Microsoft Ads Data in Qlik Sense Cloud
Use CData Connect AI to connect to Microsoft Ads Data and build apps from live Microsoft Ads in Qlik Sense Cloud.
-
Object-Relational Mapping (ORM) with Microsoft Dataverse 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 Microsoft Dataverse (CDS) into a Java-based ORM framework, Hibernate.
-
Automated Continuous PagerDuty Replication to Vertica
Use CData Sync for automated, continuous, customizable PagerDuty replication to Vertica.
-
Build a Singer.io Tap for Pipeline CRM With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Pipeline CRM data using
-
How to load Dotmailer data into Elasticsearch via Logstash
Introducing a simple method to load Dotmailer data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Create Dashboards and Visualize Live Databricks Data in Geckoboard
Use CData Connect AI to connect to live Databricks and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Google Sheets using the Model Context Protocol.
-
How to connect to LaunchDarkly Data with Squirrel SQL client
Connect to LaunchDarkly and execute queries in the Squirrel SQL Client.
-
Establish a Live Connection with Bugsnag Data using Tableau Bridge
The CData ODBC Driver for Bugsnag enables you to integrate live Bugsnag into Tableau Cloud dashboards using the Tableau Bridge.
-
Build AI/ML Models with Live Couchbase Data using Dataiku
Connect Couchbase Data with Dataiku using the CData JDBC Driver for Couchbase.
-
Build MVC Applications with Connectivity to Anaplan Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Anaplan from an ASP.NET MVC application.
-
Create Informatica Mappings From/To a JDBC Data Source for Microsoft Dataverse
Create Microsoft Dataverse data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
LINQ to Klipfolio Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Klipfolio Data Provider.
-
Back Up OpenWeatherMap 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 OpenWeatherMap data.
-
Use Microsoft Copilot Studio to talk to your Adobe Analytics 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 Adobe Analytics for you.
-
Migrating data from Yelp to Databricks using CData SSIS Components.
Easily push Yelp to Databricks using the CData SSIS Tasks for Yelp and Databricks.
-
Import JSON Services into the Power BI Service for Visualizations
Use CData Connect AI to connect to JSON Services and provide access to live JSON for custom reports in the Power BI Service.
-
Connect and Query Live SendGrid Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live SendGrid into Databricks
-
Import Sybase Data Using Azure Data Factory
Use CData Connect AI to connect to Sybase Data from Azure Data Factory and import live Sybase.
-
Use the CData Software JDBC Driver for Keap in MicroStrategy Desktop
Connect to Keap in MicroStrategy Desktop using the CData Software JDBC Driver for Keap.
-
Connect to SendPulse Data from a Connection Pool in Jetty
The SendPulse JDBC Driver supports connection pooling: This article shows how to connect faster to SendPulse from Web apps in Jetty.
-
Explore Geographical Relationships in BigQuery Data with Power Map
Create data visualizations with Google BigQuery in Power Map.
-
Use Azure AI Foundry to Talk to Your Tally 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 Tally ERP for you.
-
Getting Started with the CData SSIS Components for ScrapingBee
Complete guide to installing, licensing, and connecting with the CData SSIS Components for ScrapingBee.
-
Access Live CSV Data in AWS Lambda
Connect to live CSV/TSV Files in AWS Lambda using the CData JDBC Driver.
-
Connect to Freshdesk Data from Crystal Reports
Use CData Connect AI to connect to and report on live Freshdesk from Crystal Reports.
-
Visualize Live WordPress Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live WordPress.
-
CData Connectors Support the LAG() Window Function
CData Drivers & Connectors include support for the LAG() window function for more comprehensive and powerful querying capabilities.
-
Build Charts with MYOB AccountRight Data in Clear Analytics
Create dynamic charts and perform analytics based on MYOB AccountRight in Clear Analytics.
-
Connect to MongoDB Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for MongoDB and the Script function in FileMaker Pro to connect to MongoDB and work with MongoDB in your FileMaker application.
-
Connect to Databricks Data in RapidMiner
Integrate Databricks with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrating Kiro CLI with Oracle SCM 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 Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live ActiveCampaign within intelligent workflows.
-
A PostgreSQL Interface for Guru Data using the CData ODBC Driver
Use the SQL Gateway and Guru ODBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate BambooHR Data into Power Automate Desktop using CData Connect
CData Connect for BambooHR Data enables you to integrate BambooHR into workflows built using Microsoft Power Automate Desktop.
-
Integrate Guru with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Guru with External Services.
-
Establish a Live Connection with ZendeskSell Data using Tableau Bridge
The CData ODBC Driver for ZendeskSell enables you to integrate live ZendeskSell into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to Facebook Ads Data in DBeaver
Use the CData ODBC Driver to connect to Facebook Ads in DBeaver.
-
Use JayDeBeApi to access CircleCI Data in Python
Use standard Python scripting and the development environment of your choice to access live CircleCI.
-
Access Live Suadeo Data in AWS Lambda
Connect to live Suadeo in AWS Lambda using the CData JDBC Driver.
-
How to Connect to Live Klaviyo Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Klaviyo for you.
-
Integrate with ConstantContact Data in JReport Designer
Create charts and reports based on ConstantContact in JReport Designer.
-
Automated ChargeOver Data Replication to Teradata
Use CData Sync to Customize and automate ChargeOver replication to Teradata.
-
Connect to Delighted Data in NetBeans
Connect to Delighted in NetBeans with the data source configuration wizard.
-
Connect to Dotmailer Data from a Connection Pool in Jetty
The Dotmailer JDBC Driver supports connection pooling: This article shows how to connect faster to Dotmailer from Web apps in Jetty.