CData Software - Knowledge Base
Recent Articles
-
How to Query HubDB in MySQL Workbench
Execute MySQL queries against live HubDB from MySQL Workbench.
-
Connect to NetSuite as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for NetSuite CRM & ERP.
-
Integrate Dropbox with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Dropbox with External Services.
-
Use the CData Software JDBC Driver for Google Sheets in MicroStrategy
Connect to Google Sheets in MicroStrategy Developer using the CData Software JDBC Driver for Google Sheets.
-
Process & Analyze Twitter Ads in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Twitter Ads .
-
Bridge Square Connectivity with Apache NiFi
Access and process Square in Apache NiFi using the CData JDBC Driver.
-
Automated Continuous Confluence Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Confluence replication to Azure SQL Database.
-
Access Live SQL Analysis Services in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate SQL Analysis Services into the statistical analysis tools available in SAS JMP. This article shows how to use SQL Analysis Services in the Graph Builder and Query Builder.
-
How to connect and process Facebook from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Facebook.
-
Edit and Search MarkLogic External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of MarkLogic to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create MarkLogic objects that you can access from apps and the dashboard.
-
Create Airtable-Connected Applications in Appsmith
Connect to Airtable via CData Connect AI in Appsmith and create custom business applications with real-time access to Airtable.
-
ETL Elasticsearch in Oracle Data Integrator
This article shows how to transfer Elasticsearch into a data warehouse using Oracle Data Integrator.
-
Integrate MongoDB in Pentaho Data Integration
Build ETL pipelines based on MongoDB in the Pentaho Data Integration tool.
-
Extend Google Sheets with LinkedIn Ads
Make calls to the API Server from Google Apps Script.
-
Build a PostgreSQL Interface for Spark using the CData JDBC Driver
Use the Remoting features of the Spark JDBC Driver to create a PostgreSQL entry-point for data access.
-
Query Zoho CRM in DataGrip
Create a Data Source for Zoho CRM in DataGrip and use SQL to query live Zoho CRM.
-
Use Claude to Talk to Your HubSpot via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your HubSpot for you.
-
Create Informatica Mappings From/To a JDBC Data Source for Smartsheet
Create Smartsheet data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Integrating Boomi Agentstudio with Facebook Ads via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Facebook Ads, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Connect Greenhouse to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Greenhouse using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Create Dynamic Airtable Grids Using the Infragistics XamDataGrid
Learn how you can connect Airtable to Infragistics XamDataGrid to build dynamic grids.
-
Import Real-Time Zoom via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Zoom in ColdFusion.
-
Create Power BI Reports on Real-Time Facebook
Use the CData ODBC Driver for Facebook to visualize Facebook in Power BI Desktop.
-
Build Semantic Layer Views for SAS Data Sets in APOS Live Data Gateway
Use the CData Connector for SAS Data Sets in APOS Live Data Gateway to build Semantic Layer Views for SAS Data Sets.
-
Visualize Shopify in Tableau
The CData ODBC driver for Shopify enables you integrate Shopify into Tableau dashboards.
-
CData Sync’s Enhanced CDC vs Traditional CDC: A Performance Comparison
Testing how much faster Sync is able to replicate changes using Enhanced CDC vs Traditional CDC.
-
Create HarperDB Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
Publish Pinterest-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Pinterest.
-
Design BIRT Reports on BigQuery
Provide current Google BigQuery to your embedded analytics.
-
Edit and Search External Zendesk Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Zendesk to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Zendesk objects that you can access from apps and the dashboard.
-
Connect to and Query Oracle HCM Cloud in QlikView over ODBC
Create data visualizations with Oracle HCM Cloud in QlikView.
-
Automate SingleStore Replication to Azure Synapse
Use CData Sync to customize and automate SingleStore replication to Azure Synapse.
-
Build MariaDB-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to MariaDB and build web apps with connectivity to live MariaDB.
-
Use the CData Software JDBC Driver for QuickBooks Time in MicroStrategy Web
Connect to QuickBooks Time in MicroStrategy Web using the CData Software JDBC Driver for QuickBooks Time.
-
Replicate Hive in Heroku for Use in Salesforce Connect
Replicate Apache Hive to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Create ActiveCampaign Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
Replicate Wave Financial in Heroku for Use in Salesforce Connect
Replicate Wave Financial to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to integrate Act-On with Apache Airflow
Access and process Act-On in Apache Airflow using the CData JDBC Driver.
-
Access Google Contacts as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Google Contacts from your Oracle system.
-
How to Connect Flowise AI Agents to Live WordPress 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.
-
Use the CData Software ODBC Driver for Facebook in MicroStrategy
Connect to Facebook in MicroStrategy Developer using the CData Software ODBC Driver for Facebook.
-
Connect to Pinterest in SpagoBI
Create reports featuring live Pinterest in SpagoBI Studio. Host Pinterest reports on SpagoBI Server.
-
Access Live Oracle Eloqua in Excel 365 Online (Excel for the web)
Connect to Oracle Eloqua from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Process & Analyze MYOB AccountRight in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live MYOB AccountRight .
-
How to use SQLAlchemy ORM to access Google Ads in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Google Ads.
-
Choosing the Best Method to Connect ConstantContact to SQL Server: 5 Options Explained
Discover multiple ways to connect and use ConstantContact from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to Phoenix in Google Apps Script via SQL Gateway
Use the ODBC Driver for Phoenix and the SQL Gateway to access Apache Phoenix from Google Apps Script.
-
Build MVC Applications with Connectivity to Twitter Ads
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Twitter Ads from an ASP.NET MVC application.
-
Automate Bing Ads Replication to SAP HANA
Use CData Sync to customize and automate Bing Ads replication to SAP HANA.
-
Connect to YouTube Analytics in Google Apps Script via Connect AI
Use CData Connect AI to access YouTube Analytics in Google Apps Script.
-
Automated Continuous Lakebase Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Lakebase replication to delimited files (CSV/TSV).
-
Getting Started with the CData ODBC Driver for SFTP
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for SFTP.
-
Connect to Redshift in ACL Analytics
Connect to Amazon Redshift via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Amazon Redshift.
-
Build AI Agents with Facebook Ads Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can
-
How to Connect to Live Office 365 from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Microsoft Office 365 for you.
-
Consume Microsoft OneDrive OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Microsoft OneDrive feeds that reflect any changes in SAP Lumira.
-
How to connect and process PostgreSQL from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live PostgreSQL.
-
Visualize Excel Online in TIBCO Spotfire through OData
Integrate Microsoft Excel Online into dashboards in TIBCO Spotfire.
-
How to connect to Active Directory with Squirrel SQL client
Connect to Active Directory and execute queries in the Squirrel SQL Client.
-
Deploy the ADO.NET Provider for Sage Intacct on an SSRS Report Server
Connect to Sage Intacct from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Query, Visualize, and Share live Salesforce Marketing in Redash
Use CData Connect AI to connect to live Salesforce Marketing Cloud in Redash for querying, visualizing, and sharing.
-
Use the CData Software JDBC Driver for Clio in MicroStrategy Web
Connect to Clio in MicroStrategy Web using the CData Software JDBC Driver for Clio.
-
Publish Highrise-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Highrise CRM.
-
Use CData Connect AI to Access Gmail in Microsoft Power Pivot
Use CData Connect AI to connect to live Gmail in the Power Pivot business intelligence tool.
-
Create SSAS Tabular Models from ServiceNow
How to build a SQL Server Analysis Service Tabular Model from ServiceNow using CData drivers.
-
Use the CData Software ODBC Driver for XML in MicroStrategy
Connect to XML Files in MicroStrategy Developer using the CData Software ODBC Driver for XML.
-
Automated Zoho Creator Replication to Teradata
Use CData Sync to Customize and automate Zoho Creator replication to Teradata.
-
How to Connect to Live SAP BusinessObjects BI from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your SAP BusinessObjects BI for you.
-
Getting Started with the CData JDBC Driver for Shippo
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Shippo.
-
Automated Continuous Google Spanner Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Google Spanner replication to delimited files (CSV/TSV).
-
Query IBM Informix through ODBC in Node.js
Use node-odbc to execute SQL queries against IBM Informix from Node.js.
-
Use the CData Software JDBC Driver for Kafka in MicroStrategy Web
Connect to Apache Kafka in MicroStrategy Web using the CData Software JDBC Driver for Kafka.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Tableau CRM Analytics
Provide connectivity to Tableau CRM Analytics through an SAP BusinessObjects universe.
-
Build Semantic Layer Views for MYOB AccountRight in APOS Live Data Gateway
Use the CData Connector for MYOB AccountRight in APOS Live Data Gateway to build Semantic Layer Views for MYOB AccountRight.
-
Integrating LangChain with Zoho Projects via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Zoho Projects within automated workflows.
-
Create Apps from NetSuite in Qlik Sense Cloud
Use CData Connect AI to connect to NetSuite and build apps from live NetSuite CRM & ERP in Qlik Sense Cloud.
-
How to connect to Dynamics 365 with Squirrel SQL client
Connect to Microsoft Dynamics 365 and execute queries in the Squirrel SQL Client.
-
Connect to Gmail in RapidMiner
Integrate Gmail with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to Twitter Ads from HeidiSQL
Use CData Connect AI to connect to and query live Twitter Ads from HeidiSQL.
-
Build Voice Agents in ElevenLabs with access to Live Zoho Inventory
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Zoho Inventory.
-
Build eBay Analytics-Powered Applications in Cursor with CData Code Assist MCP
-