CData Software - Knowledge Base
Recent Articles
-
Build AlloyDB-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for AlloyDB Data and create custom apps in Mendix.
-
Access Google Forms 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 Google Forms.
-
Connect to WordPress Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for WordPress.
-
Stream Sage Cloud Accounting Data into Apache Kafka Topics
Access and stream Sage Business Cloud Accounting in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Automated Continuous Access Replication to Databricks
Use CData Sync for automated, continuous, customizable Access replication to Databricks.
-
Automated Continuous Sage 300 Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Sage 300 replication to IBM DB2.
-
Integrate Theia IDE with Live SAP HANA Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Create SSAS Tabular Models from Box Data
How to build a SQL Server Analysis Service Tabular Model from Box using CData drivers.
-
How to connect to Impala Data from IntelliJ
Integrate connectivity to Apache Impala with wizards in IntelliJ.
-
Automated Continuous SAP Hybris C4C Replication to AlloyDB
Use CData Sync for automated, continuous, customizable SAP Hybris C4C replication to AlloyDB.
-
Query EnterpriseDB Data as a SQL Server Database in Node.js
Execute SQL Server queries against EnterpriseDB from Node.js.
-
Query Google Drive Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Google Drive from Node.js.
-
Integrating Antigravity CLI with IBM Cloudant via CData CLI
Connect IBM Cloudant to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrating LangGraph with Presto Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Presto within automated workflows.
-
Replicate Multiple Bugsnag Accounts
Replicate multiple Bugsnag accounts to one or many databases.
-
Natively Connect to Eventbrite Data in PHP
The CData ODBC driver for Eventbrite enables you to create PHP applications with connectivity to Eventbrite. Leverage the native support for ODBC in PHP.
-
Connect to and Visualize Live HBase Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Apache HBase.
-
Moving Data from BigQuery to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live BigQuery data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Stream JDBC-ODBC Bridge Data into Apache Kafka Topics
Access and stream JDBC-ODBC Bridge in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrate Live SAP Fieldglass Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to SAP Fieldglass from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live SAP Fieldglass.
-
Work with Jodoo Data in FoxPro
Load Jodoo into a FoxPro database. This article includes full code and a walk-through of the process.
-
Choosing the Best Method to Connect Sage 300 to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Sage 300 from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Build MVC Applications with Connectivity to GitHub Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access GitHub from an ASP.NET MVC application.
-
Viewing JotForm Data in RAD Studio Data Explorer
How to view JotForm in RAD Studio Data Explorer using the CData ODBC Driver for JotForm.
-
How to Connect to Live Blackbaud FE NXT Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Blackbaud FE NXT for you.
-
Choosing the Best Method to Connect Shippo to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Shippo from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrating Claude Code CLI with Pingdom 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.
-
DataBind Charts to Google Cloud Storage Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Google Cloud Storage 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.
-
Automate Mode Data Replication to Couchbase
Use CData Sync to Customize and automate Mode replication to Couchbase.
-
Explore Geographical Relationships in HubDB Data with Power Map
Create data visualizations with HubDB in Power Map.
-
Excel Spreadsheet Automation on Oracle Financials Cloud Data with the QUERY Formula
Pull data from Oracle Financials Cloud, automate spreadsheets, and more with the QUERY formula.
-
How to connect and process Rebilly from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Rebilly.
-
Use JayDeBeApi to access LaunchDarkly Data in Python
Use standard Python scripting and the development environment of your choice to access live LaunchDarkly.
-
Publish Crystal Reports on Exa Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Exa.
-
Getting Started with the CData Power BI Connector for RSS
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for RSS.
-
Model Impala Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Impala, enabling the direct import of real-time Apache Impala.
-
Connect to Close Data from PowerBuilder via JDBC
This article demonstrates how to access Close from PowerBuilder using the Close JDBC Driver.
-
Replicate Parallel Data from PowerShell
Write a quick PowerShell script to query Parallel. Use connectivity to the live data to replicate Parallel to SQL Server.
-
Automated EnterpriseDB Data Replication to Teradata
Use CData Sync to Customize and automate EnterpriseDB replication to Teradata.
-
Create Reports from Sage Intacct Data in Looker Studio
Use CData Connect AI to gain access to live Sage Intacct and create custom reports in Looker Studio.
-
A PostgreSQL Interface for eBay Analytics Data (MySQL Remoting via JDBC)
Use the Remoting features of the eBay Analytics JDBC Driver to create a PostgreSQL entry-point for data access.
-
Analyze Google Campaign Manager 360 Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Google Campaign Manager 360 and visualize live Google Campaign Manager 360 in Infragistics Reveal.
-
Visualize Salesforce Data 360 Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Salesforce Data 360.
-
Create Informatica Mappings From/To an ODBC Data Source for Strava
Create an ODBC connection to Strava in Informatica and browse and transfer Strava.
-
Create Vault CRM Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Vault CRM data access from reports, embedded analytics, and more.
-
Consume Azure DevOps OData Feeds in PowerBuilder
This article demonstrates how to consume Azure DevOps as OData feeds from PowerBuilder using the API Server.
-
Visualize Zoom Data in Tableau
The CData ODBC driver for Zoom enables you integrate Zoom into Tableau dashboards.
-
Automated Continuous Oracle Sales Replication to Databricks
Use CData Sync for automated, continuous, customizable Oracle Sales replication to Databricks.
-
Visualize Live MySQL Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live MySQL into custom reports in Power BI.
-
Integrate Live Keap Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Keap to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Integrate with ZohoDesk Data in JReport Designer
Create charts and reports based on ZohoDesk in JReport Designer.
-
Back Up Microsoft Dataverse (CDS) to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Microsoft Dataverse. In this article, we will employ an SSIS workflow to populate a database with Microsoft Dataverse (CDS) data.
-
Work with Bitly Data in FoxPro
Load Bitly into a FoxPro database. This article includes full code and a walk-through of the process.
-
Automated Continuous Oracle Financials Cloud Replication to Vertica
Use CData Sync for automated, continuous, customizable Oracle Financials Cloud replication to Vertica.
-
Getting Started with the CData SSIS Components for ADP
Complete guide to installing, licensing, and connecting with the CData SSIS Components for ADP.
-
Model Dynamics 365 Business Central Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Dynamics 365 Business Central, enabling the direct import of real-time Dynamics 365 Business Central.
-
Use CData Connect AI to Access Dynamics 365 Business Central Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Dynamics 365 Business Central in the Power Pivot business intelligence tool.
-
Create Cloudflare Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Cloudflare data access from reports, embedded analytics, and more.
-
DataBind FreshBooks Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide FreshBooks to a chart.
-
Analyze QuickBooks Time Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze QuickBooks Time in Microsoft R Open.
-
Create Informatica Mappings From/To a JDBC Data Source for RSS
Create RSS data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connecting Agentforce with Hive Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Apache Hive for you.
-
Connect to Act CRM Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Act CRM and the Script function in FileMaker Pro to connect to Act CRM and work with Act CRM in your FileMaker application.
-
Analyze ElevenLabs Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze ElevenLabs with the CData JDBC Driver for ElevenLabs.
-
Access Typeform Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Typeform from your Oracle system.
-
Create Facebook Ads Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Facebook Ads data access from reports, embedded analytics, and more.
-
Integrating GitHub Copilot CLI with Pipeliner CRM 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.
-
Access Salesforce Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Salesforce & Force.com from HeidiSQL.
-
Connect to Live Freshservice Data in MicroStrategy through CData Connect AI
Create a live connection to Freshservice Data in CData Connect AI and connect to your Freshservice from MicroStrategy.
-
Integrate with Sybase IQ Data in JReport Designer
Create charts and reports based on Sybase IQ in JReport Designer.
-
Bidirectional Access to Mailgun Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Mailgun in Filemaker Pro for Mac or Windows.
-
Integrate Live BambooHR Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Connecting Moonlit Workflow with SAP ByDesign 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 SAP Business ByDesign in real time.
-
How to Visualize Zoho Creator Data in Python with pandas
Use pandas and other modules to analyze and visualize live Zoho Creator in Python.
-
Create SSAS Tabular Models from OnePageCrm Data
How to build a SQL Server Analysis Service Tabular Model from OnePageCrm using CData drivers.
-
Integrating LangGraph with MySQL Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on MySQL within automated workflows.
-
Integrate Mocean Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Mocean from Informatica Cloud.
-
Migrating data from Cosmos DB to Snowflake using CData SSIS Components.
Easily push Azure Cosmos DB to Snowflake using the CData SSIS Tasks for Cosmos DB and Snowflake.
-
How to connect PolyBase to Vercel
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Vercel.
-
Stream LinkedIn Data into Apache Kafka Topics
Access and stream LinkedIn in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Publish Reports with Redis Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Redis.
-
Build Visualizations of SAP HANA XS Advanced Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of SAP HANA XS Advanced in Birst.
-
Create Power BI Reports on Real-Time PostgreSQL Data
Use the CData ODBC Driver for PostgreSQL to visualize PostgreSQL in Power BI Desktop.
-
Connect to RSS Feeds in HULFT Integrate
Connect to RSS as a JDBC data source in HULFT Integrate
-
Create Reports with Bitbucket Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Bitbucket.
-
Build a Singer.io Tap for Aha! With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Aha! data using
-
Build Charts with Zoho Recruit Data in Clear Analytics
Create dynamic charts and perform analytics based on Zoho Recruit in Clear Analytics.
-
DataBind Charts to ActiveCampaign Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to ActiveCampaign 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.
-
Migrating data from Suadeo to Databricks using CData SSIS Components.
Easily push Suadeo to Databricks using the CData SSIS Tasks for Suadeo and Databricks.
-
Automate Smartsheet Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Smartsheet and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
How to work with Paylocity Data in Apache Spark using SQL
Access and process Paylocity Data in Apache Spark using the CData Software JDBC Driver.
-
Build Sybase-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Sybase Data and create custom apps in Mendix.
-
Integrate Cloudant Data into Power Automate Desktop using CData Connect
CData Connect for Cloudant Data enables you to integrate IBM Cloudant into workflows built using Microsoft Power Automate Desktop.
-
Connect to Elorus Data in Aqua Data Studio
Access Elorus from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Perplexity Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Perplexity facts in real time.
-
Use the CData ODBC Driver for Mistral AI in Microsoft Power Query
You can use the CData Mistral AI ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Mistral AI into Microsoft Power Query.
-
Automated Continuous ActiveCampaign Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable ActiveCampaign replication to Azure SQL Database.
-
Manage Oracle Eloqua Reporting Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Oracle Eloqua Reporting.
-
Process & Analyze Parallel Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Parallel Data.
-
Integrate Redshift Data in Pentaho Data Integration
Build ETL pipelines based on Amazon Redshift in the Pentaho Data Integration tool.