CData Software - Knowledge Base
Recent Articles
-
Connect to Google Campaign Manager 360 Data from PowerBuilder via JDBC
This article demonstrates how to access Google Campaign Manager 360 from PowerBuilder using the Google Campaign Manager 360 JDBC Driver.
-
Automate AgileCRM Data Replication to SAP HANA
Use CData Sync to customize and automate AgileCRM replication to SAP HANA.
-
How to Connect to Live SAP Fieldglass 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 SAP Fieldglass for you.
-
Prepare, Blend, and Analyze Front Data in Alteryx Designer (ODBC)
Build workflows to access live Front for self-service data analytics.
-
Write a Simple Go Application to work with IBM Cloud Object Storage Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to IBM Cloud Object Storage.
-
Connect to Act CRM Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Act CRM.
-
Analyze Amazon Athena Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Amazon Athena with the CData JDBC Driver for Amazon Athena.
-
Use the CData Software ODBC Driver for Mistral AI in MicroStrategy Web
Connect to Mistral AI in MicroStrategy Web using the CData Software ODBC Driver for Mistral AI.
-
Query Adobe Commerce Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Adobe Commerce and perform CRUD operations on Adobe Commerce from Node.js.
-
Prepare, Blend, and Analyze Google Search Results in Alteryx Designer (ODBC)
Build workflows to access live Google Search for self-service data analytics.
-
Feed Supabase Data into FineReport
How to set Supabase as a JDBC data source in FineReport.
-
Access Live Google Directory Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Google Directory data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
View Reports on Real-Time Hive Data in Power BI Report Server
Use the CData ODBC Driver for Hive to visualize Apache Hive in Power BI Desktop and then publish them to Power BI Report Server.
-
Manage Airtable Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Airtable.
-
Connect to Flowlu Data in Ruby
Connect to Flowlu in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Deploy the ADO.NET Provider for BambooHR on an SSRS Report Server
Connect to BambooHR 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.
-
Analyze Codat Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Codat in Microsoft R Open.
-
Build a Simple VCL Application for SurveyMonkey Data
How to build a simple VCL Application to view SurveyMonkey in RAD Studio using the CData ODBC Driver for SurveyMonkey.
-
Integrate ZohoInvoice Data in the Pentaho Report Designer
Publish reports based on ZohoInvoice in the Pentaho BI tool.
-
Visualize Live Facebook Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Facebook into custom reports in Power BI.
-
Build Microsoft Exchange-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Microsoft Exchange.
-
Publish BigQuery-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Google BigQuery.
-
Use Databricks Agent Bricks to Talk to Your SAS Data Sets Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your SAS Data Sets for you.
-
Publish CockroachDB-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live CockroachDB.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Access actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Prepare, Blend, and Analyze SAS Data Sets Data in Alteryx Designer (ODBC)
Build workflows to access live SAS Data Sets for self-service data analytics.
-
Connect to SAP Fieldglass Data in ACL Analytics
Connect to SAP Fieldglass via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to SAP Fieldglass.
-
Deploy the ADO.NET Provider for Superchat on an SSRS Report Server
Connect to Superchat 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.
-
Integrating LangGraph with MailChimp Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on MailChimp within automated workflows.
-
Automate SAP ByDesign Data Replication to SAP HANA
Use CData Sync to customize and automate SAP Business ByDesign replication to SAP HANA.
-
How to Query Live FormSite Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live FormSite data in natural language using Python.
-
Build Agents in Relevance AI with Access to Live Odoo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Odoo ERP within intelligent agent workflows.
-
Publish Reports with Workable Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Workable.
-
Migrating data from Mailgun to Google BigQuery using CData SSIS Components.
Easily push Mailgun to Google BigQuery using the CData SSIS Tasks for Mailgun and Google BigQuery.
-
Integrating Codex CLI with ZohoDesk 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.
-
Import and Visualize Foursquare Data in Power View
Create data visualizations based on Foursquare in Excel.
-
Connect to Scrapfly Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Scrapfly and work with Scrapfly in your FileMaker applications.
-
Connect to Acumatica Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Acumatica ERP from Filemaker Pro on Mac.
-
Use the CData SSIS Components to Insert New or Update Existing Facebook Records from SQL Server
Easily push SQL Server data to Facebook using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Facebook or update existing records with data from a SQL Server database.
-
Build Apps with Live MariaDB in Adalo using CData Connect AI
Use CData Connect AI to integrate live MariaDB into the Adalo platform and build custom mobile and web applications with real-time MariaDB.
-
Manage Splunk Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Splunk.
-
Prepare, Blend, and Analyze Stack Exchange Data in Alteryx Designer (ODBC)
Build workflows to access live Stack Exchange for self-service data analytics.
-
Establish a Live Connection with Yelp Data using Tableau Bridge
The CData ODBC Driver for Yelp enables you to integrate live Yelp into Tableau Cloud dashboards using the Tableau Bridge.
-
Edit and Search Sybase IQ External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Sybase IQ to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Sybase IQ objects that you can access from apps and the dashboard.
-
Build Dashboards with Anaplan Data in DBxtra
Create dynamic dashboards and perform analytics based on Anaplan in DBxtra.
-
Visualize Live Intercom Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Intercom.
-
Getting Started with the CData Excel Add-In for Google Cloud Storage
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Google Cloud Storage.
-
How to integrate Greenhouse with Apache Airflow
Access and process Greenhouse in Apache Airflow using the CData JDBC Driver.
-
Automated Continuous Exact Online Replication to Databricks
Use CData Sync for automated, continuous, customizable Exact Online replication to Databricks.
-
Connect to Google Contacts Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Google Contacts from Filemaker Pro on Mac.
-
Connect to Trello Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
How to create Postmark federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Postmark in MySQL .
-
Visualize Live SAP Business Warehouse Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live SAP Business Warehouse.
-
Analyze Sentry Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Sentry in Microsoft R Open.
-
Connect to Live Microsoft Ads Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Microsoft Ads in CData Connect AI and connect to your Microsoft Ads from PostgreSQL.
-
Connect to and Visualize Live PhantomBuster Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live PhantomBuster.
-
Getting Started with the CData Tableau Connector for Reckon
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Reckon.
-
Getting Started with the CData Tableau Connector for Microsoft Exchange
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Microsoft Exchange.
-
Import Azure DevOps Data Using Azure Data Factory
Use CData Connect AI to connect to Azure DevOps Data from Azure Data Factory and import live Azure DevOps.
-
Access Live WooCommerce Data in AWS Lambda (with IntelliJ IDEA)
Connect to live WooCommerce in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Build Invoiced-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Invoiced and build web apps with connectivity to live Invoiced.
-
Automated Continuous GitHub Replication to Amazon S3
Use CData Sync for automated, continuous, customizable GitHub replication to Amazon S3.
-
How to connect to Microsoft Entra ID Data in DBVisualizer
Integrate Microsoft Entra ID with visual data analysis tools and data connection wizards in DBVisualizer
-
Use the CData Software ODBC Driver for Billsby in MicroStrategy Web
Connect to Billsby in MicroStrategy Web using the CData Software ODBC Driver for Billsby.
-
Integrate FTP Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to FTP Servers and integrate live FTP Servers into your Power Automate tasks.
-
Connect to Vertica Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Vertica.
-
Visualize Live YouTube Analytics Data in the Power BI Service
Use CData Connect AI to connect to live YouTube Analytics and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connecting Agentforce with Gmail 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 Gmail for you.
-
Use Dash to Build to Web Apps on LightSpeedRetail Data
Create Python applications that use pandas and Dash to build LightSpeedRetail-connected web apps.
-
DataBind Charts to Reckon Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Reckon 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.
-
Visualize OneNote Data in Sisense
Create an ElastiCube in Sisense app with access to Microsoft OneNote.
-
Automated Continuous Lakebase Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Lakebase replication to AlloyDB.
-
Integrate Zoho Inventory with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Zoho Inventory with External Services.
-
DataBind Controls to Gong Data in Delphi
DataBind to Gong in Delphi with standard data access components and controls.
-
Publish Crystal Reports on Dotmailer Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Dotmailer.
-
Moving Data from Nuclia to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Nuclia data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to Vault CRM Data in RazorSQL
Connect to Vault CRM from wizards and query Veeva Vault & Vault CRM from the GUI in the RazorSQL database management tool.
-
Work with REST Data in FoxPro
Load REST into a FoxPro database. This article includes full code and a walk-through of the process.
-
Manage Amazon S3 Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Amazon S3.
-
Validate Guru Data with QuerySurge
Access and validate Guru in QuerySurge using the CData JDBC Driver.
-
Create MailerSend Dataflows on PowerBI.com
Connect to the CData Power BI Connector for MailerSend from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to Work with VWO Data in AWS Glue Jobs Using JDBC
Connect to VWO from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Import and Visualize Paymo Data in Power View
Create data visualizations based on Paymo in Excel.
-
Integrating Claude Code with Sage Intacct Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Sage Intacct within assisted coding and automated development workflows.
-
Connect to HCL Domino Data in RazorSQL
Connect to HCL Domino from wizards and query HCL Domino from the GUI in the RazorSQL database management tool.
-
Visualize Live MarkLogic Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live MarkLogic.
-
Integrate CouchDB Data in the Pentaho Report Designer
Publish reports based on Apache CouchDB in the Pentaho BI tool.
-
Use the CData Software ODBC Driver for Contentful in MicroStrategy
Connect to Contentful in MicroStrategy Developer using the CData Software ODBC Driver for Contentful.
-
How to Connect to & Open Grafana Data in Microsoft Excel
This article uses the CData ODBC driver for Grafana to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Migrating data from Redshift to Databricks using CData SSIS Components.
Easily push Amazon Redshift to Databricks using the CData SSIS Tasks for Redshift and Databricks.
-
Integrate Live Azure Synapse Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Stream MYOB AccountRight Data into Apache Kafka Topics
Access and stream MYOB AccountRight in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to load Confluence data into Elasticsearch via Logstash
Introducing a simple method to load Confluence data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrate with Google Spanner Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Google Spanner to a JSON file on disk.
-
Access Contentful Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Contentful from HeidiSQL.
-
Connect to SAP BusinessObjects BI Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for SAP BusinessObjects BI in Airbyte.
-
Connect to PingOne Data in DBeaver
Use the CData ODBC Driver to connect to PingOne in DBeaver.
-
How to Connect to & Open Workday Data in Microsoft Excel
This article uses the CData ODBC driver for Workday to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Getting Started with the CData ADO.NET Provider for Todoist
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Consume Basecamp OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Basecamp feeds that reflect any changes in SAP Lumira.