CData Software - Knowledge Base
Recent Articles
-
Automated Continuous xBase Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable xBase replication to Amazon Redshift.
-
Create WooCommerce-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to WooCommerce Data from OutSystems and build custom enterprise apps using live WooCommerce.
-
How to Seamlessly Import JotForm Data into IBM SPSS Modeler
Integrate JotForm data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to load LinkedIn data into Elasticsearch via Logstash
Introducing a simple method to load LinkedIn data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Build MVC Applications with Connectivity to Yelp Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Yelp from an ASP.NET MVC application.
-
Connect to AlloyDB 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 Google AlloyDB.
-
Stream Zendesk Data into Apache Kafka Topics
Access and stream Zendesk in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Provide OData Services of MySQL Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for MySQL by developing a WCF Service Application.
-
Migrating data from Ontraport to Google BigQuery using CData SSIS Components.
Easily push Ontraport to Google BigQuery using the CData SSIS Tasks for Ontraport and Google BigQuery.
-
A PostgreSQL Interface for Nethunt Data using the CData ODBC Driver
Use the SQL Gateway and Nethunt ODBC Driver to create a PostgreSQL entry-point for data access.
-
View Reports on Real-Time ShipStation Data in Power BI Report Server
Use the CData ODBC Driver for ShipStation to visualize ShipStation in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrating Cursor CLI with AdRoll 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.
-
Use the CData Software JDBC Driver for Office 365 in MicroStrategy Desktop
Connect to Microsoft Office 365 in MicroStrategy Desktop using the CData Software JDBC Driver for Office 365.
-
Load Zoho Recruit Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Zoho Recruit to a database.
-
Moving Data from Stripe to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Stripe data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to Create Power BI Visual Reports with Real-Time Procore Data
Use CData Power BI Connectors to visualize Procore in Power BI.
-
Query Apollo Data as a SQL Server Database in Node.js
Execute SQL Server queries against Apollo from Node.js.
-
Getting Started with the CData Excel Add-In for Neo4J
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Neo4J.
-
Use the CData ODBC Driver for Unbounce from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Unbounce to connect to Unbounce from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Unbounce in Excel.
-
Automated Continuous Tickspot Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Tickspot replication to Amazon S3.
-
Create Basecamp Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Basecamp from PowerBI.com to create Power BI Dataflows with real-time data.
-
Create Dynamic SAP BusinessObjects BI Grids Using the Infragistics XamDataGrid
Learn how you can connect SAP BusinessObjects BI to Infragistics XamDataGrid to build dynamic grids.
-
Build a PostgreSQL Interface for Azure Table Data using the CData JDBC Driver
Use the Remoting features of the Azure Table JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automate Freshservice Data Replication to Azure Synapse
Use CData Sync to customize and automate Freshservice replication to Azure Synapse.
-
How to Query Live Mixpanel Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Mixpanel data in natural language using Python.
-
How to Connect to Live Facebook Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Facebook for you.
-
Access Google Contacts Data from MySQL in Amazon QuickSight
Connect to Google Contacts and build visualizations of Google Contacts using a MySQL Connection in Amazon QuickSight.
-
Integrating LangGraph with Amazon Athena Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Amazon Athena within automated workflows.
-
Connect to and Query Browserless Data in QlikView over ODBC
Create data visualizations with Browserless in QlikView.
-
Connect to BambooHR Data as an External Source in Dremio
Use the CData JDBC Driver to connect to BambooHR as an External Source in Dremio.
-
How to Work with Basecamp Data in ETL Validator JDBC
Connect to Basecamp from ETL Validator jobs using the CData Software JDBC Driver.
-
Excel Spreadsheet Automation on Oracle Data with the QUERY Formula
Pull data from Oracle, automate spreadsheets, and more with the QUERY formula.
-
Automated Continuous Retently Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Retently replication to Apache Kafka.
-
Choosing the Best Method to Connect Tanda to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Tanda from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to MySQL Data in DBeaver
Use the CData ODBC Driver to connect to MySQL in DBeaver.
-
Integrating GitHub Copilot CLI with DocuSign 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.
-
Integrating Dataiku with SAP Business One Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live SAP Business One.
-
Getting Started with the CData SSIS Components for PolarTeamPro
Complete guide to installing, licensing, and connecting with the CData SSIS Components for PolarTeamPro.
-
Access Insightly Data from MySQL in PHP
Connect to Insightly through the standard MySQL libraries in PHP.
-
Write a Simple Go Application to work with SharePoint Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Microsoft SharePoint.
-
Connect to AdRoll Data in NetBeans
Connect to AdRoll in NetBeans with the data source configuration wizard.
-
Connect to Customer.io Data in RazorSQL
Connect to Customer.io from wizards and query Customer.io from the GUI in the RazorSQL database management tool.
-
Connect to Adobe Analytics Data in DBeaver
Use the CData ODBC Driver to connect to Adobe Analytics in DBeaver.
-
Automate ShipStation Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live ShipStation and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Extend Google Sheets with Adobe Commerce Data
Make calls to Adobe Commerce from Google Apps Script via the API Server.
-
Integrate with SendInBlue Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy SendInBlue to a JSON file on disk.
-
Connect to Mouseflow Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Mouseflow as an External Source in Dremio.
-
Create Reports with NASA Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date NASA.
-
Write a Simple Go Application to work with Exact Online Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Exact Online.
-
How to Seamlessly Import SAS Data Sets Data into IBM SPSS Modeler
Integrate SAS Data Sets data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to SAP ByDesign Data from Crystal Reports
Use CData Connect AI to connect to and report on live SAP Business ByDesign from Crystal Reports.
-
DataBind Controls to Unbounce Data in Delphi
DataBind to Unbounce in Delphi with standard data access components and controls.
-
Access Freshdesk Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Freshdesk from your Oracle system.
-
Design BIRT Reports on Wave Financial Data
Provide current Wave Financial to your embedded analytics.
-
Connect ConvertKit to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect ConvertKit with IBM WebSphere for seamless data integration and connectivity.
-
Visualize Snowflake 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 Snowflake into TIBCO Spotfire.
-
Object-Relational Mapping (ORM) with SharePoint Excel Services 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 SharePoint Excel Services into a Java-based ORM framework, Hibernate.
-
Create Pipedrive Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Pipedrive from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect and Visualize Live HubSpot Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live HubSpot into the Databricks platform and create visualization dashboards with real-time HubSpot.
-
Connecting Moonlit Workflow with Greenplum Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Pivotal GreenPlum in real time.
-
Automated Continuous QuickBooks Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable QuickBooks replication to delimited files (CSV/TSV).
-
Connect to Live Zendesk Data in MicroStrategy through CData Connect AI
Create a live connection to Zendesk Data in CData Connect AI and connect to your Zendesk from MicroStrategy.
-
Query MailerSend Data in ColdFusion
Write standard ColdFusion data access code to connect to MailerSend.
-
Connect to Real-Time Oracle Sales Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Oracle Sales and Dataflow to import and use Oracle Sales in Power Apps.
-
Import Amazon Marketplace Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Amazon Marketplace. In this article, you will use the OData format to import Amazon Marketplace into Microsoft Power Query.
-
Automated Continuous ChargeOver Replication to MongoDB
Use CData Sync for automated, continuous, customizable ChargeOver replication to MongoDB.
-
Build Dashboards with JobNimbus Data in Dundas BI
Create dynamic dashboards and perform analytics based on JobNimbus in Dundas BI.
-
Access Live Wave Financial Data in TIBCO Data Virtualization
Use the Wave Financial Tibco DV Adapter to create a Wave Financial data source in TIBCO Data Virtualization Studio and gain access to live Wave Financial from your TDV Server.
-
Automated Continuous Wistia Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Wistia replication to Apache Kafka.
-
Create API-Connected Applications in Appsmith
Connect to API Data via CData Connect AI in Appsmith and create custom business applications with real-time access to API.
-
Getting Started with the CData JDBC Driver for JDBC-ODBC Bridge
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for JDBC-ODBC Bridge.
-
Create Reports with FreeAgent Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date FreeAgent.
-
Viewing ClickUp Data in RAD Studio Data Explorer
How to view ClickUp in RAD Studio Data Explorer using the CData ODBC Driver for ClickUp.
-
Integrate Adobe Commerce Data into Power Automate Desktop using CData Connect
CData Connect for Adobe Commerce Data enables you to integrate Adobe Commerce into workflows built using Microsoft Power Automate Desktop.
-
Visualize Live SAS Data Sets Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live SAS Data Sets using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Microsoft Ads Data in DBArtisan
Use wizards in DBArtisan to configure Microsoft Ads as a data source.
-
Build a Simple VCL Application for ServiceDesk Plus Data
How to build a simple VCL Application to view ServiceDesk Plus in RAD Studio using the CData ODBC Driver for ServiceDesk Plus.
-
How to connect to Certinia Data from IntelliJ
Integrate connectivity to Certinia with wizards in IntelliJ.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Outlook
Provide connectivity to Outlook through an SAP BusinessObjects universe.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Bullhorn CRM actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Use the CData Software JDBC Driver for CouchDB in MicroStrategy Web
Connect to Apache CouchDB in MicroStrategy Web using the CData Software JDBC Driver for CouchDB.
-
Import Real-Time LightSpeedRetail Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use LightSpeedRetail in ColdFusion.
-
Edit and Search Kintone External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Kintone to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Kintone objects that you can access from apps and the dashboard.
-
Edit and Search External SAP ByDesign Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of SAP Business ByDesign to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create SAP ByDesign Data objects that you can access from apps and the dashboard.
-
Automated Continuous Access Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Access replication to Azure SQL Database.
-
Build a Simple VCL Application for Act-On Data
How to build a simple VCL Application to view Act-On in RAD Studio using the CData ODBC Driver for Act-On.
-
Integrating Antigravity CLI with Teradata via CData CLI
Connect Teradata to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connecting Moonlit Workflow with ADP Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your ADP in real time.
-
Build Oracle Service Cloud-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Oracle Service Cloud Data from Zoho Analytics and import live Oracle Service Cloud.
-
Automate SpaceX Data Replication to Azure Synapse
Use CData Sync to customize and automate SpaceX replication to Azure Synapse.
-
Connect to Microsoft Ads Data in Google Apps Script via Connect AI
Use CData Connect AI to access Microsoft Ads in Google Apps Script.
-
How to work with Deel Data in Apache Spark using SQL
Access and process Deel Data in Apache Spark using the CData Software JDBC Driver.
-
Access Live Oracle Eloqua Reporting Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Oracle Eloqua Reporting in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Create Power BI Reports on Real-Time ActiveCampaign Data
Use the CData ODBC Driver for ActiveCampaign to visualize ActiveCampaign in Power BI Desktop.
-
How to Create Power BI Visual Reports with Real-Time Bullhorn CRM Data
Use CData Power BI Connectors to visualize Bullhorn CRM in Power BI.
-
Add Salesforce Data 360 Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Salesforce Data 360 with the Informatica Enterprise Data Catalog to classify and organize data.
-
Configure the CData JDBC Driver for Tavily in a Connection Pool in Tomcat
Connect to Tavily from a connection pool in Tomcat.
-
Connect to Spotify from Asprova with CData Software ODBC Driver for Spotify
This article shows how to connect faster to Spotify data from Asprova.
-
Integrating Cursor CLI with Perigon 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.
-
Object-Relational Mapping (ORM) with HelloSign 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 HelloSign into a Java-based ORM framework, Hibernate.