CData Software - Knowledge Base
Recent Articles
-
Rapidly Develop Hubstaff-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 Hubstaff.
-
Validate Helpscout Data with QuerySurge
Access and validate Helpscout in QuerySurge using the CData JDBC Driver.
-
Back Up Bitbucket to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Bitbucket. In this article, we will employ an SSIS workflow to populate a database with Bitbucket data.
-
Easily Integrate Basecamp Data in Lazarus Pascal IDE
Learn how to easily integrate live Basecamp in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Integrating OpenCode Terminal 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.
-
Integrating Cursor CLI with Teamwork 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.
-
Automated Continuous Sage Intacct Replication to Databricks
Use CData Sync for automated, continuous, customizable Sage Intacct replication to Databricks.
-
Integrating Claude Code CLI with CapsuleCRM 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.
-
Analyze Greenplum Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Pivotal GreenPlum in Microsoft R Open.
-
Build a PostgreSQL Interface for Active Directory Data using the CData JDBC Driver
Use the Remoting features of the Active Directory JDBC Driver to create a PostgreSQL entry-point for data access.
-
Excel Spreadsheet Automation on Sage 200 Data with the QUERY Formula
Pull data from Sage 200, automate spreadsheets, and more with the QUERY formula.
-
Automated Continuous Moosend Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Moosend replication to PostgreSQL.
-
Connect to Oracle Eloqua Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Oracle Eloqua using standard SQL.
-
Connect to Exact Online Data in RazorSQL
Connect to Exact Online from wizards and query Exact Online from the GUI in the RazorSQL database management tool.
-
Access Live Box Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Box into the statistical analysis tools available in SAS JMP. This article shows how to use Box in the Graph Builder and Query Builder.
-
Use Biml to Build SSIS Tasks to Replicate Databricks Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Databricks to SQL Server.
-
Analyze Datadog Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Datadog from Power Pivot. You will use the Table Import Wizard to load Datadog. You can visually build the import query or use any SQL supported by the driver.
-
Automated Continuous MarkLogic Replication to SQL Server
Use CData Sync for automated, continuous, customizable MarkLogic replication to SQL Server.
-
Create a Data Access Object for Email Data using JDBI
A brief overview of creating a SQL Object API for Email in JDBI.
-
Prepare, Blend, and Analyze RabbitMQ Data in Alteryx Designer (ODBC)
Build workflows to access live RabbitMQ for self-service data analytics.
-
Connect to MarkLogic Data in Jaspersoft Studio
Execute SQL to remote MarkLogic in Jaspersoft Studio.
-
Create Informatica Mappings From/To a JDBC Data Source for CSV
Create CSV data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Automated Continuous Delighted Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Delighted replication to OneLake in Microsoft Fabric.
-
Automated SuiteCRM Data Replication to Teradata
Use CData Sync to Customize and automate SuiteCRM replication to Teradata.
-
Migrating data from Parallel to Google BigQuery using CData SSIS Components.
Easily push Parallel to Google BigQuery using the CData SSIS Tasks for Parallel and Google BigQuery.
-
Connect to Foursquare Data from PowerBuilder via ADO.NET
This article demonstrates how to access Foursquare from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Bullhorn CRM to Power BI dashboards. Simply drag and drop Bullhorn CRM into data visuals on the Power BI canvas.
-
Integrate Live Confluence Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Confluence from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Atlassian Confluence.
-
Explore Geographical Relationships in Adobe Commerce Data with Power Map
Create data visualizations with Adobe Commerce in Power Map.
-
Automated Continuous FreshBooks Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable FreshBooks replication to Apache Kafka.
-
Use Dash to Build to Web Apps on OData Services
Create Python applications that use pandas and Dash to build OData-connected web apps.
-
Replicate ZohoDesk Data to Multiple Databases
Replicate ZohoDesk to disparate databases with a point-and-click configuration.
-
How to Connect to Live Avalara AvaTax Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Avalara AvaTax securely in real time.
-
Working with Perigon Data in LINQPad
Execute LINQ queries to Perigon in LINQPad.
-
How to Build an ETL App for Oracle SCM Data in Python with CData Connect AI
Build ETL pipelines that read and write live Oracle SCM in Python with petl and the CData Connect AI Python SDK.
-
Connect to Anaplan Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Anaplan and the SQL Gateway to access Anaplan from Google Apps Script.
-
Use the CData Software ODBC Driver for Quaderno in MicroStrategy
Connect to Quaderno in MicroStrategy Developer using the CData Software ODBC Driver for Quaderno.
-
Natively Connect to Google Ad Manager Data in PHP
The CData ODBC driver for Google Ad Manager enables you to create PHP applications with connectivity to Google Ad Manager. Leverage the native support for ODBC in PHP.
-
Build MVC Applications with Connectivity to Adobe Experience Manager Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Adobe Experience Manager from an ASP.NET MVC application.
-
LinkedIn Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on LinkedIn facts in real time.
-
Connect to Klaviyo from a Connection Pool in WebLogic
Use the CData JDBC Driver for Klaviyo to connect to Klaviyo from Web applications running on WebLogic.
-
Building Dynamic Web Pages with Slack Data Using AngularJS
Create single-page applications with live connectivity to Slack using the CData API Server.
-
Access Wistia Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Wistia from HeidiSQL.
-
Natively Connect to ChartMogul Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to ChartMogul. Leverage the native support for ODBC in PHP.
-
Automate CSV Data Replication to SAP HANA
Use CData Sync to customize and automate CSV/TSV Files replication to SAP HANA.
-
Visualize JobNimbus Data in Tableau
The CData ODBC driver for JobNimbus enables you integrate JobNimbus into Tableau dashboards.
-
Write a Simple Go Application to work with Reply.io Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Reply.io.
-
How to Easily Query SAS Data Sets Data in OpenOffice Base
Connect to SAS Data Sets data in OpenOffice Base using the CData ODBC Driver for SAS Data Sets and generate reports with live data insights.
-
Connect and Visualize Live Salesforce Pardot Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Salesforce Pardot into the Databricks platform and create visualization dashboards with real-time Salesforce Pardot.
-
Sage Cloud Accounting Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Sage Cloud Accounting facts in real time.
-
Integrate with Act CRM Data in JReport Designer
Create charts and reports based on Act CRM in JReport Designer.
-
Connect to Reckon Data in Jaspersoft Studio
Execute SQL to remote Reckon in Jaspersoft Studio.
-
Visualize Live HCL Domino Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live HCL Domino using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to connect SharePoint with Microsoft Ads Data through external lists
Provide Microsoft Ads to SharePoint users as an external list.
-
Create SAS Data Sets Dataflows on PowerBI.com
Connect to the CData Power BI Connector for SAS Data Sets from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to Visualize Google Forms Data in Python with pandas
Use pandas and other modules to analyze and visualize live Google Forms in Python.
-
Connect to Airtable Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Airtable Data and connect to Airtable in Akorbi Digital RunMyProcess.
-
How to Query Live YouTube Analytics Data in Perplexity MacOS Desktop
Connect to and query live YouTube Analytics Data in Perplexity Desktop using CData MCP Server.
-
How to Import Data from Oracle HCM Cloud into Google Sheets
Import Oracle HCM Cloud into a Google spreadsheet that is automatically refreshed.
-
Access Live Freshteam Data in Coginiti Pro
Connect to and query live Freshteam from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Provide OData Services of LinkedIn Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for LinkedIn by developing a WCF Service Application.
-
How to connect SharePoint with Avro Data through external lists
Provide Apache Avro to SharePoint users as an external list.
-
Access Live RabbitMQ Data in AWS Lambda (with IntelliJ IDEA)
Connect to live RabbitMQ in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Use ChatGPT to Talk to Your Salesforce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Salesforce & Force.com for you.
-
Integrate with Sentry Data in JReport Designer
Create charts and reports based on Sentry in JReport Designer.
-
How to Connect to Live HubSpot Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live HubSpot securely in real time.
-
Edit and Search Microsoft OneDrive External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Microsoft OneDrive to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Microsoft OneDrive objects that you can access from apps and the dashboard.
-
Connect to Snapchat Ads Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Snapchat Ads Data and connect to Snapchat Ads in Akorbi Digital RunMyProcess.
-
Use Dash to Build Web Apps on GitLab Data via CData Connect AI
Build interactive Dash web apps on live GitLab using pandas and the CData Connect AI Python SDK.
-
Integrating Claude Code CLI with Procore 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.
-
Create Dynamic Nethunt Grids Using the Infragistics XamDataGrid
Learn how you can connect Nethunt to Infragistics XamDataGrid to build dynamic grids.
-
How to load Salesforce Pardot data into Elasticsearch via Logstash
Introducing a simple method to load Salesforce Pardot data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Query Teradata Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Teradata from Node.js.
-
Getting Started with the CData Power BI Connector for Customer.io
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Building Dynamic Web Pages with Impala Data Using AngularJS
Create single-page applications with live connectivity to Impala using the CData API Server.
-
Query PabblySubscriptions Data through ODBC in Node.js
Use node-odbc to execute SQL queries against PabblySubscriptions from Node.js.
-
Operational Reporting on Bullhorn CRM Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Bullhorn CRM.
-
Operational Reporting on Mailjet Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Mailjet.
-
Working with Facebook Ads Data in LINQPad
Execute LINQ queries to Facebook Ads in LINQPad.
-
Create SSAS Tabular Models from Salesforce Data 360 Data
How to build a SQL Server Analysis Service Tabular Model from Salesforce Data 360 using CData drivers.
-
Use the CData Software ODBC Driver for Everhour in SAS for Real-Time Reporting and Analytics
Connect to real-time Everhour in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Everhour.
-
Connect to Front Data from PowerBuilder via ADO.NET
This article demonstrates how to access Front from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Visualize Samanage Data in Tableau
The CData ODBC driver for Samanage enables you integrate Samanage into Tableau dashboards.
-
Use the CData Software JDBC Driver for SendGrid in MicroStrategy Desktop
Connect to SendGrid in MicroStrategy Desktop using the CData Software JDBC Driver for SendGrid.
-
Access Dotmailer 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 Dotmailer.
-
Query Google Tasks Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Google Tasks from Node.js.
-
Create Supabase Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Supabase from PowerBI.com to create Power BI Dataflows with real-time data.
-
Bridge Vercel Connectivity with Apache NiFi
Access and process Vercel in Apache NiFi using the CData JDBC Driver.
-
How to Seamlessly Import Aha! Data into IBM SPSS Modeler
Integrate Aha! data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Integrate ServiceNow with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate ServiceNow with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to ServiceNow.
-
Integrating CapsuleCRM Data in Talend Cloud Data Management Platform
Connect CapsuleCRM Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Import Real-Time Webex Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Webex in ColdFusion.
-
Visualize Mocean Data in Sisense
Create an ElastiCube in Sisense app with access to Mocean.
-
Create Power BI Reports on Real-Time Xero Data
Use the CData ODBC Driver for Xero to visualize Xero Accounting in Power BI Desktop.
-
Work with GetResponse Data in FoxPro
Load GetResponse into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrate Instagram Data in Pentaho Data Integration
Build ETL pipelines based on Instagram in the Pentaho Data Integration tool.
-
Connect to Azure Data Lake Storage Data from PowerBuilder via JDBC
This article demonstrates how to access Azure Data Lake Storage from PowerBuilder using the Azure Data Lake Storage JDBC Driver.
-
Integrating OpenCode Terminal with Google Sheets 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.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Oracle Database using the Model Context Protocol.
-
Connect to Amazon DynamoDB Data in ACL Analytics
Connect to Amazon DynamoDB via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Amazon DynamoDB.