CData Software - Knowledge Base
Recent Articles
-
How to integrate Humanity with Apache Airflow
Access and process Humanity in Apache Airflow using the CData JDBC Driver.
-
How to Connect DBeaver to Google Contacts via a JDBC Driver
Manage Google Contacts with visual tools in DBeaver like the query browser.
-
Use CData Connect AI to Access MySQL Data in Microsoft Power Pivot
Use CData Connect AI to connect to live MySQL in the Power Pivot business intelligence tool.
-
Connect to Helpscout Data in RapidMiner
Integrate Helpscout with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to ActiveCampaign Data in RapidMiner
Integrate ActiveCampaign with standard components and data source configuration wizards in RapidMiner Studio.
-
How to import Freshteam Data into Apache Solr
Use the CData Software JDBC Driver for Freshteam in Data Import Handler and create an automated import of Freshteam to Apache Solr Enterprise Search platform.
-
Connect to Oracle HCM Cloud Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Oracle HCM Cloud and the Script function in FileMaker Pro to connect to Oracle HCM Cloud and work with Oracle HCM Cloud in your FileMaker application.
-
Build Visualizations of Couchbase Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Couchbase in Birst.
-
Integrate WooCommerce Data in the Pentaho Report Designer
Publish reports based on WooCommerce in the Pentaho BI tool.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Smartsheet actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Integrate LibreChat with Live Microsoft Planner Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Microsoft Planner from within the chat interface.
-
Visualize Salesforce Data 360 Data in Tableau
The CData ODBC driver for Salesforce Data 360 enables you integrate Salesforce Data 360 into Tableau dashboards.
-
Connect to Klaviyo Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Klaviyo Data and connect to Klaviyo in Akorbi Digital RunMyProcess.
-
How to connect to Shippo Data from Spring Boot
Connect to Shippo in a Spring Boot Application using the CData API Driver for JDBC
-
ETL Salesforce Marketing in Oracle Data Integrator
This article shows how to transfer Salesforce Marketing Cloud into a data warehouse using Oracle Data Integrator.
-
Publish Reports with Twitter Ads Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Twitter Ads.
-
Connect to and Visualize Live Bugsnag Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Bugsnag.
-
How to connect Amazon QuickSight to Apollo Data
Create a connection to Apollo in CData Connect AI and insert Apollo into Amazon QuickSight SPICE to build interactive dashboards.
-
Create Reports from Paylocity Data in Looker Studio
Use CData Connect AI to gain access to live Paylocity and create custom reports in Looker Studio.
-
Access Slack Data from MySQL in PHP
Connect to Slack through the standard MySQL libraries in PHP.
-
How to Connect to & Open SAP Concur Data in Microsoft Excel
This article uses the CData ODBC driver for SAP Concur to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Bind Live PayPal Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live PayPal data
-
Using the CData Software ODBC Driver for Blackbaud FE NXT in PyCharm
Connect to Blackbaud FE NXT as an ODBC data source in PyCharm using the CData Software ODBC Driver for Blackbaud FE NXT.
-
Automated Continuous Microsoft Teams Replication to SQLite
Use CData Sync for automated, continuous, customizable Microsoft Teams replication to SQLite.
-
Visualize Postmark Data in Sisense
Create an ElastiCube in Sisense app with access to Postmark.
-
Edit and Search SQL Analysis Services External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of SQL Analysis Services to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create SQL Analysis Services objects that you can access from apps and the dashboard.
-
Extend Google Sheets with Excel Online Data
Make calls to Excel Online from Google Apps Script via the API Server.
-
Connect to Pingdom in SpagoBI
Create reports featuring live Pingdom in SpagoBI Studio. Host Pingdom reports on SpagoBI Server.
-
Access Live AlloyDB Data in Coginiti Pro
Connect to and query live Google AlloyDB from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Migrating data from SharePoint Excel Services to Google BigQuery using CData SSIS Components.
Easily push SharePoint Excel Services to Google BigQuery using the CData SSIS Tasks for SharePoint Excel Services and Google BigQuery.
-
Create Dashboards and Visualize Live SAP Business One Data in Geckoboard
Use CData Connect AI to connect to live SAP Business One and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Build Semantic Layer Views for Dynamics 365 Data in APOS Live Data Gateway
Use the CData Connector for Dynamics 365 in APOS Live Data Gateway to build Semantic Layer Views for Microsoft Dynamics 365.
-
Use the CData Software JDBC Driver for Phoenix in MicroStrategy Web
Connect to Apache Phoenix in MicroStrategy Web using the CData Software JDBC Driver for Phoenix.
-
Create Datasets from Accelo in Domo Workbench and Build Visualizations of Accelo Data in Domo
Use the CData Software ODBC Driver for Accelo to create datasets from Accelo in Domo Workbench and then build visualizations in the Domo service.
-
Connect to Humanity Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Humanity in the Denodo Virtual DataPort Administrator.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live OData using the Model Context Protocol.
-
ETL Browserless in Oracle Data Integrator
This article shows how to transfer Browserless into a data warehouse using Oracle Data Integrator.
-
How to Visualize Splunk Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Splunk in Python.
-
Automated Continuous OData Services Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable OData replication to OneLake in Microsoft Fabric.
-
Integrating GitHub Copilot CLI with Amazon Marketplace 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 Odoo Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Odoo ERP and visualize Odoo ERP in SAP Analytics Cloud.
-
Feed DocuSign Data into FineReport
How to set DocuSign as a JDBC data source in FineReport.
-
How to publish and share Drift Data dashboards with Tableau Server
The CData ODBC driver for Drift enables you integrate Drift into Tableau dashboards.
-
Access Live MYOB AccountRight Data in AWS Lambda (with IntelliJ IDEA)
Connect to live MYOB AccountRight in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Build MVC Applications with Connectivity to Elasticsearch Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Elasticsearch from an ASP.NET MVC application.
-
How to Work with Google Ads Data in ETL Validator JDBC
Connect to Google Ads from ETL Validator jobs using the CData Software JDBC Driver.
-
Visualize Templated Data in Sisense
Create an ElastiCube in Sisense app with access to Templated.
-
Access Live Outreach.io Data in TIBCO Data Virtualization
Use the Outreach.io Tibco DV Adapter to create a Outreach.io data source in TIBCO Data Virtualization Studio and gain access to live Outreach.io from your TDV Server.
-
Rapidly Develop Drift-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Drift.
-
Create Apps from Impala Data in Qlik Sense Cloud
Use CData Connect AI to connect to Impala Data and build apps from live Apache Impala in Qlik Sense Cloud.
-
Automated Continuous OData Replication to SQLite
Use CData Sync for automated, continuous, customizable OData replication to SQLite.
-
Use the CData Software JDBC Driver for Perigon in MicroStrategy Desktop
Connect to Perigon in MicroStrategy Desktop using the CData Software JDBC Driver for Perigon.
-
Explore Geographical Relationships in YouTube Analytics Data with Power Map
Create data visualizations with YouTube Analytics in Power Map.
-
How to publish and share Oracle Eloqua Reporting Data dashboards with Tableau Server
The CData ODBC driver for Oracle Eloqua Reporting enables you integrate Oracle Eloqua Reporting into Tableau dashboards.
-
A PostgreSQL Interface for Chargebee Data (MySQL Remoting via JDBC)
Use the Remoting features of the Chargebee JDBC Driver to create a PostgreSQL entry-point for data access.
-
A Comparison of JDBC & ODBC Drivers for Amazon Athena
A performance comparison of the CData JDBC Driver and ODBC Driver for Amazon Athena and the Amazon-supported Athena JDBC Driver and ODBC Driver.
-
How to Seamlessly Import Couchbase Data into IBM SPSS Modeler
Integrate Couchbase data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Integrate Live Zoho Creator Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Connect to Live SendGrid Data in MicroStrategy through CData Connect AI
Create a live connection to SendGrid Data in CData Connect AI and connect to your SendGrid from MicroStrategy.
-
Replicate Amazon Marketplace Data to Multiple Databases via the CData Sync CLI
Replicate Amazon Marketplace to disparate databases with a single configuration.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Couchbase
Provide connectivity to Couchbase through an SAP BusinessObjects universe.
-
Automate Contentful Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Contentful from PowerShell? This article demonstrates how to utilize the Contentful Cmdlets for tasks like connecting to Contentful, automating operations, downloading data, and more.
-
Integrate SharePoint Excel Services Data in the Pentaho Report Designer
Publish reports based on SharePoint Excel Services in the Pentaho BI tool.
-
Easily Integrate SAP ByDesign Data in Lazarus Pascal IDE
Learn how to easily integrate live SAP Business ByDesign in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to Microsoft Dataverse Data in Google Apps Script via Connect AI
Use CData Connect AI to access Microsoft Dataverse (CDS) in Google Apps Script.
-
Build Dashboards with Drip Data in DBxtra
Create dynamic dashboards and perform analytics based on Drip in DBxtra.
-
Integrate FTP Data in the Pentaho Report Designer
Publish reports based on FTP Servers in the Pentaho BI tool.
-
Build AI/ML Models with Live Sage Cloud Accounting Data using Dataiku
Connect Sage Cloud Accounting Data with Dataiku using the CData JDBC Driver for Sage Cloud Accounting.
-
Automated Continuous Redis Replication to SingleStore
Use CData Sync for automated, continuous, customizable Redis replication to SingleStore.
-
Connect to Airtable Data from PowerBuilder via JDBC
This article demonstrates how to access Airtable from PowerBuilder using the Airtable JDBC Driver.
-
Build Semantic Layer Views for Sage 200 Data in APOS Live Data Gateway
Use the CData Connector for Sage 200 in APOS Live Data Gateway to build Semantic Layer Views for Sage 200.
-
Connect to Billsby Data in JRuby
Create a simple JRuby app with access to live Billsby.
-
Connect to Coda Data in DBeaver
Use the CData ODBC Driver to connect to Coda in DBeaver.
-
Connecting GenSpark with SAP ByDesign Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to SAP Business ByDesign without any replication or custom integration required.
-
How to Easily Query Paymo Data in OpenOffice Base
Connect to Paymo data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Prepare, Blend, and Analyze Zoho Inventory Data in Alteryx Designer (Connect AI)
Build workflows to access live Zoho Inventory for self-service data analytics.
-
Migrating data from Gorgias to Databricks using CData SSIS Components.
Easily push Gorgias to Databricks using the CData SSIS Tasks for Gorgias and Databricks.
-
Connect to Google Ads Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Google Ads in the Denodo Virtual DataPort Administrator.
-
Create Google Directory-Connected Applications in Appsmith
Connect to Google Directory Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Google Directory.
-
A PostgreSQL Interface for Microsoft Entra ID Data (MySQL Remoting via JDBC)
Use the Remoting features of the Microsoft Entra ID JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating Kiro CLI with LinkedIn Ads 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.
-
Create Informatica Mappings From/To a JDBC Data Source for SAP Fieldglass
Create SAP Fieldglass data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Query GitLab Data in DataGrip
Create a Data Source for GitLab in DataGrip and use SQL to query live GitLab.
-
How to Connect to Live Airtable Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Airtable securely in real time.
-
Getting Started with the CData JDBC Driver for PabblySubscriptions
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for PabblySubscriptions.
-
Connect to Greenhouse Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Greenhouse and the Script function in FileMaker Pro to connect to Greenhouse and work with Greenhouse in your FileMaker application.
-
ETL OpenWeatherMap in Oracle Data Integrator
This article shows how to transfer OpenWeatherMap into a data warehouse using Oracle Data Integrator.
-
Connect to Live Instagram Data in MicroStrategy through CData Connect AI
Create a live connection to Instagram Data in CData Connect AI and connect to your Instagram from MicroStrategy.
-
Automated Continuous SAP Hybris C4C Replication to Vertica
Use CData Sync for automated, continuous, customizable SAP Hybris C4C replication to Vertica.
-
Integrate Raisers Edge NXT Data in the Pentaho Report Designer
Publish reports based on Raisers Edge NXT in the Pentaho BI tool.
-
Integrating Dataiku with Greenplum Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Pivotal GreenPlum.
-
Getting Started with the CData ADO.NET Provider for Azure Table
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Azure Table.
-
Use the CData ODBC Driver for Dotmailer in Microsoft Power Query
You can use the CData Dotmailer ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Dotmailer into Microsoft Power Query.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Snapchat Ads
Provide connectivity to Snapchat Ads through an SAP BusinessObjects universe.
-
Connect to Real-Time eBay Analytics Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for eBay Analytics and Dataflow to import and use eBay Analytics in Power Apps.
-
Integrate Jumpseller Data in the Pentaho Report Designer
Publish reports based on Jumpseller in the Pentaho BI tool.
-
Extract, Transform, and Load Sendwithus Data in Informatica PowerCenter
Create a simple Workflow for Sendwithus in Informatica PowerCenter.
-
Integrating Dataiku with Amazon Marketplace Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Amazon Marketplace.
-
Getting Started with the CData Python Connector for CouchDB
Learn to install and license the CData Python Connector
-
Automated Continuous MariaDB Replication to Oracle
Use CData Sync for automated, continuous, customizable MariaDB replication to Oracle.