CData Software - Knowledge Base
Recent Articles
-
How to Easily Query Elorus Data in OpenOffice Base
Connect to Elorus data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Choosing the Best Method to Connect Workday to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Workday from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Create Data Visualizations in Cognos BI with ZohoExpense Data
Access ZohoExpense as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to Access OnePageCrm Data Using Entity Framework
This article shows how to access OnePageCrm using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Access Live OneNote Data in Excel 365 Online (Excel for the web)
Connect to Microsoft OneNote from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Automate Microsoft Entra ID Data Replication to Azure Synapse
Use CData Sync to customize and automate Microsoft Entra ID replication to Azure Synapse.
-
Create SSAS Tabular Models from Xero Data
How to build a SQL Server Analysis Service Tabular Model from Xero Accounting using CData drivers.
-
Automate Aha! Data Replication to SAP HANA
Use CData Sync to customize and automate Aha! replication to SAP HANA.
-
Easily Integrate Azure DevOps Data in Lazarus Pascal IDE
Learn how to easily integrate live Azure DevOps in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to Connect to Live Oracle Sales Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Oracle Sales without replication.
-
Create Dashboards and Visualize Live Cassandra Data in Geckoboard
Use CData Connect AI to connect to live Apache Cassandra and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Create SSAS Tabular Models from Intercom Data
How to build a SQL Server Analysis Service Tabular Model from Intercom using CData drivers.
-
Getting Started with the CData Tableau Connector for Neo4J
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Neo4J.
-
Build Data Flows from SQL Server to BigCommerce through SSIS
Easily push SQL Server data to BigCommerce using the CData SSIS Tasks for BigCommerce.
-
Connect to Notion Data in CloverDX (formerly CloverETL)
Transfer Notion using the visual workflow in the CloverDX data integration tool.
-
Import Real-Time Suadeo Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Suadeo in ColdFusion.
-
Automated Continuous Highrise Replication to Oracle
Use CData Sync for automated, continuous, customizable Highrise replication to Oracle.
-
Access Live Google Forms Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Google Forms into the statistical analysis tools available in SAS JMP. This article shows how to use Google Forms in the Graph Builder and Query Builder.
-
How to import LinkedIn Ads Data into Apache Solr
Use the CData Software JDBC Driver for LinkedIn Ads in Data Import Handler and create an automated import of LinkedIn Ads to Apache Solr Enterprise Search platform.
-
Extract, Transform, and Load Zoho Recruit Data in Informatica PowerCenter
Create a simple Workflow for Zoho Recruit in Informatica PowerCenter.
-
Use the CData Software JDBC Driver for ADP in MicroStrategy Web
Connect to ADP in MicroStrategy Web using the CData Software JDBC Driver for ADP.
-
Getting Started with the CData Excel Add-In for Vault CRM
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Vault CRM.
-
Integrating Boomi Agentstudio with Office 365 Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Microsoft Office 365, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Integrate with Hacker News Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Hacker News to a JSON file on disk.
-
Feed QuickBooks Online Data into FineReport
How to set QuickBooks Online as a JDBC data source in FineReport.
-
Integrate Live Neo4J Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Neo4J and integrate live Neo4J into apps built in Microsoft Power Apps.
-
Query, Visualize, and Share live MailChimp Data in Redash
Use CData Connect AI to connect to live MailChimp in Redash for querying, visualizing, and sharing.
-
Automate Act CRM Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Act CRM and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Automated Continuous JSON Replication to Oracle
Use CData Sync for automated, continuous, customizable JSON replication to Oracle.
-
Using the CData Software ODBC Driver for ClickUp in PyCharm
Connect to ClickUp as an ODBC data source in PyCharm using the CData Software ODBC Driver for ClickUp.
-
Connect to BigQuery Data from PowerBuilder via ADO.NET
This article demonstrates how to access Google BigQuery from Appeon PowerBuilder using the CData ADO.NET Provider for BigQuery.
-
Connect to AlloyDB Data from a Connection Pool in JBoss
Integrate Google AlloyDB into Java servlets: Use the Management Console in JBoss to install the AlloyDB JDBC Driver.
-
Connect to Intercom Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Intercom as an External Source in Dremio.
-
Validate Intercom Data with QuerySurge
Access and validate Intercom in QuerySurge using the CData JDBC Driver.
-
Connect to Suadeo Data in NetBeans
Connect to Suadeo in NetBeans with the data source configuration wizard.
-
Automate QuickBooks Data Replication to Azure Data Lake
Use CData Sync to customize and automate QuickBooks Desktop replication to Azure Data Lake.
-
Automated Continuous Act CRM Replication to Snowflake
Use CData Sync for automated, continuous, customizable Act CRM replication to Snowflake.
-
How to Connect DBeaver to Coinbase via a JDBC Driver
Manage Coinbase with visual tools in DBeaver like the query browser.
-
Connect to Postmark Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Postmark in the Denodo Virtual DataPort Administrator.
-
Use the CData Software JDBC Driver for FormSite in MicroStrategy
Connect to FormSite in MicroStrategy Developer using the CData Software JDBC Driver for FormSite.
-
Getting Started with the CData Power BI Connector for xBase
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for xBase.
-
Connect to Adobe Target Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Adobe Target.
-
Access Live SendGrid 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 SendGrid through MCP integration.
-
Access Live CSV Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to CSV/TSV Files from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Getting Started with the CData Tableau Connector for Access
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Access.
-
Connect to RSS Feeds in DBeaver
Use the CData ODBC Driver to connect to RSS Feeds in DBeaver.
-
Automated Continuous HubSpot Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable HubSpot replication to OneLake in Microsoft Fabric.
-
How to Connect to Bullhorn CRM Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Bullhorn CRM. Leverage the pyodbc module for ODBC in Python.
-
Visualize Live Bannerbear Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Bannerbear using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Use the CData Software ODBC Driver for Jumpseller in SAS for Real-Time Reporting and Analytics
Connect to real-time Jumpseller in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Jumpseller.
-
Import Real-Time JSON Services via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use JSON in ColdFusion.
-
Build Acumatica-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Acumatica to explore live Acumatica Data in Claude Code to assist with building Acumatica-powered applications.
-
Query Live Google Calendar Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Google Calendar directly from the development environment.
-
Create Adobe Analytics-Connected Applications in Appsmith
Connect to Adobe Analytics Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Adobe Analytics.
-
How to Connect to Live Salesforce CRM Analytics 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 Salesforce CRM Analytics for you.
-
Connect to and Query Freshteam Data in QlikView over ODBC
Create data visualizations with Freshteam in QlikView.
-
How to load Google Forms data into Elasticsearch via Logstash
Introducing a simple method to load Google Forms data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Use the CData Software ODBC Driver for SAS xpt in SAS for Real-Time Reporting and Analytics
Connect to real-time SAS XPORT in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for SAS xpt.
-
Access Cassandra Data from MySQL in PHP
Connect to Cassandra through the standard MySQL libraries in PHP.
-
Create Power BI Reports on Real-Time Impala Data
Use the CData ODBC Driver for Impala to visualize Apache Impala in Power BI Desktop.
-
Connect to ServiceNow Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for ServiceNow and the Script function in FileMaker Pro to connect to ServiceNow and work with ServiceNow in your FileMaker application.
-
Connect to Avalara AvaTax Data in ACL Analytics
Connect to Avalara AvaTax via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Avalara AvaTax.
-
Integrating Kiro CLI with GetResponse 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.
-
Build a Simple VCL Application for YouTube Analytics Data
How to build a simple VCL Application to view YouTube Analytics in RAD Studio using the CData ODBC Driver for YouTube Analytics.
-
Connecting Pipedream with FHIR Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on FHIR data in real time.
-
Connect to Oracle Service Cloud Data from PowerBuilder via ADO.NET
This article demonstrates how to access Oracle Service Cloud from Appeon PowerBuilder using the CData ADO.NET Provider for Oracle Service Cloud.
-
Build a Singer.io Tap for Clari With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Clari data using
-
How to Connect to Live GitLab Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live GitLab securely in real time.
-
How to Connect Flowise AI Agents to Live Sage Cloud Accounting Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Sage Business Cloud Accounting without replication.
-
Integrating Cursor CLI with SAP Ariba Procurement 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.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed YouTube Analytics to Power BI dashboards. Simply drag and drop YouTube Analytics into data visuals on the Power BI canvas.
-
Analyze Apollo Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Apollo and visualize live Apollo in Infragistics Reveal.
-
How to load Facebook Ads data into Elasticsearch via Logstash
Introducing a simple method to load Facebook Ads data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to Work with Airtable Data in ETL Validator JDBC
Connect to Airtable from ETL Validator jobs using the CData Software JDBC Driver.
-
Automated Continuous SAP SuccessFactors Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable SAP SuccessFactors replication to OneLake in Microsoft Fabric.
-
Integrate Cosmos DB Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Azure Cosmos DB and integrate live Azure Cosmos DB into your Power Automate tasks.
-
Connect to QuickBooks Online Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for QuickBooks Online and the SQL Gateway to access QuickBooks Online from Google Apps Script.
-
Use Biml to Build SSIS Tasks to Replicate Unbounce Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Unbounce to SQL Server.
-
Integrate Azure Data Catalog Data in the Pentaho Report Designer
Publish reports based on Azure Data Catalog in the Pentaho BI tool.
-
Automated Continuous AfterShip Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable AfterShip replication to delimited files (CSV/TSV).
-
Visualize Live Elorus Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Elorus using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Visualize GetResponse Data in TIBCO Spotfire through ADO.NET
Integrate GetResponse into dashboards in TIBCO Spotfire.
-
Query Live Google Contacts Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Google Contacts directly from the development environment.
-
Build Dashboards with Samanage Data in DBxtra
Create dynamic dashboards and perform analytics based on Samanage in DBxtra.
-
Create SSAS Tabular Models from iContact Data
How to build a SQL Server Analysis Service Tabular Model from iContact using CData drivers.
-
How to Seamlessly Import Google Translate Data into IBM SPSS Modeler
Integrate Google Translate data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to GetResponse Data in NetBeans
Connect to GetResponse in NetBeans with the data source configuration wizard.
-
Egnyte Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Egnyte facts in real time.
-
Connect to Quickbase Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Quickbase from Filemaker Pro on Mac.
-
Use Databricks Agent Bricks to Talk to Your ServiceNow Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your ServiceNow for you.
-
Integrate LibreChat with Live Sage 200 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Sage 200 from within the chat interface.
-
Getting Started with the CData Tableau Connector for PagerDuty
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Connect to and Visualize Live Webex Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Webex.
-
Use the CData Software JDBC Driver for Figshare in MicroStrategy
Connect to Figshare in MicroStrategy Developer using the CData Software JDBC Driver for Figshare.
-
Publish Reports with HubSpot Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date HubSpot.
-
Build a PostgreSQL Interface for Mocean Data using the CData JDBC Driver
Use the Remoting features of the Mocean JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automate SAP Ariba Source Data Replication to SAP HANA
Use CData Sync to customize and automate SAP Ariba Source replication to SAP HANA.
-
Automated Continuous ConvertKit Replication to Vertica
Use CData Sync for automated, continuous, customizable ConvertKit replication to Vertica.
-
Automate HubSpot Data Replication to SAP HANA
Use CData Sync to customize and automate HubSpot replication to SAP HANA.
-
Connect to Sugar CRM Data in HULFT Integrate
Connect to Sugar CRM as a JDBC data source in HULFT Integrate