CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Impala Replication to SQL Server
Use CData Sync for automated, continuous, customizable Impala replication to SQL Server.
-
Working with SurveyMonkey Data in LINQPad
Execute LINQ queries to SurveyMonkey in LINQPad.
-
Query EnterpriseDB Data as a MySQL Database in Node.js
Execute MySQL queries against EnterpriseDB from Node.js.
-
Easily Integrate CapsuleCRM Data in Lazarus Pascal IDE
Learn how to easily integrate live CapsuleCRM in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Write a Simple Go Application to work with Bannerbear Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Bannerbear.
-
Connect to Zoho Projects Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Zoho Projects.
-
Integrating Antigravity CLI with Workable via CData CLI
Connect Workable to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Excel Spreadsheet Automation on Shopify Data with the QUERY Formula
Pull data from Shopify, automate spreadsheets, and more with the QUERY formula.
-
Object-Relational Mapping (ORM) with Wistia 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 Wistia into a Java-based ORM framework, Hibernate.
-
How to Visualize Google Spanner 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 Google Spanner in Python.
-
Visualize Live GraphQL Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live GraphQL into custom reports in Power BI.
-
Bidirectional Access to Oracle Eloqua Reporting Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Oracle Eloqua Reporting in Filemaker Pro for Mac or Windows.
-
DataBind Procore Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Procore to a chart.
-
How to Connect to Live JSON Services in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live JSON without replication.
-
A PostgreSQL Interface for PDFMonkey Data using the CData ODBC Driver
Use the SQL Gateway and PDFMonkey ODBC Driver to create a PostgreSQL entry-point for data access.
-
Analyze Adobe Analytics Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Adobe Analytics and visualize live Adobe Analytics in Infragistics Reveal.
-
Access Live Access Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Microsoft Access into the statistical analysis tools available in SAS JMP. This article shows how to use Microsoft Access in the Graph Builder and Query Builder.
-
Connect to Basecamp Data from PowerBuilder via JDBC
This article demonstrates how to access Basecamp from PowerBuilder using the Basecamp JDBC Driver.
-
How to Query Live Sybase IQ Data in Claude Desktop
Connect to and query live Sybase IQ Data in Claude Desktop using CData MCP Server.
-
Provide OData Services of PolarTeamPro Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for PolarTeamPro by developing a WCF Service Application.
-
Easily Integrate Stack Exchange Data in Lazarus Pascal IDE
Learn how to easily integrate live Stack Exchange in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Use the CData ODBC Driver for QuickBooks Time from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for QuickBooks Time to connect to QuickBooks Time from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring QuickBooks Time in Excel.
-
Access Acumatica Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Acumatica ERP from HeidiSQL.
-
Visualize BigCommerce 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 BigCommerce into TIBCO Spotfire.
-
Use Biml to Build SSIS Tasks to Replicate EmailOctopus Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate EmailOctopus to SQL Server.
-
How to Connect to & Open PabblySubscriptions Data in Microsoft Excel
This article uses the CData ODBC driver for PabblySubscriptions to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Visualize Pipeliner CRM Data in TIBCO Spotfire through ADO.NET
Integrate Pipeliner CRM into dashboards in TIBCO Spotfire.
-
Connect to Brex Data in Jaspersoft Studio
Execute SQL to remote Brex in Jaspersoft Studio.
-
Build Charts with SAP HANA Data in Clear Analytics
Create dynamic charts and perform analytics based on SAP HANA in Clear Analytics.
-
Migrating data from Rootly to Databricks using CData SSIS Components.
Easily push Rootly to Databricks using the CData SSIS Tasks for Rootly and Databricks.
-
Automated Continuous Omnisend Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Omnisend replication to AlloyDB.
-
Viewing Apify Data in RAD Studio Data Explorer
How to view Apify in RAD Studio Data Explorer using the CData ODBC Driver for Apify.
-
Getting Started with the CData Power BI Connector for Xero
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Xero.
-
Rapidly Develop Printify-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 Printify.
-
Connect to Bitbucket Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Bitbucket using standard SQL.
-
Connect to Live OneNote Data in PostGresSQL Interface through CData Connect AI
Create a live connection to OneNote in CData Connect AI and connect to your Microsoft OneNote from PostgreSQL.
-
Create Informatica Mappings From/To an ODBC Data Source for Confluence
Create an ODBC connection to Confluence in Informatica and browse and transfer Atlassian Confluence.
-
Connect to Parallel Data in Ruby
Connect to Parallel in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to CircleCI Data in RazorSQL
Connect to CircleCI from wizards and query CircleCI from the GUI in the RazorSQL database management tool.
-
Use the CData Software ODBC Driver for Dynamics CRM in MicroStrategy Web
Connect to Microsoft Dynamics CRM in MicroStrategy Web using the CData Software ODBC Driver for Dynamics CRM.
-
Connect to Adobe Commerce Data in Aqua Data Studio
Access Adobe Commerce from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Create Reports with Trello Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Trello.
-
Use the CData Software ODBC Driver for Demio in MicroStrategy Web
Connect to Demio in MicroStrategy Web using the CData Software ODBC Driver for Demio.
-
Build Oracle Sales-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Oracle Sales.
-
Connect to Amazon Marketplace from a Connection Pool in WebLogic
Use the CData JDBC Driver for Amazon Marketplace to connect to Amazon Marketplace from Web applications running on WebLogic.
-
Connect to Mixpanel Data from PowerBuilder via ADO.NET
This article demonstrates how to access Mixpanel from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Analyze Cvent Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Cvent in Microsoft R Open.
-
Connect to and Visualize Live LinkedIn Ads Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live LinkedIn Ads.
-
Replicate Zendesk Data in Heroku for Use in Salesforce Connect
Replicate Zendesk to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Integrating LlamaIndex with Presto Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Presto in real time.
-
How to integrate Outlook with Apache Airflow
Access and process Outlook in Apache Airflow using the CData JDBC Driver.
-
Connect to Discord Data in Aqua Data Studio
Access Discord from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Create Reports from Blackbaud FE NXT Data in Looker Studio
Use CData Connect AI to gain access to live Blackbaud FE NXT and create custom reports in Looker Studio.
-
Query, Visualize, and Share live Azure Synapse Data in Redash
Use CData Connect AI to connect to live Azure Synapse in Redash for querying, visualizing, and sharing.
-
Use CData Connect AI to Access Snapchat Ads Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Snapchat Ads in the Power Pivot business intelligence tool.
-
Build Apps with Live Active Directory in Adalo using CData Connect AI
Use CData Connect AI to integrate live Active Directory into the Adalo platform and build custom mobile and web applications with real-time Active Directory.
-
Access Quickbase 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 Quickbase.
-
Getting Started with the CData Excel Add-In for Bitbucket
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Bitbucket.
-
Extract, Transform, and Load Gumroad Data in Informatica PowerCenter
Create a simple Workflow for Gumroad in Informatica PowerCenter.
-
Build Semantic Layer Views for Couchbase Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Couchbase.
-
Integrating LangGraph with Microsoft Exchange Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Microsoft Exchange within automated workflows.
-
Use CData Connect AI to Access Salesforce Pardot Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Salesforce Pardot in the Power Pivot business intelligence tool.
-
Connect to AfterShip Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for AfterShip and the SQL Gateway to access AfterShip from Google Apps Script.
-
How to Build an ETL App for Egnyte Data in Python with CData
Create ETL applications and real-time data pipelines for Egnyte in Python with petl.
-
How to connect PolyBase to PagerDuty
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live PagerDuty.
-
Natively Connect to SAP Ariba Source Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to SAP Ariba Source. Leverage the native support for ODBC in PHP.
-
How to Work with Flowlu Data in AWS Glue Jobs Using JDBC
Connect to Flowlu from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Create Datasets from MariaDB in Domo Workbench and Build Visualizations of MariaDB Data in Domo
Use the CData Software ODBC Driver for MariaDB to create datasets from MariaDB in Domo Workbench and then build visualizations in the Domo service.
-
How to connect PolyBase to Jira Assets
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Jira Assets.
-
Automated Office 365 Data Replication to Teradata
Use CData Sync to Customize and automate Microsoft Office 365 replication to Teradata.
-
Integrating ConvertAPI Data in Talend Cloud Data Management Platform
Connect ConvertAPI Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Automated Continuous MailChimp Replication to MongoDB
Use CData Sync for automated, continuous, customizable MailChimp replication to MongoDB.
-
Publish Crystal Reports on Splunk Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Splunk.
-
Visualize Live AgileCRM Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live AgileCRM.
-
Easily Integrate Elorus Data in Lazarus Pascal IDE
Learn how to easily integrate live Elorus in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Create Couchbase-Connected Business Apps in AppSheet
Connect to Couchbase Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Couchbase.
-
Connect to Mistral AI Data from PowerBuilder via JDBC
This article demonstrates how to access Mistral AI from PowerBuilder using the Mistral AI JDBC Driver.
-
Build Apps with Live Spotify Data Using the Low-Code Development Platform of Mendix
Connect Spotify with Mendix to build apps using the CData API Driver for JDBC.
-
Build Everhour-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Everhour and build web apps with connectivity to live Everhour.
-
Access Live GitLab Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live GitLab from your Excel spreadsheets.
-
Analyze OnePageCrm Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze OnePageCrm in Microsoft R Open.
-
Connect OnePageCrm to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect OnePageCrm with IBM WebSphere for seamless data integration and connectivity.
-
Connect to SAP Fieldglass Data from a Connection Pool in Jetty
The SAP Fieldglass JDBC Driver supports connection pooling: This article shows how to connect faster to SAP Fieldglass from Web apps in Jetty.
-
Load Sugar CRM Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Sugar CRM to a database.
-
Connect to JSON Services from PowerBuilder via JDBC
This article demonstrates how to access JSON from PowerBuilder using the JSON JDBC Driver.
-
Using the CData Software ODBC Driver for Pingdom in PyCharm
Connect to Pingdom as an ODBC data source in PyCharm using the CData Software ODBC Driver for Pingdom.
-
Extract, Transform, and Load BambooHR Data in Informatica PowerCenter
Create a simple Workflow for BambooHR in Informatica PowerCenter.
-
Visualize Live LightSpeedRetail Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live LightSpeedRetail.
-
Access Live SQL Server Data in AWS Lambda
Connect to live Microsoft SQL Server in AWS Lambda using the CData JDBC Driver.
-
Use Dash to Build to Web Apps on Bright Data Data
Create Python applications that use pandas and Dash to build Bright Data-connected web apps.
-
Automate Dotmailer Data Replication to Azure Data Lake
Use CData Sync to customize and automate Dotmailer replication to Azure Data Lake.
-
Connect to Outreach.io Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Outreach.io as an External Source in Dremio.
-
Connect to Google Tasks Data in CloverDX (formerly CloverETL)
Transfer Google Tasks using the visual workflow in the CloverDX data integration tool.
-
Analyze Onfleet Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Onfleet in Microsoft R Open.
-
Create Power BI Reports on Real-Time Epicor Kinetic Data
Use the CData ODBC Driver for Epicor Kinetic to visualize Epicor Kinetic in Power BI Desktop.
-
DataBind Charts to Nethunt Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Nethunt 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.
-
Connecting Pipedream with Paylocity 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 Paylocity data in real time.
-
Automated Continuous Planio Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Planio replication to Apache Kafka.
-
Use the CData Software ODBC Driver for Reply.io in MicroStrategy Desktop
Connect to Reply.io in MicroStrategy Desktop using the CData Software ODBC Driver for Reply.io.
-
Use the CData Software JDBC Driver for Bitbucket in MicroStrategy
Connect to Bitbucket in MicroStrategy Developer using the CData Software JDBC Driver for Bitbucket.