CData Software - Knowledge Base
Recent Articles
-
Provide OData Services of Google Tasks Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Google Tasks by developing a WCF Service Application.
-
Getting Started with the CData Tableau Connector for Amazon Athena
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Amazon Athena.
-
Consume Cvent OData Feeds in PowerBuilder
This article demonstrates how to consume Cvent as OData feeds from PowerBuilder using the API Server.
-
Create SSAS Tabular Models from SharePoint Data
How to build a SQL Server Analysis Service Tabular Model from Microsoft SharePoint using CData drivers.
-
Integrating Codex CLI with Microsoft Ads 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.
-
Connect to HubDB Data in DBeaver
Use the CData ODBC Driver to connect to HubDB in DBeaver.
-
Connect to Aha! Data from PowerBuilder via ADO.NET
This article demonstrates how to access Aha! from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Manage Billsby Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Billsby.
-
How to Import Data from Amazon Athena into Google Sheets
Import Amazon Athena into a Google spreadsheet that is automatically refreshed.
-
Build MVC Applications with Connectivity to Google Translate Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Google Translate from an ASP.NET MVC application.
-
Stream Asana Data into Apache Kafka Topics
Access and stream Asana in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Visualize Spark Data in TIBCO Spotfire through ADO.NET
Integrate Apache Spark SQL into dashboards in TIBCO Spotfire.
-
Automated Continuous SurveyMonkey Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable SurveyMonkey replication to Apache Cassandra.
-
Load ZarMoney Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load ZarMoney to a database.
-
Work with Klipfolio Data in FoxPro
Load Klipfolio into a FoxPro database. This article includes full code and a walk-through of the process.
-
Create a Data Access Object for Vercel Data using JDBI
A brief overview of creating a SQL Object API for Vercel in JDBI.
-
Build Workday-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Workday and build Workday-connected web apps with Axios.
-
Integrate Campaigner Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Campaigner from Informatica Cloud.
-
Connect to Adobe Commerce Data from AWS Glue
Use CData Connect AI to gain access to live Adobe Commerce from your AWS Glue jobs.
-
Create Dashboards and Visualize Live Power BI XMLA Data in Geckoboard
Use CData Connect AI to connect to live Power BI XMLA and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Integrating Codex CLI with Short.io 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.
-
Connecting Pipedream with SQL Analysis Services Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on SQL Analysis Services data in real time.
-
Analyze MailChimp Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for MailChimp from Power Pivot. You will use the Table Import Wizard to load MailChimp. You can visually build the import query or use any SQL supported by the driver.
-
Bridge Chargebee Connectivity with Apache NiFi
Access and process Chargebee in Apache NiFi using the CData JDBC Driver.
-
Analyze Freshdesk Data in Looker
Use CData Connect AI to connect to Freshdesk Data from Looker and build custom apps using live Freshdesk.
-
Create Data Visualizations in Cognos BI with Microsoft Entra ID Data
Access Microsoft Entra ID as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Replicate Perplexity Data to Multiple Databases via the CData Sync CLI
Replicate Perplexity to disparate databases with a single configuration.
-
Connect to Cosmos DB Data in NetBeans
Connect to Azure Cosmos DB in NetBeans with the data source configuration wizard.
-
Getting Started with the CData Python Connector for Optimizely
Learn to install and license the CData Python Connector
-
Build Google Contacts-Connected Apps in Choreo
Use CData Connect AI to connect to Google Contacts Data from Choreo and build custom apps using live Google Contacts.
-
Use Dash to Build to Web Apps on MarkLogic Data
Create Python applications that use pandas and Dash to build MarkLogic-connected web apps.
-
Create Certinia Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Certinia from PowerBI.com to create Power BI Dataflows with real-time data.
-
Create Zendesk-Connected Dashboards in Grafana
Connect to Zendesk Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Zendesk.
-
How to Connect to Live SAP Netweaver Gateway 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 Netweaver Gateway for you.
-
Use the CData Software JDBC Driver for eBay in MicroStrategy Desktop
Connect to eBay in MicroStrategy Desktop using the CData Software JDBC Driver for eBay.
-
Access Pinterest Data from MySQL in PHP
Connect to Pinterest through the standard MySQL libraries in PHP.
-
How to Connect Microsoft Ads 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 Microsoft Ads data in real time using natural language.
-
How to Connect to Live Cosmos DB Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Azure Cosmos DB for you.
-
Use Claude to Talk to Your HBase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Apache HBase for you.
-
Create Dynamic Aha! Grids Using the Infragistics XamDataGrid
Learn how you can connect Aha! to Infragistics XamDataGrid to build dynamic grids.
-
Replicate Freshteam Data in Heroku for Use in Salesforce Connect
Replicate Freshteam to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Use JayDeBeApi to access CloudConvert Data in Python
Use standard Python scripting and the development environment of your choice to access live CloudConvert.
-
Integrating Antigravity CLI with GetResponse via CData CLI
Connect GetResponse to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Build Pipedrive-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Pipedrive to explore live Pipedrive Data in GitHub Copilot to assist with building Pipedrive-powered applications.
-
Load SuiteCRM Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load SuiteCRM to a database.
-
How to connect to SpaceX Data from IntelliJ
Integrate connectivity to SpaceX with wizards in IntelliJ.
-
How to connect to SAP Netweaver Gateway Data with Squirrel SQL client
Connect to SAP Netweaver Gateway and execute queries in the Squirrel SQL Client.
-
Automated Continuous Mouseflow Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Mouseflow replication to OneLake in Microsoft Fabric.
-
Integrating Paylocity Data in Talend Cloud Data Management Platform
Connect Paylocity Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Paylocity.
-
Connecting GenSpark with YouTube Analytics Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to YouTube Analytics without any replication or custom integration required.
-
Build Agents in Relevance AI with Access to Live Monday.com Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Monday.com within intelligent agent workflows.
-
Use Agno to Talk to Your Hive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Apache Hive for you.
-
Access Live Typeform Data in AWS Lambda
Connect to live Typeform in AWS Lambda using the CData JDBC Driver.
-
Query Everhour Data as a MySQL Database in Node.js
Execute MySQL queries against Everhour from Node.js.
-
Import and Visualize Jumpseller Data in Power View
Create data visualizations based on Jumpseller in Excel.
-
How to Connect DBeaver to Amazon Athena via a JDBC Driver
Manage Amazon Athena with visual tools in DBeaver like the query browser.
-
Create Snowflake Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Snowflake from PowerBI.com to create Power BI Dataflows with real-time data.
-
Use Agno to Talk to Your API Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your API for you.
-
Use ChatGPT to Talk to Your Microsoft Teams Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Microsoft Teams for you.
-
How to Create Power BI Visual Reports with Real-Time ZohoInvoice Data
Use CData Power BI Connectors to visualize ZohoInvoice in Power BI.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Apache Impala within intelligent workflows.
-
Build Apps with Live NetSuite Data Using the Low-Code Development Platform of Mendix
Connect NetSuite CRM & ERP with Mendix to build apps using the CData JDBC Driver for NetSuite.
-
Automated Continuous Accelo Replication to SingleStore
Use CData Sync for automated, continuous, customizable Accelo replication to SingleStore.
-
Connect to WordPress Data from a Connection Pool in Jetty
The WordPress JDBC Driver supports connection pooling: This article shows how to connect faster to WordPress from Web apps in Jetty.
-
Integrate LinkedIn with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate LinkedIn with External Services.
-
Connect to Bitbucket Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Bitbucket and the Script function in FileMaker Pro to connect to Bitbucket and work with Bitbucket in your FileMaker application.
-
Build Visualizations of Spotify Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Spotify in Birst.
-
How to Connect to Calendly Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Calendly. Leverage the pyodbc module for ODBC in Python.
-
Automated Continuous SAP HANA XS Advanced Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable SAP HANA XS Advanced replication to Amazon Redshift.
-
View Reports on Real-Time Reply.io Data in Power BI Report Server
Use the CData ODBC Driver for Reply.io to visualize Reply.io in Power BI Desktop and then publish them to Power BI Report Server.
-
Visualize Live Google Ads Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Google Ads.
-
Access Live HubSpot Data in Coginiti Pro
Connect to and query live HubSpot from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to Greenplum Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Greenplum Data and connect to Pivotal GreenPlum in Akorbi Digital RunMyProcess.
-
Connect to PabblySubscriptions Data from a Connection Pool in Jetty
The PabblySubscriptions JDBC Driver supports connection pooling: This article shows how to connect faster to PabblySubscriptions from Web apps in Jetty.
-
Analyze Live Hive Data in SAS Viya
Use CData Connect AI to connect to Apache Hive from SAS Viya and deploy self-service analytics using live Apache Hive.
-
Integrate Live Twilio Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Twilio to Blue Prism using the CData ODBC Driver for Twilio to create automated workflows for repetitive business tasks.
-
Connect to Oracle Service Cloud in SpagoBI
Create reports featuring live Oracle Service Cloud in SpagoBI Studio. Host Oracle Service Cloud reports on SpagoBI Server.
-
Build Semantic Layer Views for Vercel Data in APOS Live Data Gateway
Use the CData Connector for Vercel in APOS Live Data Gateway to build Semantic Layer Views for Vercel.
-
Create Reports from Spark Data in Looker Studio
Use CData Connect AI to gain access to live Apache Spark SQL and create custom reports in Looker Studio.
-
LINQ to PabblySubscriptions 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 PabblySubscriptions Data Provider.
-
Publish AfterShip-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live AfterShip.
-
Kintone Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Kintone facts in real time.
-
Use Agno to Talk to Your Sybase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Sybase for you.
-
Automated Continuous Campaigner Replication to MongoDB
Use CData Sync for automated, continuous, customizable Campaigner replication to MongoDB.
-
How to Connect to Live HBase 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 Apache HBase for you.
-
Connect to Real-Time OnePageCrm Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use OnePageCrm in Power Apps.
-
Use Azure AI Foundry to Talk to Your FHIR Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your FHIR for you.
-
How to Visualize Azure DevOps 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 Azure DevOps in Python.
-
LINQ to MariaDB 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 MariaDB Data Provider.
-
Build an OLAP Cube in SSAS from CampaignMonitor Data
Establish a connection to CampaignMonitor data from SQL Server Analysis Services, and use the CampaignMonitor Data Provider to build OLAP cubes for use in analytics and reporting.
-
Integrate Theia IDE with Live GitHub Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Automated Continuous Elorus Replication to MongoDB
Use CData Sync for automated, continuous, customizable Elorus replication to MongoDB.
-
Configure the CData JDBC Driver for SAP Concur in a Connection Pool in Tomcat
Connect to SAP Concur from a connection pool in Tomcat.
-
Automated Continuous AgileCRM Replication to SQL Server
Use CData Sync for automated, continuous, customizable AgileCRM replication to SQL Server.
-
Connect to Box Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Box as an External Source in Dremio.
-
Connect to HubSpot Data in JRuby
Create a simple JRuby app with access to live HubSpot.
-
How to Work with QuickBooks Time Data in AWS Glue Jobs Using JDBC
Connect to QuickBooks Time from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Write a Simple Go Application to work with IBM Informix Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to IBM Informix.
-
Access Live Salesforce Data 360 Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Salesforce Data 360 in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrate Sage Cloud Accounting with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Sage Cloud Accounting with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Sage Business Cloud Accounting.