CData Software - Knowledge Base
Recent Articles
-
Consume Mocean OData Feeds in PowerBuilder
This article demonstrates how to consume Mocean as OData feeds from PowerBuilder using the API Server.
-
Create Power BI Reports on Real-Time Productboard Data
Use the CData ODBC Driver for Productboard to visualize Productboard in Power BI Desktop.
-
Consume AfterShip OData Feeds in PowerBuilder
This article demonstrates how to consume AfterShip as OData feeds from PowerBuilder using the API Server.
-
How to import Google Directory Data into Apache Solr
Use the CData Software JDBC Driver for Google Directory in Data Import Handler and create an automated import of Google Directory to Apache Solr Enterprise Search platform.
-
DataBind Charts to TaxJar Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to TaxJar 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 Data Flows from Authorize.Net to SQL Server using SSIS
Easily back up Authorize.Net to SQL Server using the SSIS components for Authorize.Net.
-
Configure the CData JDBC Driver for XML in a Connection Pool in Tomcat
Connect to XML Files from a connection pool in Tomcat.
-
Build Hugging Face-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData API Driver for MCP Server to explore live Hugging Face Data in GitHub Copilot to assist with building Hugging Face-powered applications.
-
Connect to JobNimbus Data from PowerBuilder via ADO.NET
This article demonstrates how to access JobNimbus from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
How to connect to MYOB AccountRight Data with Squirrel SQL client
Connect to MYOB AccountRight and execute queries in the Squirrel SQL Client.
-
Automated Continuous Amazon DynamoDB Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Amazon DynamoDB replication to AlloyDB.
-
Analyze Figshare Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Figshare and visualize live Figshare in Infragistics Reveal.
-
Integrate Parallel Data in Pentaho Data Integration
Build ETL pipelines based on Parallel in the Pentaho Data Integration tool.
-
Integrating Kiro CLI with TaxJar 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 Access FreshBooks Data Using Entity Framework
This article shows how to access FreshBooks using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to connect PolyBase to HelloSign
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live HelloSign.
-
How to Work with Azure Data Catalog Data in AWS Glue Jobs Using JDBC
Connect to Azure Data Catalog from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to Connect to Live OneNote Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Microsoft OneNote through natural language.
-
How to Build an ETL App for LinkedIn Ads Data in Python with CData
Create ETL applications and real-time data pipelines for LinkedIn Ads in Python with petl.
-
Enable the Klaviyo JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Klaviyo.
-
Use Microsoft Copilot Studio to talk to your BambooHR Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your BambooHR for you.
-
Create a Data Access Object for Sybase Data using JDBI
A brief overview of creating a SQL Object API for Sybase in JDBI.
-
Connect to Excel Online Data in RapidMiner
Integrate Microsoft Excel Online with standard components and data source configuration wizards in RapidMiner Studio.
-
Manage FreeAgent Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for FreeAgent.
-
Automate NetSuite SuiteAnalytics Data Replication to Azure Data Lake
Use CData Sync to customize and automate NetSuite SuiteAnalytics replication to Azure Data Lake.
-
Prepare, Blend, and Analyze Adobe Commerce Data in Alteryx Designer (Connect AI)
Build workflows to access live Adobe Commerce for self-service data analytics.
-
Design BIRT Reports on Paddle Data
Provide current Paddle to your embedded analytics.
-
How to publish and share Supabase Data dashboards with Tableau Server
The CData ODBC driver for Supabase enables you integrate Supabase into Tableau dashboards.
-
Connect to Close Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Close and the SQL Gateway to access Close from Google Apps Script.
-
How to Connect to Placid Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Placid. Leverage the pyodbc module for ODBC in Python.
-
Establish a Live Connection with Freshdesk Data using Tableau Bridge
The CData ODBC Driver for Freshdesk enables you to integrate live Freshdesk into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to Hubstaff Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Hubstaff as an External Source in Dremio.
-
Use Azure AI Foundry to Talk to Your eBay 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 eBay for you.
-
Access Coinbase Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Coinbase from HeidiSQL.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Zoho Inventory actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Automated Continuous Teamwork Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Teamwork replication to PostgreSQL.
-
Viewing Onfleet Data in RAD Studio Data Explorer
How to view Onfleet in RAD Studio Data Explorer using the CData ODBC Driver for Onfleet.
-
Build Data Flows from Spark to SQL Server using SSIS
Easily back up Apache Spark SQL to SQL Server using the SSIS components for Spark.
-
How to Seamlessly Import Dynamics 365 Business Central Data into IBM SPSS Modeler
Integrate Dynamics 365 Business Central data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to OpenWeatherMap Data as an External Source in Dremio
Use the CData JDBC Driver to connect to OpenWeatherMap as an External Source in Dremio.
-
How to connect to Google Ads Data in DBVisualizer
Integrate Google Ads with visual data analysis tools and data connection wizards in DBVisualizer
-
Automated Continuous Adobe Analytics Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Adobe Analytics replication to Azure SQL Database.
-
Access Live Xero Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Xero Accounting through MCP integration.
-
LINQ to GraphQL 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 GraphQL Data Provider.
-
Integrating Antigravity CLI with GitHub via CData CLI
Connect GitHub to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Explore Geographical Relationships in Beeminder Data with Power Map
Create data visualizations with Beeminder in Power Map.
-
Bridge SingleStore Connectivity with Apache NiFi
Access and process SingleStore in Apache NiFi using the CData JDBC Driver.
-
Getting Started with the CData Tableau Connector for Slack
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Slack.
-
How to Access HCL Domino Data Using Entity Framework
This article shows how to access HCL Domino using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to Connect DBeaver to LaunchDarkly via a JDBC Driver
Manage LaunchDarkly with visual tools in DBeaver like the query browser.
-
Visualize HCL Domino 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 HCL Domino into TIBCO Spotfire.
-
Automated Continuous Microsoft Exchange Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Microsoft Exchange replication to AlloyDB.
-
Connect to SAP BusinessObjects BI Data from Crystal Reports
Use CData Connect AI to connect to and report on live SAP BusinessObjects BI from Crystal Reports.
-
Consume HBase OData Feeds in SAP Lumira
Use the API Server to create data visualizations on HBase feeds that reflect any changes in SAP Lumira.
-
Integrate with live Office 365 Data in Jitterbit
Use CData Connect AI to connect to and integrate live Microsoft Office 365 in Jitterbit.
-
Import and Visualize Phoenix Data in Power View
Create data visualizations based on Apache Phoenix in Excel.
-
Access Sendwithus Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Sendwithus from your Oracle system.
-
Query Grafana Data as a MySQL Database in Node.js
Execute MySQL queries against Grafana from Node.js.
-
Build a Simple VCL Application for Mode Data
How to build a simple VCL Application to view Mode in RAD Studio using the CData ODBC Driver for Mode.
-
Integrating Cursor CLI with PivotalTracker 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.
-
Edit and Search Workday External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Workday to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Workday objects that you can access from apps and the dashboard.
-
Getting Started with the CData Python Connector for Teamgate
Learn to install and license the CData Python Connector
-
Design BIRT Reports on PolarTeamPro Data
Provide current PolarTeamPro to your embedded analytics.
-
Build an OLAP Cube in SSAS from xBase Data
Establish a connection to xBase data from SQL Server Analysis Services, and use the xBase Data Provider to build OLAP cubes for use in analytics and reporting.
-
Sage 300 Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Sage 300 facts in real time.
-
Getting Started with the CData Power BI Connector for Datadog
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Analyze Suadeo Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Suadeo and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Build Dashboards with GraphQL Data in DBxtra
Create dynamic dashboards and perform analytics based on GraphQL in DBxtra.
-
How to work with PolarTeamPro Data in Apache Spark using SQL
Access and process PolarTeamPro Data in Apache Spark using the CData Software JDBC Driver.
-
Getting Started with the CData Excel Add-In for Pinecone
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Pinecone.
-
DataBind Email Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Email with the DevExpress Windows Forms and Web controls to provide Email to a chart.
-
Connect to Live CouchDB Data in MicroStrategy through CData Connect AI
Create a live connection to CouchDB Data in CData Connect AI and connect to your Apache CouchDB from MicroStrategy.
-
Configure the CData JDBC Driver for HelloSign in a Connection Pool in Tomcat
Connect to HelloSign from a connection pool in Tomcat.
-
How to work with Sendwithus Data in Apache Spark using SQL
Access and process Sendwithus Data in Apache Spark using the CData Software JDBC Driver.
-
Build Couchbase Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Couchbase and build visualizations in Tableau Cloud.
-
DataBind Charts to Avalara AvaTax Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Avalara AvaTax 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.
-
Enable the Delighted JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Delighted.
-
Automate Shortcut Data Replication to Azure Data Lake
Use CData Sync to customize and automate Shortcut replication to Azure Data Lake.
-
ZohoMarketingHub Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on ZohoMarketingHub facts in real time.
-
How to Easily Query Everhour Data in OpenOffice Base
Connect to Everhour data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Build AI/ML Models with Live Samanage Data using Dataiku
Connect Samanage Data with Dataiku using the CData API Driver for JDBC.
-
Automated Continuous Shopify Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Shopify replication to PostgreSQL.
-
Access Live Opsgenie Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Opsgenie in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrate Live MongoDB Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to MongoDB from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live MongoDB.
-
Access CampaignMonitor Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access CampaignMonitor from your Oracle system.
-
Getting Started with the CData Excel Add-In for Adobe Experience Manager
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Adobe Experience Manager.
-
Extend Google Sheets with OnePageCrm Data
Make calls to OnePageCrm from Google Apps Script via the API Server.
-
Connect to Azure Data Lake Storage Data in HULFT Integrate
Connect to Azure Data Lake Storage as a JDBC data source in HULFT Integrate
-
Add LeadDesk Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for LeadDesk with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Visualize Mailgun Data in Python with pandas
Use pandas and other modules to analyze and visualize live Mailgun in Python.
-
Build Brex-Powered Applications in Cursor with CData MCP Server
Use the CData API Driver for MCP Server to explore live Brex Data in Cursor to assist with building Brex-powered applications.
-
How to create Azure Synapse federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Azure Synapse in MySQL .
-
Use Agno to Talk to Your ShipStation 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 ShipStation for you.
-
Automated Continuous SAP SuccessFactors Replication to Vertica
Use CData Sync for automated, continuous, customizable SAP SuccessFactors replication to Vertica.
-
Work with OneNote Data in FoxPro
Load Microsoft OneNote into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to XML Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for XML Files.
-
Access Impala 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 Apache Impala.
-
Process & Analyze Browserless Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Browserless Data.
-
Automated Continuous Figshare Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Figshare replication to Apache Cassandra.
-
Access Live Mistral AI Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Mistral AI in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.