CData Software - Knowledge Base
Recent Articles
-
Choosing the Best Method to Connect Outlook to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Outlook from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrating Boomi Agentstudio with SendGrid Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to SendGrid, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
DataBind Wistia Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Wistia to a chart.
-
Use the CData ODBC Driver for Zoho Projects in Microsoft Power Query
You can use the CData Zoho Projects ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Zoho Projects into Microsoft Power Query.
-
Replicate Multiple Harvest Accounts via the CData Sync CLI
Replicate multiple Harvest accounts to one or many databases.
-
Connect to Stripe 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 Stripe.
-
Edit and Search SAP Business One External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of SAP Business One to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create SAP Business One objects that you can access from apps and the dashboard.
-
How to publish and share Todoist Data dashboards with Tableau Server
The CData ODBC driver for Todoist enables you integrate Todoist into Tableau dashboards.
-
Integrate Live GraphQL Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to GraphQL and integrate live GraphQL into apps built in Microsoft Power Apps.
-
Analyze BambooHR Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of BambooHR and visualize live BambooHR in Infragistics Reveal.
-
Connect to NASA Data in HULFT Integrate
Connect to NASA as a JDBC data source in HULFT Integrate
-
Analyze BigCommerce Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of BigCommerce and visualize live BigCommerce in Infragistics Reveal.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Asana
Provide connectivity to Asana through an SAP BusinessObjects universe.
-
Working with REST Data in LINQPad
Execute LINQ queries to REST in LINQPad.
-
Integrate HBase Data in the Pentaho Report Designer
Publish reports based on Apache HBase in the Pentaho BI tool.
-
Use the CData Software JDBC Driver for Apify in MicroStrategy
Connect to Apify in MicroStrategy Developer using the CData Software JDBC Driver for Apify.
-
Visualize LightSpeedRetail Data in TIBCO Spotfire through ADO.NET
Integrate LightSpeedRetail into dashboards in TIBCO Spotfire.
-
Build Office 365 Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Microsoft Office 365 and build visualizations in Tableau.
-
Connect to HelloSign Data from PowerBuilder via ADO.NET
This article demonstrates how to access HelloSign from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Integrate Live Google Directory Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Google Directory and integrate live Google Directory into apps built in Microsoft Power Apps.
-
Connect to Live LinkedIn Data in MicroStrategy through CData Connect AI
Create a live connection to LinkedIn Data in CData Connect AI and connect to your LinkedIn from MicroStrategy.
-
Create Paddle Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Paddle data access from reports, embedded analytics, and more.
-
Using the CData Software ODBC Driver for SAS Data Sets in PyCharm
Connect to SAS Data Sets as an ODBC data source in PyCharm using the CData Software ODBC Driver for SAS Data Sets.
-
Automated Continuous Adobe Commerce Replication to MySQL
Use CData Sync for automated, continuous, customizable Adobe Commerce replication to MySQL.
-
Connect to Avalara AvaTax Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Avalara AvaTax and the SQL Gateway to access Avalara AvaTax from Google Apps Script.
-
Work with NetSuite Data in FoxPro
Load NetSuite CRM & ERP into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrating OpenCode Terminal with Paymo 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.
-
Build Charts with ConstantContact Data in Clear Analytics
Create dynamic charts and perform analytics based on ConstantContact in Clear Analytics.
-
Getting Started with the CData JDBC Driver for Dynamics CRM
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Dynamics CRM.
-
Integrate with Elasticsearch Data in JReport Designer
Create charts and reports based on Elasticsearch in JReport Designer.
-
Use the CData ODBC Driver for Google Directory from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Google Directory to connect to Google Directory from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Google Directory in Excel.
-
Build a Simple VCL Application for Salesforce Data
How to build a simple VCL Application to view Salesforce & Force.com in RAD Studio using the CData ODBC Driver for Salesforce.
-
Automate Tasks in Power Automate Using the CData API Server
Automate IBM Informix actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Start with CData Sync Part 1: Licensing, Creating Connections, and Creating a Replication Job
Use CData Sync to create a replication job.
-
How to Visualize SAP SuccessFactors Data in Python with pandas
Use pandas and other modules to analyze and visualize live SAP SuccessFactors in Python.
-
Publish Reckon-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Reckon.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live SAS Data Sets using the Model Context Protocol.
-
Connect to MarkLogic Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live MarkLogic.
-
Natively Connect to Webex Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Webex. Leverage the native support for ODBC in PHP.
-
How to Create Power BI Visual Reports with Real-Time Pipeliner CRM Data
Use CData Power BI Connectors to visualize Pipeliner CRM in Power BI.
-
Connect to Neo4J Data in Ruby
Connect to Neo4J in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Visualize Demio Data in Tableau
The CData ODBC driver for Demio enables you integrate Demio into Tableau dashboards.
-
Easily Integrate Google Analytics Data in Lazarus Pascal IDE
Learn how to easily integrate live Google Analytics in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Integrate Live MariaDB Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Access Live Sage Cloud Accounting Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Sage Business Cloud Accounting into the statistical analysis tools available in SAS JMP. This article shows how to use Sage Business Cloud Accounting in the Graph Builder and Query Builder.
-
Create Informatica Mappings From/To a JDBC Data Source for PDFMonkey
Create PDFMonkey data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Rapidly Develop Shortcut-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 Shortcut.
-
Build XML-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for XML to explore live XML Data in Claude Code to assist with building XML-powered applications.
-
Create Power BI Reports on Real-Time Stripe Data
Use the CData ODBC Driver for Stripe to visualize Stripe in Power BI Desktop.
-
Edit and Search Google Analytics External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Google Analytics to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Google Analytics objects that you can access from apps and the dashboard.
-
Connect to Instantly Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Instantly.
-
Connect to Everhour Data in NetBeans
Connect to Everhour in NetBeans with the data source configuration wizard.
-
View Reports on Real-Time SAS xpt Data in Power BI Report Server
Use the CData ODBC Driver for SAS xpt to visualize SAS XPORT in Power BI Desktop and then publish them to Power BI Report Server.
-
Stream eBay Analytics Data into Apache Kafka Topics
Access and stream eBay Analytics in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Automate LionDesk Data Replication to Couchbase
Use CData Sync to Customize and automate LionDesk replication to Couchbase.
-
Connecting Pipedream with Google Calendar 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 Google Calendar data in real time.
-
Connect to Stripe Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Stripe Data and connect to Stripe in Akorbi Digital RunMyProcess.
-
Build a Singer.io Tap for QuickBooks Time With the CData Python Connector
Learn how to easily build a Singer.io Tap for live QuickBooks Time data using
-
Publish ClickTime-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live ClickTime.
-
Connecting GenSpark with Spark Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Apache Spark SQL without any replication or custom integration required.
-
Bidirectional Access to Nuclia Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Nuclia in Filemaker Pro for Mac or Windows.
-
Use the CData Software ODBC Driver for LightSpeedRetail in MicroStrategy
Connect to LightSpeedRetail in MicroStrategy Developer using the CData Software ODBC Driver for LightSpeedRetail.
-
Provide OData Services of CloudConvert Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for CloudConvert by developing a WCF Service Application.
-
Visualize Live Amplitude Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Amplitude.
-
Build Dashboards with Strava Data in DBxtra
Create dynamic dashboards and perform analytics based on Strava in DBxtra.
-
Analyze Outreach.io Data in Looker
Use CData Connect AI to connect to Outreach.io Data from Looker and build custom apps using live Outreach.io.
-
Access Live SAS Data Sets Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SAS Data Sets from your Google Sheets.
-
Connect to Greenplum Data in JRuby
Create a simple JRuby app with access to live Pivotal GreenPlum.
-
Use the CData Software JDBC Driver for Hubstaff in MicroStrategy Desktop
Connect to Hubstaff in MicroStrategy Desktop using the CData Software JDBC Driver for Hubstaff.
-
Import Hive Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Apache Hive. In this article, you will use the OData format to import Apache Hive into Microsoft Power Query.
-
Build AI Agents with SAP ByDesign Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live SAP Business ByDesign through CData Connect AI.
-
Integrate eBay Analytics Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live eBay Analytics from Informatica Cloud.
-
Import Real-Time Campaigner Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Campaigner in ColdFusion.
-
Getting Started with the CData Python Connector for Printful
Learn to install and license the CData Python Connector
-
Visualize Live Perigon Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Perigon.
-
How to Connect to & Open Oracle Sales Data in Microsoft Excel
This article uses the CData ODBC driver for Oracle Sales to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to AfterShip Data in NetBeans
Connect to AfterShip in NetBeans with the data source configuration wizard.
-
Connect to Zendesk Data in HULFT Integrate
Connect to Zendesk as a JDBC data source in HULFT Integrate
-
Extend Google Sheets with Klaviyo Data
Make calls to Klaviyo from Google Apps Script via the API Server.
-
Connect to SurveyMonkey Data in Google Apps Script via Connect AI
Use CData Connect AI to access SurveyMonkey in Google Apps Script.
-
How to import Samanage Data into Apache Solr
Use the CData Software JDBC Driver for Samanage in Data Import Handler and create an automated import of Samanage to Apache Solr Enterprise Search platform.
-
Create Data Visualizations Based On Zoho Inventory Data in Mode
Use CData Connect AI to connect to Zoho Inventory Data from Mode and build visualizations using live
-
Build Facebook-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Facebook to explore live Facebook Data in GitHub Copilot to assist with building Facebook-powered applications.
-
Connect to Oracle Sales from a Connection Pool in WebLogic
Use the CData JDBC Driver for Oracle Sales to connect to Oracle Sales from Web applications running on WebLogic.
-
Automated Continuous Bugsnag Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Bugsnag replication to Apache Kafka.
-
How to connect PolyBase to Beeminder
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Beeminder.
-
Build a Simple VCL Application for EmailOctopus Data
How to build a simple VCL Application to view EmailOctopus in RAD Studio using the CData ODBC Driver for EmailOctopus.
-
Replicate Lakebase Data in Heroku for Use in Salesforce Connect
Replicate Lakebase to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Automated Continuous Freshsales Replication to SQLite
Use CData Sync for automated, continuous, customizable Freshsales replication to SQLite.
-
Automated Continuous QuickBooks Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable QuickBooks replication to Amazon Redshift.
-
Integrate Aweber Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Aweber from Informatica Cloud.
-
Integrating Claude Code with Dynamics 365 Business Central Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Dynamics 365 Business Central within assisted coding and automated development workflows.
-
Integrate ZarMoney Data in the Pentaho Report Designer
Publish reports based on ZarMoney in the Pentaho BI tool.
-
Automated Continuous Bullhorn CRM Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Bullhorn CRM replication to delimited files (CSV/TSV).
-
Create Klaviyo-Connected Business Apps in AppSheet
Connect to Klaviyo Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Klaviyo.
-
Build AI/ML Models with Live GitHub Data using Dataiku
Connect GitHub Data with Dataiku using the CData JDBC Driver for GitHub.
-
Connect to Ontraport Data in DBArtisan
Use wizards in DBArtisan to configure Ontraport as a data source.
-
Integrate with Jira Assets Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Jira Assets to a JSON file on disk.
-
Building Dynamic Web Pages with SAP HANA XS Advanced Data Using AngularJS
Create single-page applications with live connectivity to SAP HANA XS Advanced using the CData API Server.
-
How to Query Live PingOne Data in Claude Desktop
Connect to and query live PingOne Data in Claude Desktop using CData MCP Server.