CData Software - Knowledge Base
Recent Articles
-
Connect to Couchbase from Asprova with CData Software ODBC Driver for Couchbase
This article shows how to connect faster to Couchbase data from Asprova.
-
Connecting Moonlit Workflow with Apollo 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 Apollo data in real time.
-
Connect OpenWeatherMap Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your OpenWeatherMap data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Automated Continuous Cassandra Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Cassandra replication to Amazon S3.
-
Import Real-Time Freshteam Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Freshteam data in ColdFusion.
-
Replicate Slack Data to Multiple Databases via the CData Sync CLI
Replicate Slack data to disparate databases with a single configuration.
-
Integrate with live FreshBooks Data in Jitterbit
Use CData Connect AI to connect to and integrate live FreshBooks data in Jitterbit.
-
Automated Continuous Avalara AvaTax Replication to SQLite
Use CData Sync for automated, continuous, customizable Avalara AvaTax replication to SQLite.
-
Access Facebook Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Facebook data from HeidiSQL.
-
Connect to MYOB AccountRight in SpagoBI
Create reports featuring live MYOB AccountRight data in SpagoBI Studio. Host MYOB AccountRight reports on SpagoBI Server.
-
Connect to Live GitLab Data in PostGresSQL Interface through CData Connect AI
Create a live connection to GitLab in CData Connect AI and connect to your GitLab data from PostgreSQL.
-
Access Live Acumatica Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Acumatica data into the statistical analysis tools available in SAS JMP. This article shows how to use Acumatica data in the Graph Builder and Query Builder.
-
Build Apps with Live SageHR Data Using the Low-Code Development Platform of Mendix
Connect SageHR data with Mendix to build apps using the CData API Driver for JDBC.
-
Integrate Deel with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Deel with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Deel data.
-
Configure the CData JDBC Driver for Insightly in a Connection Pool in Tomcat
Connect to Insightly data from a connection pool in Tomcat.
-
Connect to Couchbase Data from a Connection Pool in JBoss
Integrate Couchbase data into Java servlets: Use the Management Console in JBoss to install the Couchbase JDBC Driver.
-
Integrate with FreshBooks Data in JReport Designer
Create charts and reports based on FreshBooks data in JReport Designer.
-
Connect to Google Directory Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Google Directory as an External Source in Dremio.
-
Use Databricks Agent Bricks to Talk to Your Exa Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Exa data for you.
-
Moving Data from Onfleet to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Onfleet data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to integrate Azure Table with Apache Airflow
Access and process Azure Table data in Apache Airflow using the CData JDBC Driver.
-
Access Gumroad 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 Gumroad data.
-
How to Seamlessly Import Microsoft Teams Data into IBM SPSS Modeler
Integrate Microsoft Teams data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Automated Continuous Greenplum Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Greenplum replication to Amazon Redshift.
-
Build Data Flows from Dotmailer to SQL Server using SSIS
Easily back up Dotmailer data to SQL Server using the SSIS components for Dotmailer.
-
How to Visualize SAP Ariba Procurement Data in Python with pandas
Use pandas and other modules to analyze and visualize live SAP Ariba Procurement data in Python.
-
Automated Continuous Sentry Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Sentry replication to Apache Cassandra.
-
Use the CData ODBC Driver for Jira Assets from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Jira Assets to connect to Jira Assets data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Jira Assets data in Excel.
-
Build CouchDB-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to CouchDB data and build web apps with connectivity to live CouchDB data.
-
Integrating Gumloop with EnterpriseDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on EnterpriseDB data within automated workflows.
-
Connect to Dynamics CRM Data from Crystal Reports
Use CData Connect AI to connect to and report on live Dynamics CRM data from Crystal Reports.
-
How to connect to Egnyte Data from Spring Boot
Connect to Egnyte in a Spring Boot Application using the CData API Driver for JDBC
-
Build Data Flows from Lakebase to SQL Server using SSIS
Easily back up Lakebase data to SQL Server using the SSIS components for Lakebase.
-
Edit and Search External Microsoft Planner Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Microsoft Planner data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Microsoft Planner Data objects that you can access from apps and the dashboard.
-
Replicate Wistia Data to Multiple Databases via the CData Sync CLI
Replicate Wistia data to disparate databases with a single configuration.
-
Integrate Dify with Live Discord Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Discord data.
-
Getting Started with the CData ODBC Driver for Auth0
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Auth0.
-
How to work with AfterShip Data in Apache Spark using SQL
Access and process AfterShip Data in Apache Spark using the CData Software JDBC Driver.
-
Automate Redis Data Replication to SAP HANA
Use CData Sync to customize and automate Redis data replication to SAP HANA.
-
Replicate GitLab Data in Heroku for Use in Salesforce Connect
Replicate GitLab data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to Easily Query Stripe Data in OpenOffice Base
Connect to Stripe data in OpenOffice Base using the CData ODBC Driver for Stripe and generate reports with live data insights.
-
Explore Geographical Relationships in xBase Data with Power Map
Create data visualizations with xBase data in Power Map.
-
A PostgreSQL Interface for Copper Data using the CData ODBC Driver
Use the SQL Gateway and Copper ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to Query Google Calendar Data in MySQL Workbench
Execute MySQL queries against live Google Calendar data from MySQL Workbench.
-
Build Neo4J Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Neo4J data and build visualizations in Tableau Cloud.
-
Connect to and Visualize Live Bitbucket Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Bitbucket data.
-
How to load WordPress data into Elasticsearch via Logstash
Introducing a simple method to load WordPress data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect and Visualize Live Avro Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Avro data into the Databricks platform and create visualization dashboards with real-time Avro data.
-
Automated Continuous Google Sheets Replication to MongoDB
Use CData Sync for automated, continuous, customizable Google Sheets replication to MongoDB.
-
Create Keap Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Keap from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to Query Live CouchDB Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live CouchDB data data in natural language using Python.
-
Building Dynamic Web Pages with Square Data Using AngularJS
Create single-page applications with live connectivity to Square using the CData API Server.
-
Analyze ZohoSubscriptions Data in Looker
Use CData Connect AI to connect to ZohoSubscriptions Data from Looker and build custom apps using live ZohoSubscriptions data.
-
Automated Continuous JotForm Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable JotForm replication to Amazon Redshift.
-
Create Dynamic Datadog Grids Using the Infragistics XamDataGrid
Learn how you can connect Datadog to Infragistics XamDataGrid to build dynamic grids.
-
Integrate Goose with Live Phoenix Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Phoenix data from within the local AI agent.
-
Integrating Cursor with SAP Netweaver Gateway 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.
-
Consume Microsoft Teams OData Feeds in PowerBuilder
This article demonstrates how to consume Microsoft Teams data as OData feeds from PowerBuilder using the API Server.
-
Automated Continuous FHIR Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable FHIR replication to delimited files (CSV/TSV).
-
Use Biml to Build SSIS Tasks to Replicate Jumpseller Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Jumpseller data to SQL Server.
-
Use the CData Software ODBC Driver for ZohoMarketingHub in MicroStrategy
Connect to ZohoMarketingHub data in MicroStrategy Developer using the CData Software ODBC Driver for ZohoMarketingHub.
-
Access Live HubDB Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live HubDB data from your Excel spreadsheets.
-
Create Shortcut-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Shortcut Data from Klipfolio and build custom visualizations using live Shortcut data.
-
Create Xero-Connected Business Apps in AppSheet
Connect to Xero Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Xero data.
-
Integrate Dify with Live Oracle Financials Cloud Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Oracle Financials Cloud data.
-
Provide OData Services of Suadeo Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Suadeo data by developing a WCF Service Application.
-
Integrate Goose with Live BigQuery Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live BigQuery data from within the local AI agent.
-
Consume Dynamics CRM OData Feeds in PowerBuilder
This article demonstrates how to consume Dynamics CRM data as OData feeds from PowerBuilder using the API Server.
-
Use the CData Software JDBC Driver for Access in MicroStrategy
Connect to Access data in MicroStrategy Developer using the CData Software JDBC Driver for Access.
-
Integrating Gumloop with Oracle Financials Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Oracle Financials Cloud data within automated workflows.
-
DataBind Controls to Instantly Data in Delphi
DataBind to Instantly data in Delphi with standard data access components and controls.
-
Visualize Yelp Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Yelp data into TIBCO Spotfire.
-
Add FTP Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for FTP with the Informatica Enterprise Data Catalog to classify and organize data.
-
Establish a Live Connection with Stripe Data using Tableau Bridge
The CData ODBC Driver for Stripe enables you to integrate live Stripe data into Tableau Cloud dashboards using the Tableau Bridge.
-
Build Dashboards with Oracle Data in Dundas BI
Create dynamic dashboards and perform analytics based on Oracle data in Dundas BI.
-
How to use SQLAlchemy ORM to access Discord Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Discord data.
-
Create Reports with Jira Assets Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Jira Assets data.
-
Create Chargebee Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Chargebee from PowerBI.com to create Power BI Dataflows with real-time data.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for OData
Provide connectivity to OData services through an SAP BusinessObjects universe.
-
Automated Continuous Google Spanner Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Google Spanner replication to Amazon Redshift.
-
Viewing Instagram Data in RAD Studio Data Explorer
How to view Instagram data in RAD Studio Data Explorer using the CData ODBC Driver for Instagram.
-
Create Data Visualizations in Cognos BI with TaxJar Data
Access TaxJar data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
DataBind Charts to YouTube Analytics Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to YouTube Analytics data 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.
-
Create Certinia-Connected Applications in Appsmith
Connect to Certinia Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Certinia data.
-
Import Real-Time OneNote Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use OneNote data in ColdFusion.
-
Connect to Strava Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Strava as an External Source in Dremio.
-
Connect to Act CRM Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Act CRM data in Airbyte.
-
Import and Visualize Pipeliner CRM Data in Power View
Create data visualizations based on Pipeliner CRM data in Excel.
-
Use CData Connect AI to Access Oracle SCM Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Oracle SCM data in the Power Pivot business intelligence tool.
-
Build AI/ML Models with Live Productboard Data using Dataiku
Connect Productboard Data with Dataiku using the CData API Driver for JDBC.
-
Connect to Superchat Data in Ruby
Connect to Superchat data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Create a Data Access Object for Figshare Data using JDBI
A brief overview of creating a SQL Object API for Figshare data in JDBI.
-
Replicate Multiple WooCommerce Accounts
Replicate multiple WooCommerce accounts to one or many databases.
-
Create Data Visualizations in Cognos BI with MYOB AccountRight Data
Access MYOB AccountRight data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to connect to SAP Hybris C4C Data in DBVisualizer
Integrate SAP Hybris C4C data with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrate Live ZohoPeople Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to ZohoPeople data and integrate live ZohoPeople data into apps built in Microsoft Power Apps.
-
Connect and Visualize Live QuickBooks Time Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live QuickBooks Time data into the Databricks platform and create visualization dashboards with real-time QuickBooks Time data.
-
Connect to Shortcut Data in DBeaver
Use the CData ODBC Driver to connect to Shortcut data in DBeaver.
-
Integrate Dify with Live Cvent Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Cvent data.
-
Connecting Moonlit Workflow with Dynamics 365 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 Dynamics 365 data in real time.