CData Software - Knowledge Base
Recent Articles
-
Provide OData Services of SAP Netweaver Gateway Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for SAP Netweaver Gateway data by developing a WCF Service Application.
-
How to Visualize Sage 300 Data in Python with pandas
Use pandas and other modules to analyze and visualize live Sage 300 data in Python.
-
Integrating Codex with Phoenix 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.
-
Connect to Square Data in RazorSQL
Connect to Square from wizards and query Square data from the GUI in the RazorSQL database management tool.
-
Connect to Short.io Data in Aqua Data Studio
Access Short.io data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Getting Started with the CData JDBC Driver for Campaigner
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Campaigner.
-
Integrate with Invoiced Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Invoiced data to a JSON file on disk.
-
Connect to Beeminder Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Beeminder data using standard SQL.
-
Build Agents in Relevance AI with Access to Live Box Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Box data within intelligent agent workflows.
-
Use Manus AI to Talk to Your Moosend Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Moosend data.
-
Link Short.io with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Short.io data in Filemaker Pro for Mac or Windows.
-
Connect to Microsoft Exchange Data from PowerBuilder via ADO.NET
This article demonstrates how to access Microsoft Exchange data from Appeon PowerBuilder using the CData ADO.NET Provider for Microsoft Exchange.
-
Integrate Dify with Live Pinterest Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Pinterest data.
-
Automated Continuous SAP ByDesign Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable SAP ByDesign replication to delimited files (CSV/TSV).
-
Access Live Coda Data in Coginiti Pro
Connect to and query live Coda data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Viewing Spotify Data in RAD Studio Data Explorer
How to view Spotify data in RAD Studio Data Explorer using the CData ODBC Driver for Spotify.
-
Connect to Azure Data Lake Storage Data from a Connection Pool in Jetty
The Azure Data Lake Storage JDBC Driver supports connection pooling: This article shows how to connect faster to Azure Data Lake Storage data from Web apps in Jetty.
-
How to create SAP federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for SAP data in MySQL .
-
Automated Continuous SharePoint Replication to Amazon S3
Use CData Sync for automated, continuous, customizable SharePoint replication to Amazon S3.
-
How to Visualize eBay Analytics Data in Python with pandas
Use pandas and other modules to analyze and visualize live eBay Analytics data in Python.
-
Integrate Cursor with Live Bitbucket Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Bitbucket data from within the editor.
-
Connect to Azure Table Data from Crystal Reports
Use CData Connect AI to connect to and report on live Azure Table data from Crystal Reports.
-
Connect to Act-On Data in Jaspersoft Studio
Execute SQL to remote Act-On data in Jaspersoft Studio.
-
Query Salesloft Data in DataGrip
Create a Data Source for Salesloft in DataGrip and use SQL to query live Salesloft data.
-
Build Wistia-Connected Apps in Choreo
Use CData Connect AI to connect to Wistia Data from Choreo and build custom apps using live Wistia data.
-
Import Real-Time Codat Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Codat data in ColdFusion.
-
How to Connect to Live SendGrid Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your SendGrid data for you.
-
Automated Continuous Twilio Replication to Oracle
Use CData Sync for automated, continuous, customizable Twilio replication to Oracle.
-
How to Access Elasticsearch Data Using Entity Framework
This article shows how to access Elasticsearch data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Build an OLAP Cube in SSAS from Apify Data
Establish a connection to Apify data data from SQL Server Analysis Services, and use the Apify Data Provider to build OLAP cubes for use in analytics and reporting.
-
Migrating data from Salesforce to Google BigQuery using CData SSIS Components.
Easily push Salesforce data to Google BigQuery using the CData SSIS Tasks for Salesforce and Google BigQuery.
-
Getting Started with the CData ODBC Driver for Mouseflow
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Mouseflow.
-
Use the CData Software ODBC Driver for OData in MicroStrategy
Connect to OData services in MicroStrategy Developer using the CData Software ODBC Driver for OData.
-
Use the CData ODBC Driver for Clockify from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Clockify to connect to Clockify data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Clockify data in Excel.
-
Connect to PingOne from Asprova with CData Software ODBC Driver for PingOne
This article shows how to connect faster to PingOne data from Asprova.
-
Rapidly Develop Pushbullet-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 Pushbullet.
-
Connect to Stack Exchange Data in RapidMiner
Integrate Stack Exchange data with standard components and data source configuration wizards in RapidMiner Studio.
-
DataBind Controls to SAP Hybris C4C Data in C++Builder
DataBind to SAP Hybris C4C data in C++Builder with standard components and controls.
-
Automated Continuous CampaignMonitor Replication to Vertica
Use CData Sync for automated, continuous, customizable CampaignMonitor replication to Vertica.
-
Integrate QuickBooks Online with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate QuickBooks Online with External Services.
-
Automate Scrapfly Data Replication to SAP HANA
Use CData Sync to customize and automate Scrapfly data replication to SAP HANA.
-
Access HCL Domino Data from MySQL in Amazon QuickSight
Connect to HCL Domino and build visualizations of HCL Domino data using a MySQL Connection in Amazon QuickSight.
-
Use Dash to Build Web Apps on Salesforce Pardot Data via CData Connect AI
Build interactive Dash web apps on live Salesforce Pardot data using pandas and the CData Connect AI Python SDK.
-
Integrate with Discourse Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Discourse data to a JSON file on disk.
-
Salesforce: Migrating to OAuthPKCE Authentication
Salesforce is requiring PKCE and Refresh Token Rotation for OAuth connected apps. CData Connect AI migrates automatically; Drivers, Sync, and Arc customers must update their connection strings and re-authenticate.
-
Connect to Autopilot Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Autopilot and the SQL Gateway to access Autopilot data from Google Apps Script.
-
Getting Started with the CData Python Connector for Microsoft Dataverse
Learn to install and license the CData Python Connector and configure a connection to live Microsoft Dataverse data.
-
How to Query Live Contentful Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Contentful data data in natural language using Python.
-
Build SAP Business Warehouse-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to SAP Business Warehouse data and build web apps with connectivity to live SAP Business Warehouse data.
-
Slack Reporting in OBIEE with the Slack JDBC Driver
Deploy the Slack JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Use the CData ODBC Driver for Sage 200 in Microsoft Power Query
You can use the CData Sage 200 ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Sage 200 data into Microsoft Power Query.
-
Publish Crystal Reports on Access Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Access data.
-
Prepare, Blend, and Analyze Tally Data in Alteryx Designer (ODBC)
Build workflows to access live Tally data for self-service data analytics.
-
Use Agno to Talk to Your SAP ByDesign 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 SAP ByDesign data for you.
-
How to Work with Basecamp Data in AWS Glue Jobs Using JDBC
Connect to Basecamp from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Access Live Cloudant Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Cloudant data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Integrating Claude Code CLI with Zoho Projects 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.
-
Publish JobNimbus-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live JobNimbus data.
-
Connect to LDAP Objects in Ruby
Connect to LDAP objects in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automated Continuous Amazon Athena Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Amazon Athena replication to Apache Kafka.
-
How to connect Amazon QuickSight to MongoDB Data
Create a connection to MongoDB data in CData Connect AI and insert MongoDB data into Amazon QuickSight SPICE to build interactive dashboards.
-
Visualize Live IBM Cloud Object Storage Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live IBM Cloud Object Storage data.
-
Extract, Transform, and Load Sentry Data in Informatica PowerCenter
Create a simple Workflow for Sentry data in Informatica PowerCenter.
-
Automate Tavily Data Replication to SAP HANA
Use CData Sync to customize and automate Tavily data replication to SAP HANA.
-
Connect to MailerSend Data from a Connection Pool in Jetty
The MailerSend JDBC Driver supports connection pooling: This article shows how to connect faster to MailerSend data from Web apps in Jetty.
-
Process & Analyze Drip Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Drip Data.
-
Build Data Flows from SQL Server to Sage Cloud Accounting through SSIS
Easily push SQL Server data to Sage Cloud Accounting using the CData SSIS Tasks for Sage Cloud Accounting.
-
Build Apps with Live Bitly data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Bitly data into the Adalo platform and build custom mobile and web applications with real-time Bitly data.
-
Getting Started with the CData Power BI Connector for Missive
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
How to Access Quaderno Data Using Entity Framework
This article shows how to access Quaderno data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Automated Continuous WooCommerce Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable WooCommerce replication to PostgreSQL.
-
Visualize Live Freshsales Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Freshsales data.
-
Integrating Antigravity CLI with Snapchat Ads data via CData CLI
Connect Snapchat Ads data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Publish Webflow-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Webflow data.
-
Connect Mailgun to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Mailgun with IBM WebSphere for seamless data integration and connectivity.
-
Write a Simple Go Application to work with SendPulse Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SendPulse data.
-
Use the CData Software JDBC Driver for Oracle HCM Cloud in MicroStrategy Desktop
Connect to Oracle HCM Cloud data in MicroStrategy Desktop using the CData Software JDBC Driver for Oracle HCM Cloud.
-
Use Biml to Build SSIS Tasks to Replicate Mode Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Mode data to SQL Server.
-
CData Sync - Change Tracking in Dynamics 365 Entities for CDC Replication
How to enable automatic change tracking in Dynamics 365 entities for change-data-capture replication with CData Sync
-
Automated Continuous LinkedIn Replication to MongoDB
Use CData Sync for automated, continuous, customizable LinkedIn replication to MongoDB.
-
Design BIRT Reports on Aha! Data
Provide current Aha! data to your embedded analytics.
-
Write a Simple Go Application to work with CockroachDB Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to CockroachDB data.
-
Adobe Analytics Reporting in OBIEE with the Adobe Analytics JDBC Driver
Deploy the Adobe Analytics JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to Samanage Data from AWS Glue
Use CData Connect AI to gain access to live Samanage data from your AWS Glue jobs.
-
Integrate Devin with Live Grafana Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Grafana data.
-
Connecting to Azure Cosmos DB with MongoDB Drivers
Set up an Azure Cosmos DB account using the MongoDB API and connect using any CData Software Driver for MongoDB.
-
Query GitHub Data as a SQL Server Database in Node.js
Execute SQL Server queries against GitHub data from Node.js.
-
Automated Continuous FreshBooks Replication to Snowflake
Use CData Sync for automated, continuous, customizable FreshBooks replication to Snowflake.
-
Publish Crystal Reports on ZohoInvoice Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date ZohoInvoice data.
-
Moving Data from ZohoDesk to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live ZohoDesk data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Getting Started with the CData Python Connector for PolarTeamPro
Learn to install and license the CData Python Connector and configure a connection to live PolarTeamPro data.
-
Use Dash to Build to Web Apps on Placid Data
Create Python applications that use pandas and Dash to build Placid-connected web apps.
-
Publish Reports with Factorial Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Factorial data.
-
Create SAP Hybris C4C-Connected Nintex Workflows
Use CData Connect AI to connect to SAP Hybris C4C Data from Nintex Workflow Cloud and build custom workflows using live SAP Hybris C4C data.
-
Connecting GenSpark with SAP HANA Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to SAP HANA data without any replication or custom integration required.
-
Integrate Zuora Data in the Pentaho Report Designer
Publish reports based on Zuora data in the Pentaho BI tool.
-
Configure the CData JDBC Driver for Mode in a Connection Pool in Tomcat
Connect to Mode data from a connection pool in Tomcat.
-
Integrate Pipedrive Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Pipedrive data and integrate live Pipedrive data into your Power Automate tasks.
-
How to connect to Microsoft Dataverse Data from IntelliJ
Integrate connectivity to Microsoft Dataverse data with wizards in IntelliJ.
-
DataBind Beeminder Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Beeminder data to a chart.