CData Software - Knowledge Base
Recent Articles
-
How to Connect Flowise AI Agents to Live Act-On via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live data without replication.
-
Build Epicor Kinetic-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Epicor Kinetic and build Epicor Kinetic-connected web apps with Axios.
-
Use the CData API Server to Access Dynamics CRM in Microsoft PowerPivot
Use the CData API Server to connect to live Microsoft Dynamics CRM in the Power Pivot business intelligence tool.
-
Create Impala Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Impala data access from reports, embedded analytics, and more.
-
Import Certinia into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Certinia. In this article, you will use the OData format to import Certinia into Microsoft Power Query.
-
Work with Sybase in FoxPro
Load Sybase into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to integrate Metabase with Facebook
Use CData Connect AI to connect to live Facebook and create an interactive dashboard in Metabase from Facebook.
-
Use the CData Software JDBC Driver for HarperDB in MicroStrategy
Connect to HarperDB in MicroStrategy Developer using the CData Software JDBC Driver for HarperDB.
-
Automated Continuous MailChimp Replication to Snowflake
Use CData Sync for automated, continuous, customizable MailChimp replication to Snowflake.
-
Use Microsoft Copilot Studio to talk to your Twitter Ads 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 Twitter Ads for you.
-
Model, Search, and Visualize Live IBM Informix in ThoughtSpot
Use CData Connect AI to connect to live IBM Informix for modeling, searching, and visualizing.
-
Using the CData Software ODBC Driver for AlloyDB in PyCharm
Connect to AlloyDB as an ODBC data source in PyCharm using the CData Software ODBC Driver for AlloyDB.
-
Access QuickBooks from MySQL in Amazon QuickSight
Connect to QuickBooks and build visualizations of QuickBooks Desktop using a MySQL Connection in Amazon QuickSight.
-
How to Work with MailChimp in ETL Validator JDBC
Connect to MailChimp from ETL Validator jobs using the CData Software JDBC Driver.
-
Access eBay 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 eBay.
-
Access Live Google Ads Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Google Ads data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
How to import QuickBooks into Apache Solr
Use the CData Software JDBC Driver for QuickBooks in Data Import Handler and create an automated import of QuickBooks Desktop to Apache Solr Enterprise Search platform.
-
Visualize Live Odoo in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Odoo ERP.
-
Create Jira Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
Import Quickbase into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Quickbase. In this article, you will use the OData format to import Quickbase into Microsoft Power Query.
-
Build Automated Vault CRM-Connected Workflows in Zapier
Use CData Connect AI to connect to live Veeva Vault & Vault CRM and build automated workflows in Zapier.
-
Use Claude to Talk to Your Google Directory via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Google Directory for you.
-
Build Stripe-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Stripe and build Stripe-connected web apps with Axios.
-
Import Monday.com Using Azure Data Factory
Use CData Connect AI to connect to Monday.com from Azure Data Factory and import live Monday.com.
-
Connect to Databricks from a Connection Pool in JBoss
Integrate Databricks into Java servlets: Use the Management Console in JBoss to install the Databricks JDBC Driver.
-
Create Informatica Mappings From/To an ODBC Data Source for Drip
Create an ODBC connection to Drip in Informatica and browse and transfer Drip.
-
Write a Simple Go Application to work with BigQuery on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Google BigQuery.
-
Analyze Basecamp in R via JDBC
Use standard R functions and the development environment of your choice to analyze Basecamp with the CData JDBC Driver for Basecamp.
-
A PostgreSQL Interface for Cvent using the CData ODBC Driver
Use the SQL Gateway and Cvent ODBC Driver to create a PostgreSQL entry-point for data access.
-
Visualize Live SurveyMonkey in the Power BI Service
Use CData Connect AI to connect to live SurveyMonkey and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Use the CData Software JDBC Driver for QuickBooks in MicroStrategy Desktop
Connect to QuickBooks Desktop in MicroStrategy Desktop using the CData Software JDBC Driver for QuickBooks.
-
How to Connect DBeaver to Google Calendar via a JDBC Driver
Manage Google Calendar with visual tools in DBeaver like the query browser.
-
Connect to Drip in Google Apps Script via SQL Gateway
Use the ODBC Driver for Drip and the SQL Gateway to access Drip from Google Apps Script.
-
Query Unbounce in ColdFusion
Write standard ColdFusion data access code to connect to Unbounce.
-
Query HCL Domino in DataGrip
Create a Data Source for HCL Domino in DataGrip and use SQL to query live HCL Domino.
-
Automated Continuous Google Sheets Replication to SQLite
Use CData Sync for automated, continuous, customizable Google Sheets replication to SQLite.
-
Analyze SAP Ariba Procurement in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of SAP Ariba Procurement and visualize SAP Ariba Procurement in SAP Analytics Cloud.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Azure Synapse to Power BI dashboards. Simply drag and drop Azure Synapse into data visuals on the Power BI canvas.
-
Easily Integrate Neo4J in Lazarus Pascal IDE
Learn how to easily integrate live Neo4J in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to JSON Services from a Connection Pool in JBoss
Integrate JSON into Java servlets: Use the Management Console in JBoss to install the JSON JDBC Driver.
-
Connect to Instagram in RapidMiner
Integrate Instagram with standard components and data source configuration wizards in RapidMiner Studio.
-
Build Pipelines with Live Google Spanner in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Google Spanner from Google Cloud Data Fusion, enabling the integration of live Google Spanner into the building and management of effective data pipelines.
-
Use Azure AI Foundry to Talk to Your BigCommerce via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your BigCommerce for you.
-
Integrating Claude Code with Microsoft Exchange via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Microsoft Exchange within assisted coding and automated development workflows.
-
Visualize Live Neo4J in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Neo4J.
-
Integrate SAP with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate SAP with External Services.
-
Query Tableau CRM Analytics as a SQL Server Database in Node.js
Execute SQL Server queries against Tableau CRM Analytics from Node.js.
-
Enable the Zendesk JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Zendesk.
-
Establish a Live Connection with CockroachDB using Tableau Bridge
The CData ODBC Driver for CockroachDB enables you to integrate live CockroachDB into Tableau Cloud dashboards using the Tableau Bridge.
-
Integrate with HubDB using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy HubDB to a JSON file on disk.
-
Automated Continuous EventBrite Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable EventBrite replication to Apache Kafka.
-
Create Freshdesk-Connected Nintex Workflows
Use CData Connect AI to connect to Freshdesk from Nintex Workflow Cloud and build custom workflows using live Freshdesk.
-
Publish Zendesk-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Zendesk.
-
Sage Intacct Reporting in OBIEE with the Sage Intacct JDBC Driver
Deploy the Sage Intacct JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Create Facebook Ads-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Facebook Ads from OutSystems and build custom enterprise apps using live Facebook Ads.
-
Load Cosmos DB to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Azure Cosmos DB to a database.
-
Create Data Visualizations in Cognos BI with Act CRM
Access Act CRM as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Analyze Kintone with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Kintone from Power Pivot. You will use the Table Import Wizard to load Kintone. You can visually build the import query or use any SQL supported by the driver.
-
Analyze Zuora with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Zuora from Power Pivot. You will use the Table Import Wizard to load Zuora. You can visually build the import query or use any SQL supported by the driver.
-
Connect to Greenhouse in Claris FileMaker Pro
-