CData Software - Knowledge Base
Recent Articles
-
Access Live ConvertAPI Data in Coginiti Pro
Connect to and query live ConvertAPI from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
DataBind Controls to Klaviyo Data in Delphi
DataBind to Klaviyo in Delphi with standard data access components and controls.
-
Integrating Antigravity CLI with Campaigner via CData CLI
Connect Campaigner to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Automated Continuous Dynamics NAV Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Microsoft Dynamics NAV replication to OneLake in Microsoft Fabric.
-
Build Charts with Oracle Service Cloud Data in Clear Analytics
Create dynamic charts and perform analytics based on Oracle Service Cloud in Clear Analytics.
-
Connect to Facebook Data in RazorSQL
Connect to Facebook from wizards and query Facebook from the GUI in the RazorSQL database management tool.
-
Connect PivotalTracker to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect PivotalTracker with IBM WebSphere for seamless data integration and connectivity.
-
Use the CData SSIS Components to Insert New or Update Existing CouchDB Records from SQL Server
Easily push SQL Server data to CouchDB using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into CouchDB or update existing records with data from a SQL Server database.
-
How to Access Live Stack Exchange Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Stack Exchange enables you to integrate Stack Exchange into workflows built using Microsoft Power Automate Desktop.
-
Connect to PolarTeamPro Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time PolarTeamPro using standard SQL.
-
Build Access-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Access to explore live Access Data in Claude Code to assist with building Access-powered applications.
-
Create Dashboards and Visualize Live Google Ads Data in Geckoboard
Use CData Connect AI to connect to live Google Ads and create dashboards for real-time monitoring and visualization in Geckoboard.
-
How to Design Dynamics 365 Business Central Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Dynamics 365 Business Central from mobile and tablet Power Apps.
-
Integrate with BigQuery Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Google BigQuery in SnapLogic.
-
How to Access Freshsales Data Using Entity Framework
This article shows how to access Freshsales using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Build Oracle Sales-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Oracle Sales to explore live Oracle Sales Data in Claude Code to assist with building Oracle Sales-powered applications.
-
Getting Started with the CData SSIS Components for REST
Complete guide to installing, licensing, and connecting with the CData SSIS Components for REST.
-
Automated Continuous QuickBooks Online Replication to MySQL
Use CData Sync for automated, continuous, customizable QuickBooks Online replication to MySQL.
-
Build a Simple VCL Application for Freshservice Data
How to build a simple VCL Application to view Freshservice in RAD Studio using the CData ODBC Driver for Freshservice.
-
Build Apps with Live QuickBooks Time Data Using the Low-Code Development Platform of Mendix
Connect QuickBooks Time with Mendix to build apps using the CData JDBC Driver for QuickBooks Time.
-
Connect to ChartMogul from a Connection Pool in WebLogic
Use the CData JDBC Driver for ChartMogul to connect to ChartMogul from Web applications running on WebLogic.
-
Automated Continuous Oracle Service Cloud Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Oracle Service Cloud replication to IBM DB2.
-
Connect to TigerGraph Data in Aqua Data Studio
Access TigerGraph from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Edit and Search QuickBooks Time External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of QuickBooks Time to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create QuickBooks Time objects that you can access from apps and the dashboard.
-
Connect to QuickBooks Time Data from AWS Glue
Use CData Connect AI to gain access to live QuickBooks Time from your AWS Glue jobs.
-
Analyze Spotify Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Spotify in Microsoft R Open.
-
Automated Continuous Marketo Replication to Vertica
Use CData Sync for automated, continuous, customizable Marketo replication to Vertica.
-
Create FHIR-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to FHIR Data from OutSystems and build custom enterprise apps using live FHIR.
-
Work with SAP Data in FoxPro
Load SAP ERP/NetWeaver into a FoxPro database. This article includes full code and a walk-through of the process.
-
Query SuiteCRM Data as a MySQL Database in Node.js
Execute MySQL queries against SuiteCRM from Node.js.
-
Import Odoo Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Odoo Data and provide access to live Odoo ERP for custom reports in the Power BI Service.
-
Build SuiteCRM-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for SuiteCRM to explore live SuiteCRM Data in Cursor to assist with building SuiteCRM-powered applications.
-
Write a Simple Go Application to work with MessageBird Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to MessageBird.
-
How to publish and share SparkPost Data dashboards with Tableau Server
The CData ODBC driver for SparkPost enables you integrate SparkPost into Tableau dashboards.
-
Visualize Live REST Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live REST.
-
Migrating data from Teamgate to Snowflake using CData SSIS Components.
Easily push Teamgate to Snowflake using the CData SSIS Tasks for Teamgate and Snowflake.
-
Getting Started with the CData JDBC Driver for DocuSign
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for DocuSign.
-
Integrate Airtable with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Airtable with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Airtable.
-
Edit and Search SQL Server External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Microsoft SQL Server to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create SQL Server objects that you can access from apps and the dashboard.
-
Connect to Elasticsearch Data in Claris FileMaker Pro
Use the CData ODBC Driver for Elasticsearch in FileMaker Pro to connect to Elasticsearch and work with Elasticsearch in your FileMaker applications.
-
Build Zoho Books-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Zoho Books.
-
Process & Analyze Active Directory Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Active Directory Data.
-
Build FreshBooks-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live FreshBooks and build FreshBooks-connected web apps with Axios.
-
How to Seamlessly Import Square Data into IBM SPSS Modeler
Integrate Square data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build Data Flows from Rebilly to SQL Server using SSIS
Easily back up Rebilly to SQL Server using the SSIS components for Rebilly.
-
How to Connect to Oracle SCM Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Oracle SCM. Leverage the pyodbc module for ODBC in Python.
-
DataBind Charts to Coinbase Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Coinbase 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.
-
Viewing Facebook Data in RAD Studio Data Explorer
How to view Facebook in RAD Studio Data Explorer using the CData ODBC Driver for Facebook.
-
Automated Continuous HubDB Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable HubDB replication to Amazon Redshift.
-
How to Work with Zoho Creator Data in ETL Validator JDBC
Connect to Zoho Creator from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrating OpenCode Terminal with Paylocity 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.
-
Excel Spreadsheet Automation on MailChimp Data with the QUERY Formula
Pull data from MailChimp, automate spreadsheets, and more with the QUERY formula.
-
Publish Reports with Confluence Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Atlassian Confluence.
-
How to Work with YouTube Analytics Data in ETL Validator JDBC
Connect to YouTube Analytics from ETL Validator jobs using the CData Software JDBC Driver.
-
Bidirectional Access to Instantly Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Instantly in Filemaker Pro for Mac or Windows.
-
Create Power BI Reports on Real-Time Salesforce Data
Use the CData ODBC Driver for Salesforce to visualize Salesforce & Force.com in Power BI Desktop.
-
Analyze Trello Data in Cognos Analytics
Use CData Connect AI to connect to Trello Data from Cognos Analytics and analyze live Trello.
-
How to load Avaza data into Elasticsearch via Logstash
Introducing a simple method to load Avaza data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Create Informatica Mappings From/To an ODBC Data Source for Adobe Commerce
Create an ODBC connection to Adobe Commerce in Informatica and browse and transfer Adobe Commerce.
-
Use Databricks Agent Bricks to Talk to Your PayPal Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your PayPal for you.
-
Access Live iContact Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate iContact into the statistical analysis tools available in SAS JMP. This article shows how to use iContact in the Graph Builder and Query Builder.
-
Integrate ClickTime Data in Pentaho Data Integration
Build ETL pipelines based on ClickTime in the Pentaho Data Integration tool.
-
How to import SAP SuccessFactors Data into Apache Solr
Use the CData Software JDBC Driver for SAP SuccessFactors in Data Import Handler and create an automated import of SAP SuccessFactors to Apache Solr Enterprise Search platform.
-
Connect to Templated Data from PowerBuilder via JDBC
This article demonstrates how to access Templated from PowerBuilder using the Templated JDBC Driver.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Google Cloud Storage within intelligent workflows.
-
Query Opsgenie Data in ColdFusion
Write standard ColdFusion data access code to connect to Opsgenie.
-
Build a PostgreSQL Interface for ConvertAPI Data using the CData JDBC Driver
Use the Remoting features of the ConvertAPI JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Work with MongoDB Data in ETL Validator JDBC
Connect to MongoDB from ETL Validator jobs using the CData Software JDBC Driver.
-
Using the CData Software ODBC Driver for Active Directory in PyCharm
Connect to Active Directory as an ODBC data source in PyCharm using the CData Software ODBC Driver for Active Directory.
-
Import Wave Financial Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Wave Financial. In this article, you will use the OData format to import Wave Financial into Microsoft Power Query.
-
Prepare, Blend, and Analyze Splunk Data in Alteryx Designer (Connect AI)
Build workflows to access live Splunk for self-service data analytics.
-
Connect to ZohoInvoice Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for ZohoInvoice to connect to ZohoInvoice and execute queries in PowerBuilder.
-
A PostgreSQL Interface for ZohoInvoice Data using the CData ODBC Driver
Use the SQL Gateway and ZohoInvoice ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to Seamlessly Import Monday.com Data into IBM SPSS Modeler
Integrate Monday.com data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
DataBind Charts to Square Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Square 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.
-
Access FHIR Data from MySQL in PHP
Connect to FHIR through the standard MySQL libraries in PHP.
-
Create Data Visualizations Based On Smartsheet Data in Mode
Use CData Connect AI to connect to Smartsheet Data from Mode and build visualizations using live
-
Connect to Azure Data Lake Storage Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Azure Data Lake Storage using standard SQL.
-
Connect to Short.io Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Short.io as an External Source in Dremio.
-
How to work with Lakebase Data in Apache Spark using SQL
Access and process Lakebase Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to Real-Time Sugar CRM Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Sugar CRM and Dataflow to import and use Sugar CRM in Power Apps.
-
Analyze Freshteam Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Freshteam with the CData JDBC Driver for Freshteam.
-
Use the CData SSIS Components to Insert New or Update Existing SAP Concur Records from SQL Server
Easily push SQL Server data to SAP Concur using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into SAP Concur or update existing records with data from a SQL Server database.
-
Integrating LangChain with Box Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Box within automated workflows.
-
Getting Started with the CData ADO.NET Provider for Instagram
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Instagram.
-
Analyze ConvertAPI Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze ConvertAPI with the CData JDBC Driver for ConvertAPI.
-
Automate Paddle Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Paddle from PowerShell? This article demonstrates how to utilize the Paddle Cmdlets for tasks like connecting to Paddle, automating operations, downloading data, and more.
-
Build Xero-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Xero to explore live Xero Data in Gemini Code Assist to assist with building Xero-powered applications.
-
How to Query Live Presto Data in Claude Desktop
Connect to and query live Presto Data in Claude Desktop using CData MCP Server.
-
How to connect to xBase Data with Squirrel SQL client
Connect to xBase and execute queries in the Squirrel SQL Client.
-
How to Connect DBeaver to Microsoft OneDrive via a JDBC Driver
Manage Microsoft OneDrive with visual tools in DBeaver like the query browser.
-
Automated Continuous Tanda Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Tanda replication to Amazon Redshift.
-
Access Live Customer.io Data in Coginiti Pro
Connect to and query live Customer.io from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Use the CData Software JDBC Driver for Dotmailer in MicroStrategy
Connect to Dotmailer in MicroStrategy Developer using the CData Software JDBC Driver for Dotmailer.
-
Replicate SAP Hybris C4C Data to Multiple Databases via the CData Sync CLI
Replicate SAP Hybris C4C to disparate databases with a single configuration.
-
Create Dynamics 365-Connected Applications in Appsmith
Connect to Dynamics 365 Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Microsoft Dynamics 365.
-
Build Charts with Klipfolio Data in Clear Analytics
Create dynamic charts and perform analytics based on Klipfolio in Clear Analytics.
-
Create Aircall Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Aircall from PowerBI.com to create Power BI Dataflows with real-time data.
-
Automate TaxJar Data Replication to Azure Synapse
Use CData Sync to customize and automate TaxJar replication to Azure Synapse.
-
How to Work with Stripe Data in ETL Validator JDBC
Connect to Stripe from ETL Validator jobs using the CData Software JDBC Driver.