CData Software - Knowledge Base
Recent Articles
-
Design BIRT Reports on Bannerbear Data
Provide current Bannerbear data to your embedded analytics.
-
Establish a Live Connection with Dynamics CRM Data using Tableau Bridge
The CData ODBC Driver for Dynamics CRM enables you to integrate live Dynamics CRM data into Tableau Cloud dashboards using the Tableau Bridge.
-
Integrating OpenCode with ConvertAPI 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.
-
Integrate with Monday.com Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Monday.com data in SnapLogic.
-
Use the CData Software JDBC Driver for Mistral AI in MicroStrategy
Connect to Mistral AI data in MicroStrategy Developer using the CData Software JDBC Driver for Mistral AI.
-
Connect Strava to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Strava data using the CData Python MCP Server.
-
Use the CData Software ODBC Driver for Mode in MicroStrategy
Connect to Mode data in MicroStrategy Developer using the CData Software ODBC Driver for Mode.
-
Load AgileCRM Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load AgileCRM data to a database.
-
Create Informatica Mappings From/To an ODBC Data Source for SAS Data Sets
Create an ODBC connection to SAS Data Sets in Informatica and browse and transfer SAS Data Sets data.
-
Build Oracle HCM Cloud-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Oracle HCM Cloud data and build web apps with connectivity to live Oracle HCM Cloud data.
-
Publish Mode-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Mode data.
-
Build Visualizations of SageHR Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of SageHR data in Birst.
-
Use the CData Software JDBC Driver for FormSite in MicroStrategy Desktop
Connect to FormSite data in MicroStrategy Desktop using the CData Software JDBC Driver for FormSite.
-
Integrating LlamaIndex with Optimizely Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Optimizely data in real time.
-
Connect to Stripe Data in Aqua Data Studio
Access Stripe data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Use Manus AI to Talk to Your Dynamics 365 Business Central Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Dynamics 365 Business Central data.
-
Link Harvest with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Harvest data in Filemaker Pro for Mac or Windows.
-
Access Live ZohoMarketingHub Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live ZohoMarketingHub data through MCP integration.
-
Visualize Phoenix Data in Sisense
Create an ElastiCube in Sisense app with access to Phoenix data.
-
Build Neo4J-Connected Apps in Choreo
Use CData Connect AI to connect to Neo4J Data from Choreo and build custom apps using live Neo4J data.
-
Integrate Wave Financial with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Wave Financial with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Wave Financial data.
-
Query Freshteam Data in DataGrip
Create a Data Source for Freshteam in DataGrip and use SQL to query live Freshteam data.
-
Interact with Live Yelp Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Yelp data.
-
Integrate Live Quickbase Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Quickbase data from within the IDE.
-
Use the CData Software JDBC Driver for TigerGraph in MicroStrategy Web
Connect to TigerGraph data in MicroStrategy Web using the CData Software JDBC Driver for TigerGraph.
-
How to Seamlessly Import ClickTime Data into IBM SPSS Modeler
Integrate ClickTime data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to ServiceNow Data in DBeaver
Use the CData ODBC Driver to connect to ServiceNow data in DBeaver.
-
Import Real-Time Google Contacts Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Google Contacts data in ColdFusion.
-
Publish IBM Informix-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live IBM Informix data.
-
Working with SendGrid Data in LINQPad
Execute LINQ queries to SendGrid data in LINQPad.
-
Migrating data from Bitbucket to Databricks using CData SSIS Components.
Easily push Bitbucket data to Databricks using the CData SSIS Tasks for Bitbucket and Databricks.
-
Create Bitly-Connected Nintex Workflows
Use CData Connect AI to connect to Bitly Data from Nintex Workflow Cloud and build custom workflows using live Bitly data.
-
Automated Continuous PostgreSQL Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable PostgreSQL replication to Amazon Redshift.
-
Access Chargebee Data from MySQL in PHP
Connect to Chargebee through the standard MySQL libraries in PHP.
-
Build Semantic Layer Views for MySQL Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for MySQL data.
-
Automated Continuous Dotmailer Replication to Snowflake
Use CData Sync for automated, continuous, customizable Dotmailer replication to Snowflake.
-
Build ZohoInvoice-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for ZohoInvoice Data and create custom apps in Mendix.
-
How to Work with Freshteam Data in ETL Validator JDBC
Connect to Freshteam from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Oracle Service Cloud from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Oracle Service Cloud data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Visualize Live ZohoInvoice Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live ZohoInvoice data.
-
How to Query Live Parallel Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Parallel data data in natural language using Python.
-
Connect to Moosend Data from HeidiSQL
Use CData Connect AI to connect to and query live Moosend data from HeidiSQL.
-
Access Live Google Spanner Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Google Spanner data from your Excel spreadsheets.
-
Automated Continuous Nuclia Replication to SQLite
Use CData Sync for automated, continuous, customizable Nuclia replication to SQLite.
-
Rapidly Develop EmailOctopus-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by EmailOctopus.
-
Build Apps with Live EnterpriseDB data in Adalo using CData Connect AI
Use CData Connect AI to integrate live EnterpriseDB data into the Adalo platform and build custom mobile and web applications with real-time EnterpriseDB data.
-
Work with Workable Data in FoxPro
Load Workable data into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to Connect to Live Power BI XMLA Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Power BI XMLA data for you.
-
Create SSAS Tabular Models from Spark Data
How to build a SQL Server Analysis Service Tabular Model from Spark data using CData drivers.
-
Load WooCommerce Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load WooCommerce data to a database.
-
Automated Continuous Accelo Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Accelo replication to PostgreSQL.
-
Getting Started with the CData Connect AI Python SDK for Bright Data
Install the CData Connect AI Python SDK to read live Bright Data data with standard DB-API 2.0 Python code.
-
Automated Continuous Webflow Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Webflow replication to IBM DB2.
-
Replicate Reckon Data to Multiple Databases
Replicate Reckon data to disparate databases with a point-and-click configuration.
-
Automated Continuous ZohoSubscriptions Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable ZohoSubscriptions replication to Apache Cassandra.
-
Create Microsoft Ads-Connected Business Apps in AppSheet
Connect to Microsoft Ads Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Microsoft Ads data.
-
Analyze Jumpseller Data in Cognos Analytics
Use CData Connect AI to connect to Jumpseller Data from Cognos Analytics and analyze live Jumpseller data.
-
LINQ to Aha! 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 Aha! Data Provider.
-
Use the CData Software JDBC Driver for Unbounce in MicroStrategy Web
Connect to Unbounce data in MicroStrategy Web using the CData Software JDBC Driver for Unbounce.
-
Import Real-Time Microsoft OneDrive Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Microsoft OneDrive data in ColdFusion.
-
Integrating Cursor with Keap 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.
-
View Reports on Real-Time Templated Data in Power BI Report Server
Use the CData ODBC Driver for Templated to visualize Templated data in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrating Gumloop with Google Sheets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Google Sheets data within automated workflows.
-
Automated Continuous Acumatica Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Acumatica replication to Amazon Redshift.
-
Prepare, Blend, and Analyze Figshare Data in Alteryx Designer (Connect AI)
Build workflows to access live Figshare data for self-service data analytics.
-
Create NetSuite SuiteAnalytics-Connected Business Apps in AppSheet
Connect to NetSuite SuiteAnalytics Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to NetSuite SuiteAnalytics data.
-
Create Apps from Stripe Data in Qlik Sense Cloud
Use CData Connect AI to connect to Stripe Data and build apps from live Stripe data in Qlik Sense Cloud.
-
Automated Continuous Highrise Replication to Snowflake
Use CData Sync for automated, continuous, customizable Highrise replication to Snowflake.
-
Configure the CData JDBC Driver for Bannerbear in a Connection Pool in Tomcat
Connect to Bannerbear data from a connection pool in Tomcat.
-
Integrate with Airtable Data in JReport Designer
Create charts and reports based on Airtable data in JReport Designer.
-
Automated Moosend Data Replication to Teradata
Use CData Sync to Customize and automate Moosend data replication to Teradata.
-
Use Databricks Agent Bricks to Talk to Your Microsoft Ads Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Microsoft Ads data for you.
-
Create Bitbucket-Connected Applications in Appsmith
Connect to Bitbucket Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Bitbucket data.
-
Integrate OpenCode with Live Printify Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Printify data from within your AI coding agent.
-
How to Work with Sage Cloud Accounting Data in ETL Validator JDBC
Connect to Sage Cloud Accounting from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Excel Online Data in Ruby
Connect to Excel Online data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Use Microsoft Copilot Studio to talk to your Redshift Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Redshift data for you.
-
Access Live SAP Ariba Procurement Data in Coginiti Pro
Connect to and query live SAP Ariba Procurement data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Integrate Live Bright Data Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Bright Data data and integrate live Bright Data data into apps built in Microsoft Power Apps.
-
Create Datasets from eBay Analytics in Domo Workbench and Build Visualizations of eBay Analytics Data in Domo
Use the CData Software ODBC Driver for eBay Analytics to create datasets from eBay Analytics data in Domo Workbench and then build visualizations in the Domo service.
-
Connect to PingOne Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live PingOne data from Filemaker Pro on Mac.
-
Create Informatica Mappings From/To an ODBC Data Source for Exa
Create an ODBC connection to Exa in Informatica and browse and transfer Exa data.
-
Build AI/ML Models with Live IBM Cloud Object Storage Data using Dataiku
Connect IBM Cloud Object Storage Data with Dataiku using the CData JDBC Driver for IBM Cloud Object Storage.
-
Integrate Live SendPulse Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to SendPulse data and integrate live SendPulse data into apps built in Microsoft Power Apps.
-
Replicate SAP BusinessObjects BI Data from PowerShell
Write a quick PowerShell script to query SAP BusinessObjects BI data. Use connectivity to the live data to replicate SAP BusinessObjects BI data to SQL Server.
-
How to connect and process Slack data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Slack data.
-
A PostgreSQL Interface for Figshare Data using the CData ODBC Driver
Use the SQL Gateway and Figshare ODBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate Dynamics CRM with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Dynamics CRM with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Dynamics CRM data.
-
Automated Continuous Codat Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Codat replication to Apache Kafka.
-
Automated Continuous Cassandra Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Cassandra replication to Amazon S3.
-
Automated Continuous Wrike Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Wrike replication to Azure SQL Database.
-
Build Pipelines with Live Oracle Eloqua Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Oracle Eloqua from Google Cloud Data Fusion, enabling the integration of live Oracle Eloqua data into the building and management of effective data pipelines.
-
Getting Started with the CData JDBC Driver for Pushbullet
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Pushbullet.
-
Integrate Live QuickBooks Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to QuickBooks from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live QuickBooks data.
-
Create Power BI Reports on Real-Time FormSite Data
Use the CData ODBC Driver for FormSite to visualize FormSite data in Power BI Desktop.
-
Perform Batch Operations with Microsoft Planner Data in Apache NiFi
Connect to Microsoft Planner data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
How to connect and process PostgreSQL data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live PostgreSQL data.
-
Automated Continuous Avalara AvaTax Replication to SQLite
Use CData Sync for automated, continuous, customizable Avalara AvaTax replication to SQLite.
-
Import Real-Time CapsuleCRM Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use CapsuleCRM data in ColdFusion.
-
Prepare, Blend, and Analyze Eventbrite Data in Alteryx Designer (ODBC)
Build workflows to access live Eventbrite data for self-service data analytics.