CData Software - Knowledge Base
Recent Articles
-
Connecting Agentforce with Amazon DynamoDB 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 Amazon DynamoDB for you.
-
Connect to Sugar CRM Data in Google Apps Script via Connect AI
Use CData Connect AI to access Sugar CRM in Google Apps Script.
-
Use the CData Software ODBC Driver for Greenplum in MicroStrategy Desktop
Connect to Pivotal GreenPlum in MicroStrategy Desktop using the CData Software ODBC Driver for Greenplum.
-
Import Real-Time Workday Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Workday in ColdFusion.
-
Connect to SAP HANA from Asprova with CData Software ODBC Driver for SAP HANA
This article shows how to connect faster to SAP HANA data from Asprova.
-
Connect to Aha! Data in Ruby
Connect to Aha! in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to work with Templated Data in Apache Spark using SQL
Access and process Templated Data in Apache Spark using the CData Software JDBC Driver.
-
Analyze Discord Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Discord from Power Pivot. You will use the Table Import Wizard to load Discord. You can visually build the import query or use any SQL supported by the driver.
-
Automated Continuous FHIR Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable FHIR replication to Apache Kafka.
-
Query SAP Fieldglass Data in DataGrip
Create a Data Source for SAP Fieldglass in DataGrip and use SQL to query live SAP Fieldglass.
-
Access Teamgate Data from MySQL in Amazon QuickSight
Connect to Teamgate and build visualizations of Teamgate using a MySQL Connection in Amazon QuickSight.
-
Working with WordPress Data in LINQPad
Execute LINQ queries to WordPress in LINQPad.
-
Automated Continuous Google Campaign Manager 360 Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Google Campaign Manager 360 replication to Google BigQuery.
-
Connect to and Query Airtable Data in QlikView over ODBC
Create data visualizations with Airtable in QlikView.
-
Configure the CData JDBC Driver for Impala in a Connection Pool in Tomcat
Connect to Apache Impala from a connection pool in Tomcat.
-
Connect to Quaderno Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Quaderno and the SQL Gateway to access Quaderno from Google Apps Script.
-
Excel Spreadsheet Automation on EnterpriseDB Data with the QUERY Formula
Pull data from EnterpriseDB, automate spreadsheets, and more with the QUERY formula.
-
Create Apps from Pipedrive Data in Qlik Sense Cloud
Use CData Connect AI to connect to Pipedrive Data and build apps from live Pipedrive in Qlik Sense Cloud.
-
Access Live Microsoft Teams Data in TIBCO Data Virtualization
Use the Microsoft Teams Tibco DV Adapter to create a Microsoft Teams data source in TIBCO Data Virtualization Studio and gain access to live Microsoft Teams from your TDV Server.
-
Use the CData Software JDBC Driver for Dynamics CRM in MicroStrategy Desktop
Connect to Microsoft Dynamics CRM in MicroStrategy Desktop using the CData Software JDBC Driver for Dynamics CRM.
-
Integrate with Figshare Data in JReport Designer
Create charts and reports based on Figshare in JReport Designer.
-
Moving Data from Avaza to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Avaza data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Seamlessly Bring PostgreSQL Data into Retool Using CData Connect AI
Integrate PostgreSQL data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
How to connect Amazon QuickSight to Procore Data
Create a connection to Procore in CData Connect AI and insert Procore into Amazon QuickSight SPICE to build interactive dashboards.
-
Getting Started with the CData Connect AI Python SDK for Adobe Analytics
Install the CData Connect AI Python SDK to read and write live Adobe Analytics with standard DB-API 2.0 Python code.
-
Create a Data Access Object for CampaignMonitor Data using JDBI
A brief overview of creating a SQL Object API for CampaignMonitor in JDBI.
-
Bidirectional Access to Chargebee Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Chargebee in Filemaker Pro for Mac or Windows.
-
DataBind MailerSend Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide MailerSend to a chart.
-
Migrating data from JSON to Databricks using CData SSIS Components.
Easily push JSON to Databricks using the CData SSIS Tasks for JSON and Databricks.
-
How to Visualize MailerLite Data in Python with pandas
Use pandas and other modules to analyze and visualize live MailerLite in Python.
-
Connect Moosend Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Moosend using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Migrating data from SparkPost to Google BigQuery using CData SSIS Components.
Easily push SparkPost to Google BigQuery using the CData SSIS Tasks for SparkPost and Google BigQuery.
-
How to Connect the Power BI Service to Webex: Complete Guide
Connect to the CData Software Power BI Connector for Webex from PowerBI.com to provide real-time Webex across the organization.
-
Feed Google Search Results into FineReport
How to set Google Search as a JDBC data source in FineReport.
-
Building Dynamic Web Pages with MailChimp Data Using AngularJS
Create single-page applications with live connectivity to MailChimp using the CData API Server.
-
Automated Continuous Mode Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Mode replication to Apache Kafka.
-
Write a Simple Go Application to work with CouchDB Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Apache CouchDB.
-
Connect to BambooHR Data from AWS Glue
Use CData Connect AI to gain access to live BambooHR from your AWS Glue jobs.
-
Integrating OpenCode Terminal with Neo4J 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 work with ChargeOver Data in Apache Spark using SQL
Access and process ChargeOver Data in Apache Spark using the CData Software JDBC Driver.
-
Create Azure Table-Connected Business Apps in AppSheet
Connect to Azure Table Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Azure Table Storage.
-
Consume Wave Financial OData Feeds in PowerBuilder
This article demonstrates how to consume Wave Financial as OData feeds from PowerBuilder using the API Server.
-
Visualize Live Google Tasks Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Google Tasks.
-
Stream Google Drive Data into Apache Kafka Topics
Access and stream Google Drive in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Build Automated Workflows with Live Microsoft Planner Data in Workato
Use CData Connect AI to connect to live Microsoft Planner and build automated workflows in Workato.
-
Connect to Float Data in RapidMiner
Integrate Float with standard components and data source configuration wizards in RapidMiner Studio.
-
How to Work with Pingdom Data in ETL Validator JDBC
Connect to Pingdom from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Presto 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 Presto.
-
Automated Continuous Sugar CRM Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Sugar CRM replication to OneLake in Microsoft Fabric.
-
Integrating LlamaIndex with Databricks Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Databricks in real time.
-
Automated Continuous Hive Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Hive replication to IBM DB2.
-
Integrate Live Bullhorn CRM Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Operational Reporting on Google Calendar Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Google Calendar.
-
How to Access CircleCI Data Using Entity Framework
This article shows how to access CircleCI using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Visualize Live AlloyDB Data in the Power BI Service
Use CData Connect AI to connect to live Google AlloyDB and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build MVC Applications with Connectivity to Hugging Face Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Hugging Face from an ASP.NET MVC application.
-
Build SuiteCRM-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for SuiteCRM to explore live SuiteCRM Data in GitHub Copilot to assist with building SuiteCRM-powered applications.
-
Excel Spreadsheet Automation on Jodoo Data with the QUERY Formula
Pull data from Jodoo, automate spreadsheets, and more with the QUERY formula.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for IBM Cloud Object Storage
Provide connectivity to IBM Cloud Object Storage through an SAP BusinessObjects universe.
-
Visualize Live PDFMonkey Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live PDFMonkey using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Stream XML Data into Apache Kafka Topics
Access and stream XML Files in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Natively Connect to Power BI XMLA Data in PHP
The CData ODBC driver for Power BI XMLA enables you to create PHP applications with connectivity to Power BI XMLA. Leverage the native support for ODBC in PHP.
-
Getting Started with the CData Python Connector for Aweber
Learn to install and license the CData Python Connector
-
DataBind Charts to Clockify Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Clockify 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.
-
Integrating Kiro CLI with Chargebee 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 Zoho CRM Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Zoho CRM and visualize Zoho CRM in SAP Analytics Cloud.
-
Create Apps from DB2 Data in Qlik Sense Cloud
Use CData Connect AI to connect to DB2 Data and build apps from live IBM DB2 in Qlik Sense Cloud.
-
Build Semantic Layer Views for Microsoft Teams Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Microsoft Teams.
-
Build Automated Workflows with Live Oracle Eloqua Data in Workato
Use CData Connect AI to connect to live Oracle Eloqua and build automated workflows in Workato.
-
Connect to Real-Time Office 365 Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Office 365 and Dataflow to import and use Microsoft Office 365 in Power Apps.
-
Create Azure Table-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Azure Table Data from OutSystems and build custom enterprise apps using live Azure Table Storage.
-
How to import Webflow Data into Apache Solr
Use the CData Software JDBC Driver for Webflow in Data Import Handler and create an automated import of Webflow to Apache Solr Enterprise Search platform.
-
Connect to Real-Time QuickBooks Online Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for QuickBooks Online and Dataflow to import and use QuickBooks Online in Power Apps.
-
Build Data Flows from Oracle to SQL Server using SSIS
Easily back up Oracle Database to SQL Server using the SSIS components for Oracle.
-
Create Oracle Service Cloud-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Oracle Service Cloud Data from Klipfolio and build custom visualizations using live Oracle Service Cloud.
-
Rapidly Develop Grafana-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 Grafana.
-
Connect to SAP Fieldglass Data from a Connection Pool in JBoss
Integrate SAP Fieldglass into Java servlets: Use the Management Console in JBoss to install the SAP Fieldglass JDBC Driver.
-
Build Apps with Live Azure Synapse in Adalo using CData Connect AI
Use CData Connect AI to integrate live Azure Synapse into the Adalo platform and build custom mobile and web applications with real-time Azure Synapse.
-
Prepare, Blend, and Analyze Asana Data in Alteryx Designer (Connect AI)
Build workflows to access live Asana for self-service data analytics.
-
Automated Continuous Zoho CRM Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Zoho CRM replication to AlloyDB.
-
Build a Singer.io Tap for SFTP With the CData Python Connector
Learn how to easily build a Singer.io Tap for live SFTP data using
-
How to Visualize Hubstaff Data in Python with pandas
Use pandas and other modules to analyze and visualize live Hubstaff in Python.
-
Create Informatica Mappings From/To a JDBC Data Source for Greenplum
Create Greenplum data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Access Live Webflow Data in Coginiti Pro
Connect to and query live Webflow from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Access SAP Business Warehouse Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SAP Business Warehouse from your Oracle system.
-
Automated Continuous Azure Data Catalog Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Azure Data Catalog replication to delimited files (CSV/TSV).
-
Create Dashboards and Visualize Live Slack Data in Geckoboard
Use CData Connect AI to connect to live Slack and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Automated Continuous Clari Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Clari replication to Amazon Redshift.
-
Create Gmail Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Gmail from PowerBI.com to create Power BI Dataflows with real-time data.
-
Use Biml to Build SSIS Tasks to Replicate Zendesk Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Zendesk to SQL Server.
-
Replicate eBay Analytics Data to Multiple Databases
Replicate eBay Analytics to disparate databases with a point-and-click configuration.
-
Automated Aha! Data Replication to Teradata
Use CData Sync to Customize and automate Aha! replication to Teradata.
-
Automated Continuous Ontraport Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Ontraport replication to Google Cloud SQL.
-
Create Dynamic Kafka Grids Using the Infragistics XamDataGrid
Learn how you can connect Kafka to Infragistics XamDataGrid to build dynamic grids.
-
Query Twitter Ads Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Twitter Ads and perform CRUD operations on Twitter Ads from Node.js.
-
Integrate Cursor with Live Oracle Financials Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Oracle Financials Cloud from within the editor.
-
LINQ to Gmail 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 Gmail Data Provider.
-
Connect to Hive Data in JRuby
Create a simple JRuby app with access to live Apache Hive.
-
Import Real-Time Jira Assets Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Jira Assets in ColdFusion.
-
Automated Continuous Billsby Replication to MySQL
Use CData Sync for automated, continuous, customizable Billsby replication to MySQL.