CData Software - Knowledge Base
Recent Articles
-
Visualize Live Stripe Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Stripe into custom reports in Power BI.
-
Analyze Splunk Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Splunk and visualize Splunk in SAP Analytics Cloud.
-
DataBind Charts to Auth0 Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Auth0 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.
-
Build Visualizations of JobNimbus Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of JobNimbus in Birst.
-
Visualize EmailOctopus Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load EmailOctopus into TIBCO Spotfire.
-
Using the CData Software ODBC Driver for Humanity in PyCharm
Connect to Humanity as an ODBC data source in PyCharm using the CData Software ODBC Driver for Humanity.
-
Use the CData ODBC Driver for Placid in Microsoft Power Query
You can use the CData Placid ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Placid into Microsoft Power Query.
-
Publish Reports with MailerSend Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date MailerSend.
-
Create Dynamic OpenWeatherMap Grids Using the Infragistics XamDataGrid
Learn how you can connect OpenWeatherMap to Infragistics XamDataGrid to build dynamic grids.
-
Getting Started with the CData Connect AI Python SDK for Outreach.io
Install the CData Connect AI Python SDK to read and write live Outreach.io with standard DB-API 2.0 Python code.
-
Add Quaderno Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Quaderno with the Informatica Enterprise Data Catalog to classify and organize data.
-
Getting Started with the CData Connect AI Python SDK for SAP SuccessFactors LMS
Install the CData Connect AI Python SDK to read and write live SAP SuccessFactors LMS with standard DB-API 2.0 Python code.
-
View Reports on Real-Time ZohoSubscriptions Data in Power BI Report Server
Use the CData ODBC Driver for ZohoSubscriptions to visualize ZohoSubscriptions in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to Hive in SpagoBI
Create reports featuring live Apache Hive in SpagoBI Studio. Host Hive reports on SpagoBI Server.
-
Bidirectional Access to Tally Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Tally ERP in Filemaker Pro for Mac or Windows.
-
How to publish and share SAP Data dashboards with Tableau Server
The CData ODBC driver for SAP enables you integrate SAP ERP/NetWeaver into Tableau dashboards.
-
How to Build an ETL App for IBM Cloud Object Storage Data in Python with CData
Create ETL applications and real-time data pipelines for IBM Cloud Object Storage in Python with petl.
-
Connect to Live Snapchat Ads Data in MicroStrategy through CData Connect AI
Create a live connection to Snapchat Ads Data in CData Connect AI and connect to your Snapchat Ads from MicroStrategy.
-
Access Live SAP Hybris C4C Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SAP Hybris C4C from your Google Sheets.
-
Build MVC Applications with Connectivity to Google Ad Manager Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Google Ad Manager from an ASP.NET MVC application.
-
How to Query Live Jira Assets Data in Claude Desktop
Connect to and query live Jira Assets Data in Claude Desktop using CData MCP Server.
-
Query Google Spanner Data in DataGrip
Create a Data Source for Google Spanner in DataGrip and use SQL to query live Google Spanner.
-
Use the CData Software JDBC Driver for Elasticsearch in MicroStrategy Desktop
Connect to Elasticsearch in MicroStrategy Desktop using the CData Software JDBC Driver for Elasticsearch.
-
Automate Google Campaign Manager 360 Data Replication to Azure Synapse
Use CData Sync to customize and automate Google Campaign Manager 360 replication to Azure Synapse.
-
Connect Bannerbear to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Bannerbear with IBM WebSphere for seamless data integration and connectivity.
-
DataBind Act-On Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Act-On with the DevExpress Windows Forms and Web controls to provide Act-On to a chart.
-
Visualize Live Kintone Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Kintone using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrating OpenCode Terminal with SparkPost 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 Connect to Live Salesforce Pardot Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Salesforce Pardot for you.
-
Getting Started with the CData ADO.NET Provider for Clari
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Use the CData Software ODBC Driver for Zoho Inventory in MicroStrategy
Connect to Zoho Inventory in MicroStrategy Developer using the CData Software ODBC Driver for Zoho Inventory.
-
Build Visualizations of Chargebee Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Chargebee in Birst.
-
Visualize Acumatica Data in TIBCO Spotfire through ADO.NET
Integrate Acumatica ERP into dashboards in TIBCO Spotfire.
-
DataBind Controls to HCL Domino Data in C++Builder
DataBind to HCL Domino in C++Builder with standard components and controls.
-
Automated Codat Data Replication to Teradata
Use CData Sync to Customize and automate Codat replication to Teradata.
-
Publish Reports with ZohoExpense Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ZohoExpense.
-
Create Dynamic Apify Grids Using the Infragistics XamDataGrid
Learn how you can connect Apify to Infragistics XamDataGrid to build dynamic grids.
-
Visualize MailerLite Data in TIBCO Spotfire through ADO.NET
Integrate MailerLite into dashboards in TIBCO Spotfire.
-
How to Access Vercel Data Using Entity Framework
This article shows how to access Vercel using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Explore Geographical Relationships in Suadeo Data with Power Map
Create data visualizations with Suadeo in Power Map.
-
Connect to Perigon Data in JRuby
Create a simple JRuby app with access to live Perigon.
-
How to load ZeroBounce data into Elasticsearch via Logstash
Introducing a simple method to load ZeroBounce data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
DataBind Controls to Spotify Data in Delphi
DataBind to Spotify in Delphi with standard data access components and controls.
-
How to Design MongoDB Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to MongoDB from mobile and tablet Power Apps.
-
Access Live Procore Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Procore from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Prepare, Blend, and Analyze PagerDuty Data in Alteryx Designer (ODBC)
Build workflows to access live PagerDuty for self-service data analytics.
-
Feed BigCommerce Data into FineReport
How to set BigCommerce as a JDBC data source in FineReport.
-
Analyze Live ServiceNow Data in SAS Viya
Use CData Connect AI to connect to ServiceNow from SAS Viya and deploy self-service analytics using live ServiceNow.
-
Automated Continuous Phoenix Replication to MySQL
Use CData Sync for automated, continuous, customizable Phoenix replication to MySQL.
-
How to Easily Query Egnyte Data in OpenOffice Base
Connect to Egnyte data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
How to Work with Quaderno Data in ETL Validator JDBC
Connect to Quaderno from ETL Validator jobs using the CData Software JDBC Driver.
-
Enable the Trello JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Trello.
-
Query Invoiced Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Invoiced from Node.js.
-
Automated Continuous Ontraport Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Ontraport replication to Google BigQuery.
-
Connect to Real-Time Webex Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Webex in Power Apps.
-
Integrating Claude Code CLI with FTP 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.
-
Trigger Snapchat Ads IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Snapchat Ads with standard wizards in Logic Apps.
-
Connect to CampaignMonitor Data from a Connection Pool in JBoss
Integrate CampaignMonitor into Java servlets: Use the Management Console in JBoss to install the CampaignMonitor JDBC Driver.
-
Connect to Azure DevOps Data in Jaspersoft Studio
Execute SQL to remote Azure DevOps in Jaspersoft Studio.
-
Getting Started with the CData Python Connector for Redshift
Learn to install and license the CData Python Connector
-
DataBind Charts to Redis Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Redis 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.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Dynamics 365 Business Central within intelligent workflows.
-
Analyze AlloyDB Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Google AlloyDB in Microsoft R Open.
-
Integrate with Freshservice Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Freshservice to a JSON file on disk.
-
Build Data Flows from SAP Concur to SQL Server using SSIS
Easily back up SAP Concur to SQL Server using the SSIS components for SAP Concur.
-
Work with XML Data in FoxPro
Load XML Files into a FoxPro database. This article includes full code and a walk-through of the process.
-
Create Elorus Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Elorus data access from reports, embedded analytics, and more.
-
Connect to Azure DevOps Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Azure DevOps from Filemaker Pro on Mac.
-
Create Reports from Google Spanner Data in Looker Studio
Use CData Connect AI to gain access to live Google Spanner and create custom reports in Looker Studio.
-
How to create an RPA flow for Impala Data in UiPath Studio
Use the Impala ODBC Driver to create workflows that access real-time Apache Impala without any coding.
-
Build OData Visualizations in Tableau Cloud
Use CData Connect AI to connect to live OData and build visualizations in Tableau Cloud.
-
Use Dash to Build to Web Apps on Clockify Data
Create Python applications that use pandas and Dash to build Clockify-connected web apps.
-
How to Connect SAP Business One 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 SAP Business One data in real time using natural language.
-
Create Informatica Mappings From/To a JDBC Data Source for Optimizely
Create Optimizely data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Automated Continuous QuickBooks Time Replication to MongoDB
Use CData Sync for automated, continuous, customizable QuickBooks Time replication to MongoDB.
-
Connect to ZohoExpense Data in Ruby
Connect to ZohoExpense in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Migrating data from ScrapingBee to Google BigQuery using CData SSIS Components.
Easily push ScrapingBee to Google BigQuery using the CData SSIS Tasks for ScrapingBee and Google BigQuery.
-
ETL AlloyDB in Oracle Data Integrator
This article shows how to transfer Google AlloyDB into a data warehouse using Oracle Data Integrator.
-
Getting Started with the CData SSIS Components for PDFMonkey
Complete guide to installing, licensing, and connecting with the CData SSIS Components for PDFMonkey.
-
How to connect and process HubSpot from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live HubSpot.
-
Build Teamwork-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Teamwork and build web apps with connectivity to live Teamwork.
-
Build a PostgreSQL Interface for Google Ads Data using the CData JDBC Driver
Use the Remoting features of the Google Ads JDBC Driver to create a PostgreSQL entry-point for data access.
-
Model Slack Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Slack, enabling the direct import of real-time Slack.
-
Stream iContact Data into Apache Kafka Topics
Access and stream iContact in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Access Live SharePoint Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Microsoft SharePoint from your Google Sheets.
-
How to Connect to Live Zoho CRM Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Zoho CRM for you.
-
Integrate SAP Ariba Source Data in Pentaho Data Integration
Build ETL pipelines based on SAP Ariba Source in the Pentaho Data Integration tool.
-
How to use SQLAlchemy ORM to access ZarMoney Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of ZarMoney.
-
Integrate Zoho Books with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Zoho Books with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Zoho Books.
-
Analyze NetSuite Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of NetSuite CRM & ERP and visualize NetSuite CRM & ERP in SAP Analytics Cloud.
-
Analyze Live SAS Data Sets Data in SAS Viya
Use CData Connect AI to connect to SAS Data Sets from SAS Viya and deploy self-service analytics using live SAS Data Sets.
-
How to Build an ETL App for SAS Data Sets Data in Python with CData
Create ETL applications and real-time data pipelines for SAS Data Sets in Python with petl.
-
Create Cloudant Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Cloudant from PowerBI.com to create Power BI Dataflows with real-time data.
-
Automated Continuous Google Calendar Replication to MongoDB
Use CData Sync for automated, continuous, customizable Google Calendar replication to MongoDB.
-
Access CouchDB Data from MySQL in Amazon QuickSight
Connect to CouchDB and build visualizations of Apache CouchDB using a MySQL Connection in Amazon QuickSight.
-
ETL PostgreSQL in Oracle Data Integrator
This article shows how to transfer PostgreSQL into a data warehouse using Oracle Data Integrator.
-
Automated Continuous Stripe Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Stripe replication to PostgreSQL.
-
Connect to Redis Data from Crystal Reports
Use CData Connect AI to connect to and report on live Redis from Crystal Reports.
-
Object-Relational Mapping (ORM) with Jodoo 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 Jodoo into a Java-based ORM framework, Hibernate.
-
How to import Figshare Data into Apache Solr
Use the CData Software JDBC Driver for Figshare in Data Import Handler and create an automated import of Figshare to Apache Solr Enterprise Search platform.