CData Software - Knowledge Base
Recent Articles
-
Getting Started with the CData JDBC Driver for Teamgate
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Teamgate.
-
Access Live Google Translate Data in Coginiti Pro
Connect to and query live Google Translate from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Visualize Live SAP SuccessFactors Data in the Power BI Service
Use CData Connect AI to connect to live SAP SuccessFactors and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Amplitude Data in Ruby
Connect to Amplitude in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Load Paylocity Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Paylocity to a database.
-
Natively Connect to xBase Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to xBase. Leverage the native support for ODBC in PHP.
-
Visualize Insightly Data in Tableau
The CData ODBC driver for Insightly enables you integrate Insightly into Tableau dashboards.
-
Import Real-Time CSV Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use CSV/TSV Files in ColdFusion.
-
Connect to Factorial Data from a Connection Pool in Jetty
The Factorial JDBC Driver supports connection pooling: This article shows how to connect faster to Factorial from Web apps in Jetty.
-
Connect Kintone to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Kintone using the CData Python MCP Server.
-
Use Biml to Build SSIS Tasks to Replicate Shortcut Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Shortcut to SQL Server.
-
Perform Batch Operations with Certinia Data in Apache NiFi
Connect to Certinia and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Connect to Google Spanner Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Google Spanner.
-
Integrate Cline with Live Vertica Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Vertica from within your IDE.
-
Access Sugar CRM 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 Sugar CRM.
-
Connect to Avalara AvaTax Data in Ruby
Connect to Avalara AvaTax in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to AlloyDB Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for AlloyDB to connect to Google AlloyDB and execute queries in PowerBuilder.
-
Connect to Recurly Data in Ruby
Connect to Recurly in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Visualize SAP Fieldglass Data in Tableau
The CData ODBC driver for SAP Fieldglass enables you integrate SAP Fieldglass into Tableau dashboards.
-
How to Connect to Live Epicor Kinetic Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Epicor Kinetic for you.
-
Integrate Real-Time Access to SFTP in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to SFTP in real time.
-
ETL Adobe Commerce in Oracle Data Integrator
This article shows how to transfer Adobe Commerce into a data warehouse using Oracle Data Integrator.
-
Create Reports from Zuora Data in Looker Studio
Use CData Connect AI to gain access to live Zuora and create custom reports in Looker Studio.
-
How to use SQLAlchemy ORM to access Webflow Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Webflow.
-
Automated Continuous Avalara AvaTax Replication to SingleStore
Use CData Sync for automated, continuous, customizable Avalara AvaTax replication to SingleStore.
-
Provide OData Services of Salesforce Data 360 Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Salesforce Data 360 by developing a WCF Service Application.
-
Migrating data from NASA to Databricks using CData SSIS Components.
Easily push NASA to Databricks using the CData SSIS Tasks for NASA and Databricks.
-
Analyze Twilio Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Twilio and visualize Twilio in SAP Analytics Cloud.
-
Analyze Access Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Microsoft Access in Microsoft R Open.
-
Import Real-Time Xero Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Xero Accounting in ColdFusion.
-
How to load Azure Analysis Services data into Elasticsearch via Logstash
Introducing a simple method to load Azure Analysis Services data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Query Harvest Data in ColdFusion
Write standard ColdFusion data access code to connect to Harvest.
-
Build Charts with Amplitude Data in Clear Analytics
Create dynamic charts and perform analytics based on Amplitude in Clear Analytics.
-
Automated Continuous Hubstaff Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Hubstaff replication to IBM DB2.
-
Integrating Claude Code CLI with Dynamics 365 Business Central 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.
-
Establish a Live Connection with Paymo Data using Tableau Bridge
The CData ODBC Driver for Paymo enables you to integrate live Paymo into Tableau Cloud dashboards using the Tableau Bridge.
-
How to create Delighted federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Delighted in MySQL .
-
How to Access ServiceNow Data Using Entity Framework
This article shows how to access ServiceNow using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Establish a Live Connection with Cohere Data using Tableau Bridge
The CData ODBC Driver for Cohere enables you to integrate live Cohere into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to Asana Data in CloverDX (formerly CloverETL)
Transfer Asana using the visual workflow in the CloverDX data integration tool.
-
EnterpriseDB Reporting in OBIEE with the EnterpriseDB JDBC Driver
Deploy the EnterpriseDB JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to Easily Query Datadog Data in OpenOffice Base
Connect to Datadog data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Getting Started with the CData ODBC Driver for Okta
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Okta.
-
Automated Continuous Square Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Square replication to Google BigQuery.
-
Building Dynamic Web Pages with Oracle Data Using AngularJS
Create single-page applications with live connectivity to Oracle using the CData API Server.
-
Integrate Square Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Square from Informatica Cloud.
-
Query SageHR Data as a MySQL Database in Node.js
Execute MySQL queries against SageHR from Node.js.
-
How to connect to Azure Analysis Services Data in DBVisualizer
Integrate Azure Analysis Services with visual data analysis tools and data connection wizards in DBVisualizer
-
Write a Simple Go Application to work with Mailgun Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Mailgun.
-
Extract, Transform, and Load Clio Data in Informatica PowerCenter
Create a simple Workflow for Clio in Informatica PowerCenter.
-
How to Query Bannerbear Data in MySQL Workbench
Execute MySQL queries against live Bannerbear from MySQL Workbench.
-
Build a PostgreSQL Interface for SurveyMonkey Data using the CData JDBC Driver
Use the Remoting features of the SurveyMonkey JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect and Query Live Google Search Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Google Search into Databricks
-
Oracle Financials Cloud Reporting in OBIEE with the Oracle Financials Cloud JDBC Driver
Deploy the Oracle Financials Cloud JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automated Continuous Chargebee Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Chargebee replication to Amazon Redshift.
-
Use the CData Software ODBC Driver for BigQuery in MicroStrategy Desktop
Connect to Google BigQuery in MicroStrategy Desktop using the CData Software ODBC Driver for BigQuery.
-
Access Act CRM Data from MySQL in Amazon QuickSight
Connect to Act CRM and build visualizations of Act CRM using a MySQL Connection in Amazon QuickSight.
-
ETL Jodoo in Oracle Data Integrator
This article shows how to transfer Jodoo into a data warehouse using Oracle Data Integrator.
-
Model, Search, and Visualize Live MailChimp Data in ThoughtSpot
Use CData Connect AI to connect to live MailChimp for modeling, searching, and visualizing.
-
Analyze Templated Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Templated from Power Pivot. You will use the Table Import Wizard to load Templated. You can visually build the import query or use any SQL supported by the driver.
-
How to connect to Dotmailer Data in DBVisualizer
Integrate Dotmailer with visual data analysis tools and data connection wizards in DBVisualizer
-
Establish a Live Connection with SFTP Data using Tableau Bridge
The CData ODBC Driver for SFTP enables you to integrate live SFTP into Tableau Cloud dashboards using the Tableau Bridge.
-
Use the CData Software JDBC Driver for SAP BusinessObjects BI in MicroStrategy Desktop
Connect to SAP BusinessObjects BI in MicroStrategy Desktop using the CData Software JDBC Driver for SAP BusinessObjects BI.
-
Connect to PabblySubscriptions Data in HULFT Integrate
Connect to PabblySubscriptions as a JDBC data source in HULFT Integrate
-
Connect to LinkedIn Data in DBeaver
Use the CData ODBC Driver to connect to LinkedIn in DBeaver.
-
Access SAP Hybris C4C Data from MySQL in PHP
Connect to SAP Hybris C4C through the standard MySQL libraries in PHP.
-
Establish a Live Connection with RabbitMQ Data using Tableau Bridge
The CData ODBC Driver for RabbitMQ enables you to integrate live RabbitMQ into Tableau Cloud dashboards using the Tableau Bridge.
-
Automated Continuous Azure Synapse Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Azure Synapse replication to Apache Cassandra.
-
Build a PostgreSQL Interface for Retently Data using the CData JDBC Driver
Use the Remoting features of the Retently JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to eBay Analytics in SpagoBI
Create reports featuring live eBay Analytics in SpagoBI Studio. Host eBay Analytics reports on SpagoBI Server.
-
Integrate OData Services in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live OData from Informatica Cloud.
-
How to connect and process LinkedIn from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live LinkedIn.
-
Build Apps with Live SAP SuccessFactors in Adalo using CData Connect AI
Use CData Connect AI to integrate live SAP SuccessFactors into the Adalo platform and build custom mobile and web applications with real-time SAP SuccessFactors.
-
How to create Visio diagrams from Salesforce Pardot Data
Automatically update Salesforce Pardot with the changes you make to Visio master shapes.
-
Easily Integrate CockroachDB Data in Lazarus Pascal IDE
Learn how to easily integrate live CockroachDB in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Access Cassandra Data from MySQL in Amazon QuickSight
Connect to Cassandra and build visualizations of Apache Cassandra using a MySQL Connection in Amazon QuickSight.
-
LINQ to eBay Analytics Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the eBay Analytics Data Provider.
-
How to Query Live NetSuite Data in Perplexity MacOS Desktop
Connect to and query live NetSuite Data in Perplexity Desktop using CData MCP Server.
-
Integrate with live Monday.com Data in Jitterbit
Use CData Connect AI to connect to and integrate live Monday.com in Jitterbit.
-
Automated Continuous Highrise Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Highrise replication to delimited files (CSV/TSV).
-
Integrating Antigravity CLI with Google Forms via CData CLI
Connect Google Forms to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Build Visualizations of Raisers Edge NXT Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Raisers Edge NXT in Birst.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed eBay Analytics to Power BI dashboards. Simply drag and drop eBay Analytics into data visuals on the Power BI canvas.
-
Connect and Query Live Google Directory Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Google Directory into Databricks
-
Access Live Snowflake Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Snowflake from your Google Sheets.
-
Moving Data from AdRoll to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live AdRoll data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Visualize AgileCRM Data in TIBCO Spotfire through ADO.NET
Integrate AgileCRM into dashboards in TIBCO Spotfire.
-
Analyze FreshBooks Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of FreshBooks and visualize live FreshBooks in Infragistics Reveal.
-
Connect to SAP ByDesign Data in ACL Analytics
Connect to SAP Business ByDesign via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to SAP Business ByDesign.
-
Access ZeroBounce 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 ZeroBounce.
-
Connect to MailChimp Data in Jaspersoft Studio
Execute SQL to remote MailChimp in Jaspersoft Studio.
-
How to connect and process ServiceNow from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live ServiceNow.
-
Process & Analyze Cassandra Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Cassandra Data.
-
Integrate LibreChat with Live Microsoft OneDrive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Microsoft OneDrive from within the chat interface.
-
Work with Twitter Ads Data in FoxPro
Load Twitter Ads into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to Real-Time ClickTime Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use ClickTime in Power Apps.
-
Connect to Wrike Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Wrike and the SQL Gateway to access Wrike from Google Apps Script.
-
Add SAP SuccessFactors Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for SAP SuccessFactors with the Informatica Enterprise Data Catalog to classify and organize data.
-
Create Microsoft Teams-Connected Nintex Workflows
Use CData Connect AI to connect to Microsoft Teams Data from Nintex Workflow Cloud and build custom workflows using live Microsoft Teams.
-
Build Apps with Live Asana in Adalo using CData Connect AI
Use CData Connect AI to integrate live Asana into the Adalo platform and build custom mobile and web applications with real-time Asana.