CData Software - Knowledge Base
Recent Articles
-
Analyze Square Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Square and visualize live Square in Infragistics Reveal.
-
Use Grok to Talk to Your Stripe Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Stripe for you.
-
How to create an RPA flow for CockroachDB Data in UiPath Studio
Use the CockroachDB ODBC Driver to create workflows that access real-time CockroachDB without any coding.
-
Design BIRT Reports on Bannerbear Data
Provide current Bannerbear 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 Microsoft Dynamics CRM into Tableau Cloud dashboards using the Tableau Bridge.
-
Integrating OpenCode Terminal 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 in SnapLogic.
-
Use the CData Software JDBC Driver for Mistral AI in MicroStrategy
Connect to Mistral AI 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 using the CData Python MCP Server.
-
Use the CData Software ODBC Driver for Mode in MicroStrategy
Connect to Mode 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 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.
-
Build Oracle HCM Cloud-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Oracle HCM Cloud and build web apps with connectivity to live Oracle HCM Cloud.
-
Publish Mode-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Mode.
-
Build Visualizations of SageHR Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of SageHR in Birst.
-
Use the CData Software JDBC Driver for FormSite in MicroStrategy Desktop
Connect to FormSite in MicroStrategy Desktop using the CData Software JDBC Driver for FormSite.
-
Connect to Stripe Data in Aqua Data Studio
Access Stripe 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.
-
Bidirectional Access to Harvest Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Harvest in Filemaker Pro for Mac or Windows.
-
Visualize Phoenix Data in Sisense
Create an ElastiCube in Sisense app with access to Apache Phoenix.
-
Build Neo4J-Connected Apps in Choreo
Use CData Connect AI to connect to Neo4J Data from Choreo and build custom apps using live Neo4J.
-
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.
-
Query Freshteam Data in DataGrip
Create a Data Source for Freshteam in DataGrip and use SQL to query live Freshteam.
-
Integrate Live Quickbase Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Use the CData Software JDBC Driver for TigerGraph in MicroStrategy Web
Connect to TigerGraph 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 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 in ColdFusion.
-
How to Access Live Jira Data in Visual Studio Code via Cline
Run CData MCP Server for Jira on Windows Subsytem for Linux (WSL) and connect to live Atlassian Jira from the Cline extension in Visual Studio Code.
-
Publish IBM Informix-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live IBM Informix.
-
Working with SendGrid Data in LINQPad
Execute LINQ queries to SendGrid in LINQPad.
-
Migrating data from Bitbucket to Databricks using CData SSIS Components.
Easily push Bitbucket to Databricks using the CData SSIS Tasks for Bitbucket and Databricks.
-
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.
-
Automated Continuous Dotmailer Replication to Snowflake
Use CData Sync for automated, continuous, customizable Dotmailer replication to Snowflake.
-
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, 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.
-
How to Query Live Parallel Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Parallel data in natural language using Python.
-
Access Live Google Spanner Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Google Spanner from your Excel spreadsheets.
-
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 in Adalo using CData Connect AI
Use CData Connect AI to integrate live EnterpriseDB into the Adalo platform and build custom mobile and web applications with real-time EnterpriseDB.
-
Work with Workable Data in FoxPro
Load Workable 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 for you.
-
Create SSAS Tabular Models from Spark Data
How to build a SQL Server Analysis Service Tabular Model from Apache Spark SQL 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 to a database.
-
Automated Continuous Accelo Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Accelo replication to PostgreSQL.
-
Replicate Reckon Data to Multiple Databases
Replicate Reckon 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.
-
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 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 in ColdFusion.
-
Integrating Cursor CLI 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 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 within automated workflows.
-
Automated Continuous Acumatica Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Acumatica replication to Amazon Redshift.
-
Build Oracle HCM Cloud-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Oracle HCM Cloud to explore live Oracle HCM Cloud Data in Cursor to assist with building Oracle HCM Cloud-powered applications.
-
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.
-
Create Apps from Stripe Data in Qlik Sense Cloud
Use CData Connect AI to connect to Stripe Data and build apps from live Stripe 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 from a connection pool in Tomcat.
-
Integrate with Airtable Data in JReport Designer
Create charts and reports based on Airtable in JReport Designer.
-
Automated Moosend Data Replication to Teradata
Use CData Sync to Customize and automate Moosend 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 for you.
-
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 Microsoft Excel Online 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 Amazon Redshift for you.
-
Access Live SAP Ariba Procurement Data in Coginiti Pro
Connect to and query live SAP Ariba Procurement from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
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 in Domo Workbench and then build visualizations in the Domo service.
-
Create Informatica Mappings From/To an ODBC Data Source for Exa
Create an ODBC connection to Exa in Informatica and browse and transfer Exa.
-
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.
-
Replicate SAP BusinessObjects BI Data from PowerShell
Write a quick PowerShell script to query SAP BusinessObjects BI. Use connectivity to the live data to replicate SAP BusinessObjects BI to SQL Server.
-
How to connect and process Slack from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Slack.
-
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 Microsoft Dynamics CRM.
-
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 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.
-
Create Power BI Reports on Real-Time FormSite Data
Use the CData ODBC Driver for FormSite to visualize FormSite in Power BI Desktop.
-
Perform Batch Operations with Microsoft Planner Data in Apache NiFi
Connect to Microsoft Planner and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
How to connect and process PostgreSQL from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live PostgreSQL.
-
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 in ColdFusion.
-
Prepare, Blend, and Analyze Eventbrite Data in Alteryx Designer (ODBC)
Build workflows to access live Eventbrite for self-service data analytics.
-
DataBind Charts to Freshteam Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Freshteam 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.
-
Use Agno to Talk to Your Lakebase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Lakebase for you.
-
Use the CData Software JDBC Driver for Toggl in MicroStrategy
Connect to Toggl in MicroStrategy Developer using the CData Software JDBC Driver for Toggl.
-
Access Live Acumatica Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Acumatica ERP into the statistical analysis tools available in SAS JMP. This article shows how to use Acumatica ERP in the Graph Builder and Query Builder.
-
Create Datasets from Zoho Inventory in Domo Workbench and Build Visualizations of Zoho Inventory Data in Domo
Use the CData Software ODBC Driver for Zoho Inventory to create datasets from Zoho Inventory in Domo Workbench and then build visualizations in the Domo service.
-
Consume Act CRM OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Act CRM feeds that reflect any changes in SAP Lumira.
-
Replicate Oracle Financials Cloud Data from PowerShell
Write a quick PowerShell script to query Oracle Financials Cloud. Use connectivity to the live data to replicate Oracle Financials Cloud to SQL Server.
-
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.
-
Access Live SharePoint Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Microsoft SharePoint from your Excel spreadsheets.
-
Migrating data from Salesforce Data 360 to Snowflake using CData SSIS Components.
Easily push Salesforce Data 360 to Snowflake using the CData SSIS Tasks for Salesforce Data 360 and Snowflake.
-
Access Live Adobe Experience Manager Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Adobe Experience Manager into the statistical analysis tools available in SAS JMP. This article shows how to use Adobe Experience Manager in the Graph Builder and Query Builder.
-
Query SingleStore Data from Node.js
Use the OData endpoint of the CData API Server to connect to your SingleStore and perform CRUD operations on SingleStore from Node.js.