CData Software - Knowledge Base
Recent Articles
-
Integrate Avalara AvaTax Data into Power Automate Desktop using CData Connect
CData Connect for Avalara AvaTax Data enables you to integrate Avalara AvaTax into workflows built using Microsoft Power Automate Desktop.
-
How to integrate Metabase with Dynamics CRM Data
Use CData Connect AI to connect to live Microsoft Dynamics CRM and create an interactive dashboard in Metabase from Microsoft Dynamics CRM.
-
Import Real-Time AfterShip Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use AfterShip in ColdFusion.
-
Publish Crystal Reports on ElevenLabs Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date ElevenLabs.
-
A PostgreSQL Interface for JSON Services using the CData ODBC Driver
Use the SQL Gateway and JSON ODBC Driver to create a PostgreSQL entry-point for data access.
-
Query Google Contacts Data as a SQL Server Database in Node.js
Execute SQL Server queries against Google Contacts from Node.js.
-
Integrate Live SAP SuccessFactors LMS Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live SAP SuccessFactors LMS to Blue Prism using the CData ODBC Driver for SAP SuccessFactors LMS to create automated workflows for repetitive business tasks.
-
How to Build an ETL App for Salesforce Pardot Data in Python with CData
Create ETL applications and real-time data pipelines for Salesforce Pardot in Python with petl.
-
Integrating Reckon Accounts Hosted Data in Talend Cloud Data Management Platform
Connect Reckon Accounts Hosted Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Reckon Accounts Hosted.
-
Build a Singer.io Tap for SAP Netweaver Gateway With the CData Python Connector
Learn how to easily build a Singer.io Tap for live SAP Netweaver Gateway data using
-
Automate Zoho CRM Data Replication to Couchbase
Use CData Sync to Customize and automate Zoho CRM replication to Couchbase.
-
Integrate GraphQL with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate GraphQL with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to GraphQL.
-
Connect to Smartsheet Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Smartsheet in the Denodo Virtual DataPort Administrator.
-
Access Live Microsoft Planner Data in AWS Lambda
Connect to live Microsoft Planner in AWS Lambda using the CData JDBC Driver.
-
Connect to Recurly Data from PowerBuilder via ADO.NET
This article demonstrates how to access Recurly from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Configure the CData JDBC Driver for Sage 200 in a Connection Pool in Tomcat
Connect to Sage 200 from a connection pool in Tomcat.
-
Use Biml to Build SSIS Tasks to Replicate MessageBird Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate MessageBird to SQL Server.
-
A PostgreSQL Interface for IBM Cloud Object Storage Data using the CData ODBC Driver
Use the SQL Gateway and IBM Cloud Object Storage ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Guru Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Guru as an External Source in Dremio.
-
Automated Continuous ZohoDesk Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable ZohoDesk replication to delimited files (CSV/TSV).
-
Integrate Cursor with Live SAP BusinessObjects BI Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live SAP BusinessObjects BI from within the editor.
-
Automated Continuous Front Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Front replication to Apache Kafka.
-
Connect SQL Server to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Microsoft SQL Server using the CData Python MCP Server.
-
Build NetSuite-Connected Apps in Choreo
Use CData Connect AI to connect to NetSuite Data from Choreo and build custom apps using live NetSuite CRM & ERP.
-
How to Access Avalara AvaTax Data Using Entity Framework
This article shows how to access Avalara AvaTax using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to Monday.com Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Monday.com in the Denodo Virtual DataPort Administrator.
-
Integrating GitHub Copilot CLI with NASA 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 an SAP BusinessObjects Universe on the CData ODBC Driver for Browserless
Provide connectivity to Browserless through an SAP BusinessObjects universe.
-
Connect to Amazon S3 Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Amazon S3 from Filemaker Pro on Mac.
-
DataBind Controls to Supabase Data in Delphi
DataBind to Supabase in Delphi with standard data access components and controls.
-
How to Use a Microsoft Access Database to Update Zoho CRM Data in Real Time
Update Zoho CRM data by creating a linked table in Microsoft Access with the CData Zoho CRM ODBC Driver.
-
Use Databricks Agent Bricks to Talk to Your Google Directory Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Google Directory for you.
-
Build Superchat-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Superchat.
-
DataBind Controls to Sage Cloud Accounting Data in C++Builder
DataBind to Sage Business Cloud Accounting in C++Builder with standard components and controls.
-
Back Up SQL Analysis Services to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for SQL Analysis Services. In this article, we will employ an SSIS workflow to populate a database with SQL Analysis Services data.
-
Connect to Dynamics NAV Data in HULFT Integrate
Connect to Dynamics NAV as a JDBC data source in HULFT Integrate
-
Visualize Live Spark Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Apache Spark SQL using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build Data Flows from SQL Server to Slack through SSIS
Easily push SQL Server data to Slack using the CData SSIS Tasks for Slack.
-
How to Connect the Power BI Service to SendInBlue: Complete Guide
Connect to the CData Software Power BI Connector for SendInBlue from PowerBI.com to provide real-time SendInBlue across the organization.
-
Use the CData ODBC Driver for LeadDesk in Microsoft Power Query
You can use the CData LeadDesk ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import LeadDesk into Microsoft Power Query.
-
How to Visualize Google Analytics Data in Python with pandas
Use pandas and other modules to analyze and visualize live Google Analytics in Python.
-
Natively Connect to Apify Data in PHP
The CData ODBC driver for Apify enables you to create PHP applications with connectivity to Apify. Leverage the native support for ODBC in PHP.
-
Connect LinkedIn Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your LinkedIn using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to Connect to SendPulse Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to SendPulse. Leverage the pyodbc module for ODBC in Python.
-
Import and Visualize Toggl Data in Power View
Create data visualizations based on Toggl in Excel.
-
Stream Ontraport Data into Apache Kafka Topics
Access and stream Ontraport in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Object-Relational Mapping (ORM) with Certinia 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 Certinia into a Java-based ORM framework, Hibernate.
-
How to connect to Simplesat Data from Spring Boot
Connect to Simplesat in a Spring Boot Application using the CData API Driver for JDBC
-
Use the CData ODBC Driver for ZohoSubscriptions from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for ZohoSubscriptions to connect to ZohoSubscriptions from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring ZohoSubscriptions in Excel.
-
Create Dashboards and Visualize Live Google Calendar Data in Geckoboard
Use CData Connect AI to connect to live Google Calendar and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Connect to Freshdesk Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Freshdesk to connect to Freshdesk and execute queries in PowerBuilder.
-
Connect to Snapchat Ads Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Snapchat Ads Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Build Monday.com-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Monday.com and build Monday.com-connected web apps with Axios.
-
Integrate MarkLogic with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate MarkLogic with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to MarkLogic.
-
Automated Continuous ConvertKit Replication to IBM DB2
Use CData Sync for automated, continuous, customizable ConvertKit replication to IBM DB2.
-
Bidirectional Access to OneNote Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Microsoft OneNote in Filemaker Pro for Mac or Windows.
-
Build Dashboards with LinkedIn Ads Data in DBxtra
Create dynamic dashboards and perform analytics based on LinkedIn Ads in DBxtra.
-
DataBind Controls to Cloudflare Data in C++Builder
DataBind to Cloudflare in C++Builder with standard components and controls.
-
Use JayDeBeApi to access YouTube Analytics Data in Python
Use standard Python scripting and the development environment of your choice to access live YouTube Analytics.
-
Connect to LDAP Objects in HULFT Integrate
Connect to LDAP as a JDBC data source in HULFT Integrate
-
Visualize Slack Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Slack.
-
Automated Continuous Google Cloud Storage Replication to MySQL
Use CData Sync for automated, continuous, customizable Google Cloud Storage replication to MySQL.
-
How to import FormSite Data into Apache Solr
Use the CData Software JDBC Driver for FormSite in Data Import Handler and create an automated import of FormSite to Apache Solr Enterprise Search platform.
-
DataBind Controls to ScrapingBee Data in Delphi
DataBind to ScrapingBee in Delphi with standard data access components and controls.
-
Integrate with Amazon DynamoDB Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Amazon DynamoDB to a JSON file on disk.
-
Visualize PagerDuty Data in Sisense
Create an ElastiCube in Sisense app with access to PagerDuty.
-
Visualize Live ADP Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live ADP.
-
Connect to LightSpeedRetail Data in JRuby
Create a simple JRuby app with access to live LightSpeedRetail.
-
Connect to Zoho Creator Data in Claris FileMaker Pro
Use the CData ODBC Driver for Zoho Creator in FileMaker Pro to connect to Zoho Creator and work with Zoho Creator in your FileMaker applications.
-
Access Mouseflow Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Mouseflow from HeidiSQL.
-
Automated Continuous Paylocity Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Paylocity replication to AlloyDB.
-
How to Query Live MYOB AccountRight Data in Perplexity MacOS Desktop
Connect to and query live MYOB AccountRight Data in Perplexity Desktop using CData MCP Server.
-
Build Google Spanner Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Google Spanner and build visualizations in Tableau.
-
Import Real-Time Elasticsearch Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Elasticsearch in ColdFusion.
-
Access Live Close Data in AWS Lambda
Connect to live Close in AWS Lambda using the CData JDBC Driver.
-
Feed Freshservice Data into FineReport
How to set Freshservice as a JDBC data source in FineReport.
-
Connect to MessageBird Data in DBArtisan
Use wizards in DBArtisan to configure MessageBird as a data source.
-
Build Data Flows from SQL Server to Excel through SSIS
Easily push SQL Server data to Excel using the CData SSIS Tasks for Excel.
-
Integrate Live LightSpeedRetail Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live LightSpeedRetail to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Import Real-Time Timely Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Timely in ColdFusion.
-
Replicate Oracle Financials Cloud Data to Multiple Databases via the CData Sync CLI
Replicate Oracle Financials Cloud to disparate databases with a single configuration.
-
Query SharePoint Excel Services Data in ColdFusion
Write standard ColdFusion data access code to connect to SharePoint Excel Services.
-
Query, Visualize, and Share live HBase Data in Redash
Use CData Connect AI to connect to live Apache HBase in Redash for querying, visualizing, and sharing.
-
Build Google Analytics Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Google Analytics and build visualizations in Tableau Cloud.
-
Connect to MariaDB Data from AWS Glue
Use CData Connect AI to gain access to live MariaDB from your AWS Glue jobs.
-
Use the CData Software ODBC Driver for Nethunt in MicroStrategy
Connect to Nethunt in MicroStrategy Developer using the CData Software ODBC Driver for Nethunt.
-
Bidirectional Access to Zuora Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Zuora in Filemaker Pro for Mac or Windows.
-
How to load MailChimp data into Elasticsearch via Logstash
Introducing a simple method to load MailChimp data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to Connect DBeaver to PhantomBuster via a JDBC Driver
Manage PhantomBuster with visual tools in DBeaver like the query browser.
-
Query Jumpseller Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Jumpseller from Node.js.
-
Connect to Freshservice Data in RazorSQL
Connect to Freshservice from wizards and query Freshservice from the GUI in the RazorSQL database management tool.
-
Integrating GitHub Copilot CLI with Bitbucket 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 Controls to SharePoint Data in Delphi
DataBind to Microsoft SharePoint in Delphi with standard data access components and controls.
-
Consume SAP Fieldglass OData Feeds in SAP Lumira
Use the API Server to create data visualizations on SAP Fieldglass feeds that reflect any changes in SAP Lumira.
-
How to import PingOne Data into Apache Solr
Use the CData Software JDBC Driver for PingOne in Data Import Handler and create an automated import of PingOne to Apache Solr Enterprise Search platform.
-
Publish Crystal Reports on HubDB Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date HubDB.
-
Integrate SendPulse with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate SendPulse with External Services.
-
Create Reports with Zoom Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Zoom.
-
Build a Simple VCL Application for Suadeo Data
How to build a simple VCL Application to view Suadeo in RAD Studio using the CData ODBC Driver for Suadeo.
-
Create Retently Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Retently data access from reports, embedded analytics, and more.