CData Software - Knowledge Base
Recent Articles
-
Use Dash to Build Web Apps on SAP Concur Data via CData Connect AI
Build interactive Dash web apps on live SAP Concur using pandas and the CData Connect AI Python SDK.
-
Feed Aweber Data into FineReport
How to set Aweber as a JDBC data source in FineReport.
-
Integrate Live Teamgate Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Teamgate to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Stream Lakebase Data into Apache Kafka Topics
Access and stream Lakebase in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Create Tanda Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Tanda data access from reports, embedded analytics, and more.
-
Use JayDeBeApi to access Zoho Creator Data in Python
Use standard Python scripting and the development environment of your choice to access live Zoho Creator.
-
Access Live Xero Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Xero Accounting into the statistical analysis tools available in SAS JMP. This article shows how to use Xero Accounting in the Graph Builder and Query Builder.
-
Access Cohere 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 Cohere.
-
Integrate with live API Data in Jitterbit
Use CData Connect AI to connect to and integrate live API in Jitterbit.
-
Analyze Mailgun Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Mailgun from Power Pivot. You will use the Table Import Wizard to load Mailgun. You can visually build the import query or use any SQL supported by the driver.
-
Establish a Live Connection with YouTube Analytics Data using Tableau Bridge
The CData ODBC Driver for YouTube Analytics enables you to integrate live YouTube Analytics into Tableau Cloud dashboards using the Tableau Bridge.
-
Integrating Kiro CLI with Azure Data Catalog 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.
-
How to load Elorus data into Elasticsearch via Logstash
Introducing a simple method to load Elorus data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Use the CData ODBC Driver for Spotify from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Spotify to connect to Spotify from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Spotify in Excel.
-
Build Automated Cassandra-Connected Workflows in Zapier
Use CData Connect AI to connect to live Apache Cassandra and build automated workflows in Zapier.
-
Connect to FTP Data in RapidMiner
Integrate FTP Servers with standard components and data source configuration wizards in RapidMiner Studio.
-
Query Live FHIR Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live FHIR directly from the development environment.
-
Migrating data from SendGrid to Databricks using CData SSIS Components.
Easily push SendGrid to Databricks using the CData SSIS Tasks for SendGrid and Databricks.
-
Integrate Google Analytics Data into Power Automate Desktop using CData Connect
CData Connect for Google Analytics Data enables you to integrate Google Analytics into workflows built using Microsoft Power Automate Desktop.
-
Connect to Live Marketo Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Marketo in CData Connect AI and connect to your Marketo from PostgreSQL.
-
Build Data Flows from Teamgate to SQL Server using SSIS
Easily back up Teamgate to SQL Server using the SSIS components for Teamgate.
-
Connect to Zuora Data in Aqua Data Studio
Access Zuora from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to GraphQL Data in ACL Analytics
Connect to GraphQL via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to GraphQL.
-
Connect to Discord Data from PowerBuilder via JDBC
This article demonstrates how to access Discord from PowerBuilder using the Discord JDBC Driver.
-
How to connect to Presto Data from Spring Boot
Connect to Presto in a Spring Boot Application using the CData JDBC Driver for Presto
-
Integrate Neo4J Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Neo4J from Informatica Cloud.
-
Explore Geographical Relationships in Salesforce Marketing Data with Power Map
Create data visualizations with Salesforce Marketing Cloud in Power Map.
-
Connect to Dynamics 365 Data in Google Apps Script via Connect AI
Use CData Connect AI to access Microsoft Dynamics 365 in Google Apps Script.
-
Connect to CloudConvert Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Build a PostgreSQL Interface for HubDB Data using the CData JDBC Driver
Use the Remoting features of the HubDB JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous PostgreSQL Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable PostgreSQL replication to delimited files (CSV/TSV).
-
Moving Data from SAP HANA XS Advanced to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live SAP HANA XS Advanced data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Create SSAS Tabular Models from MailerLite Data
How to build a SQL Server Analysis Service Tabular Model from MailerLite using CData drivers.
-
How to connect PolyBase to Planio
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Planio.
-
Automated Continuous MessageBird Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable MessageBird replication to Apache Cassandra.
-
Connect to Authorize.Net Data in JRuby
Create a simple JRuby app with access to live Authorize.Net.
-
Prepare, Blend, and Analyze Trello Data in Alteryx Designer (ODBC)
Build workflows to access live Trello for self-service data analytics.
-
Connect to and Visualize Live ConstantContact Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live ConstantContact.
-
Create a Data Access Object for Redshift Data using JDBI
A brief overview of creating a SQL Object API for Amazon Redshift in JDBI.
-
Replicate Elasticsearch Data to Multiple Databases
Replicate Elasticsearch to disparate databases with a point-and-click configuration.
-
Automated Continuous Drip Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Drip replication to Google Cloud SQL.
-
Work with Printify Data in FoxPro
Load Printify into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to Salesforce Pardot from Asprova with CData Software ODBC Driver for Salesforce Pardot
This article shows how to connect faster to Salesforce Pardot data from Asprova.
-
ETL Oracle Eloqua in Oracle Data Integrator
This article shows how to transfer Oracle Eloqua into a data warehouse using Oracle Data Integrator.
-
How to Query ZohoMarketingHub Data in MySQL Workbench
Execute MySQL queries against live ZohoMarketingHub from MySQL Workbench.
-
Connect Shortcut to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Shortcut with IBM WebSphere for seamless data integration and connectivity.
-
Access Live Attio Data in AWS Lambda
Connect to live Attio in AWS Lambda using the CData JDBC Driver.
-
Integrate Postmark Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Postmark from Informatica Cloud.
-
Build AI Agents with Zoho Books 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 Zoho Books through CData Connect AI.
-
Create Dynamic SAP Concur Grids Using the Infragistics XamDataGrid
Learn how you can connect SAP Concur to Infragistics XamDataGrid to build dynamic grids.
-
Build Semantic Layer Views for Zoho Inventory Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Zoho Inventory.
-
How to Connect the Power BI Service to Recurly: Complete Guide
Connect to the CData Software Power BI Connector for Recurly from PowerBI.com to provide real-time Recurly across the organization.
-
How to integrate Yelp with Apache Airflow
Access and process Yelp in Apache Airflow using the CData JDBC Driver.
-
Build Splunk-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Splunk to explore live Splunk Data in Cursor to assist with building Splunk-powered applications.
-
Use JayDeBeApi to access eBay Analytics Data in Python
Use standard Python scripting and the development environment of your choice to access live eBay Analytics.
-
Access Live Flowlu Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Flowlu in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to import Marketo Data into Apache Solr
Use the CData Software JDBC Driver for Marketo in Data Import Handler and create an automated import of Marketo to Apache Solr Enterprise Search platform.
-
Use the CData ODBC Driver for Azure DevOps from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Azure DevOps to connect to Azure DevOps from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Azure DevOps in Excel.
-
How to Seamlessly Import Marketo Data into IBM SPSS Modeler
Integrate Marketo data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Getting Started with the CData ODBC Driver for Coinbase
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Coinbase.
-
Visualize Live ElevenLabs Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live ElevenLabs.
-
Getting Started with the CData ADO.NET Provider for SAP Fieldglass
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for SAP Fieldglass.
-
Operational Reporting on JobNimbus Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote JobNimbus.
-
Connect to Cvent Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Integrating OpenCode Terminal with CircleCI 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 an SAP BusinessObjects Universe on the CData ODBC Driver for Tavily
Provide connectivity to Tavily through an SAP BusinessObjects universe.
-
Automate OneNote Data Replication to Azure Synapse
Use CData Sync to customize and automate Microsoft OneNote replication to Azure Synapse.
-
Visualize Clari Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Clari.
-
Use the CData Software ODBC Driver for DB2 in MicroStrategy Desktop
Connect to IBM DB2 in MicroStrategy Desktop using the CData Software ODBC Driver for DB2.
-
Use the CData Software ODBC Driver for ZarMoney in MicroStrategy Desktop
Connect to ZarMoney in MicroStrategy Desktop using the CData Software ODBC Driver for ZarMoney.
-
Validate Miro Data with QuerySurge
Access and validate Miro in QuerySurge using the CData JDBC Driver.
-
Use the CData Software JDBC Driver for Snowflake in MicroStrategy Web
Connect to Snowflake in MicroStrategy Web using the CData Software JDBC Driver for Snowflake.
-
Build Semantic Layer Views for Google Spanner Data in APOS Live Data Gateway
Use the CData Connector for Google Spanner in APOS Live Data Gateway to build Semantic Layer Views for Google Spanner.
-
Use the CData API Server to Access Act-On Data in Microsoft PowerPivot
Use the CData API Server to connect to live Act-On in the Power Pivot business intelligence tool.
-
Build a Simple VCL Application for Todoist Data
How to build a simple VCL Application to view Todoist in RAD Studio using the CData ODBC Driver for Todoist.
-
Provide OData Services of Box Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Box by developing a WCF Service Application.
-
Connect to ZohoMarketingHub Data as an External Source in Dremio
Use the CData JDBC Driver to connect to ZohoMarketingHub as an External Source in Dremio.
-
Write a Simple Go Application to work with Google Ads Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Google Ads.
-
Enable the Salesforce Pardot JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Salesforce Pardot.
-
Create SSAS Tabular Models from Amazon S3 Data
How to build a SQL Server Analysis Service Tabular Model from Amazon S3 using CData drivers.
-
Feed PabblySubscriptions Data into FineReport
How to set PabblySubscriptions as a JDBC data source in FineReport.
-
Add Vercel Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Vercel with the Informatica Enterprise Data Catalog to classify and organize data.
-
Access Live Gmail Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Gmail through MCP integration.
-
Build a Singer.io Tap for ChargeOver With the CData Python Connector
Learn how to easily build a Singer.io Tap for live ChargeOver data using
-
DataBind Adobe Target Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Adobe Target with the DevExpress Windows Forms and Web controls to provide Adobe Target to a chart.
-
Integrate with Helpscout Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Helpscout to a JSON file on disk.
-
Create Power BI Reports on Real-Time PDFMonkey Data
Use the CData ODBC Driver for PDFMonkey to visualize PDFMonkey in Power BI Desktop.
-
Integrating Gumloop with Microsoft Teams Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Microsoft Teams within automated workflows.
-
Automated Continuous SAP Ariba Procurement Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable SAP Ariba Procurement replication to Azure SQL Database.
-
Integrate Cursor with Live SurveyMonkey Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live SurveyMonkey from within the editor.
-
DataBind Charts to Monday.com Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Monday.com 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.
-
LINQ to Tanda 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 Tanda Data Provider.
-
Import Real-Time Gorgias Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Gorgias in ColdFusion.
-
Build Amazon Athena-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Amazon Athena to explore live Amazon Athena Data in GitHub Copilot to assist with building Amazon Athena-powered applications.
-
Connect to Salesforce Data 360 Data in JRuby
Create a simple JRuby app with access to live Salesforce Data 360.
-
Connect to Auth0 Data in JRuby
Create a simple JRuby app with access to live Auth0.
-
Enable the ZendeskSell JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with ZendeskSell.
-
Automated Continuous Microsoft Dataverse Replication to MySQL
Use CData Sync for automated, continuous, customizable Microsoft Dataverse replication to MySQL.
-
Integrate CircleCI Data in Pentaho Data Integration
Build ETL pipelines based on CircleCI in the Pentaho Data Integration tool.
-
Connect and Visualize Live GitLab Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live GitLab into the Databricks platform and create visualization dashboards with real-time GitLab.