CData Software - Knowledge Base
Recent Articles
-
Build Semantic Layer Views for GraphQL Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for GraphQL data.
-
Operational Reporting on Hacker News Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Hacker News data.
-
Integrate Phoenix with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Phoenix with External Services.
-
Visualize Unbounce Data in Sisense
Create an ElastiCube in Sisense app with access to Unbounce data.
-
Natively Connect to Recurly Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Recurly data. Leverage the native support for ODBC in PHP.
-
Work with HCL Domino Data in FoxPro
Load HCL Domino data into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to import Asana Data into Apache Solr
Use the CData Software JDBC Driver for Asana in Data Import Handler and create an automated import of Asana data to Apache Solr Enterprise Search platform.
-
How to connect to Flowlu Data from IntelliJ
Integrate connectivity to Flowlu data with wizards in IntelliJ.
-
Use Microsoft Copilot Studio to talk to your eBay 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 eBay data for you.
-
Connect to Adobe Experience Manager Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Adobe Experience Manager data.
-
How to Connect to Live Xero 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 Xero data for you.
-
How to Create Power BI Visual Reports with Real-Time Paddle Data
Use CData Power BI Connectors to visualize Paddle data in Power BI.
-
Automated Continuous Paylocity Replication to SQLite
Use CData Sync for automated, continuous, customizable Paylocity replication to SQLite.
-
Build Dashboards with Quaderno Data in Dundas BI
Create dynamic dashboards and perform analytics based on Quaderno data in Dundas BI.
-
Use Crystal Reports to create reports with Salesforce data
The CData Data Providers (JDBC, ODBC, and ADO.NET) implement standards based access to various data source which enables third party tools to interoperate. In this article we use the CData JDBC Driver for Salesforce from Crystal Reports to publish reports based on Salesforce data.
-
Getting Started with the CData ODBC Driver for Ontraport
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Ontraport.
-
Connect to Apify Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Apify data in the Denodo Virtual DataPort Administrator.
-
Connect to Pipeliner CRM Data in CloverDX (formerly CloverETL)
Transfer Pipeliner CRM data using the visual workflow in the CloverDX data integration tool.
-
Integrate SAP Business One Data in the Pentaho Report Designer
Publish reports based on SAP Business One data in the Pentaho BI tool.
-
Create Mode-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Mode Data from OutSystems and build custom enterprise apps using live Mode data.
-
Create Data Visualizations Based On MongoDB Data in Mode
Use CData Connect AI to connect to MongoDB Data from Mode and build visualizations using live MongoDB data.
-
Getting Started with the CData Excel Add-In for LightSpeedRetail
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for LightSpeedRetail.
-
Analyze Salesforce Marketing Data in Looker
Use CData Connect AI to connect to Salesforce Marketing Data from Looker and build custom apps using live Salesforce Marketing data.
-
Design BIRT Reports on ElevenLabs Data
Provide current ElevenLabs data to your embedded analytics.
-
Getting Started with the CData Excel Add-In for Zoho Projects
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Zoho Projects.
-
Connect to Real-Time Brex Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Brex data in Power Apps.
-
Automated Continuous Pipeliner CRM Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Pipeliner CRM replication to Google BigQuery.
-
Integrate Goose with Live OData Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live OData services from within the local AI agent.
-
Connect to CircleCI Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for CircleCI data in the Denodo Virtual DataPort Administrator.
-
Getting Started with the CData Excel Add-In for Cohere
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Cohere.
-
Link Jodoo with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Jodoo data in Filemaker Pro for Mac or Windows.
-
Publish Facebook-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Facebook data.
-
Automated Continuous PagerDuty Replication to AlloyDB
Use CData Sync for automated, continuous, customizable PagerDuty replication to AlloyDB.
-
Integrate Google's Antigravity Agent with Live Greenhouse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Greenhouse data using the Model Context Protocol.
-
Build Quickbase-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Quickbase data and build Quickbase-connected web apps with Axios.
-
Query ServiceDesk Plus Data in DataGrip
Create a Data Source for ServiceDesk Plus in DataGrip and use SQL to query live ServiceDesk Plus data.
-
LINQ to CouchDB 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 CouchDB Data Provider.
-
Automated Continuous Tally Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Tally data replication to OneLake in Microsoft Fabric.
-
Integrate Live XML Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to XML data and integrate live XML data into apps built in Microsoft Power Apps.
-
Getting Started with the CData Excel Add-In for Apify
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Apify.
-
JDBC Driver Getting Started Guide
A basic guide to connecting applications to data from anywhere using the CData JDBC Driver
-
Automated Continuous Amazon S3 Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Amazon S3 replication to PostgreSQL.
-
Choosing the Best Method to Connect Workable to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Workable data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Bind Live Oracle Service Cloud Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Oracle Service Cloud data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Integrate with Live Sage 200 Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Sage 200 from the MuleSoft Anypoint Platform to integrate live Sage 200 data into custom reports and dashboards.
-
Trigger SQL Server IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for SQL Server with standard wizards in Logic Apps.
-
Create Dynamic Paddle Grids Using the Infragistics XamDataGrid
Learn how you can connect Paddle to Infragistics XamDataGrid to build dynamic grids.
-
Automated Highrise Data Replication to Teradata
Use CData Sync to Customize and automate Highrise data replication to Teradata.
-
Build Agents in Relevance AI with Access to Live SAP Ariba Procurement Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on SAP Ariba Procurement data within intelligent agent workflows.
-
Build MongoDB-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live MongoDB data and build MongoDB-connected web apps with Axios.
-
Access Live QuickBooks Data in TIBCO Data Virtualization
Use the QuickBooks Tibco DV Adapter to create a QuickBooks data data source in TIBCO Data Virtualization Studio and gain access to live QuickBooks data from your TDV Server.
-
Connect Dynamics 365 Business Central Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Dynamics 365 Business Central data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to connect to Freshsales Data with Squirrel SQL client
Connect to Freshsales data and execute queries in the Squirrel SQL Client.
-
Connect to GitHub Data from AWS Glue
Use CData Connect AI to gain access to live GitHub data from your AWS Glue jobs.
-
Access Live Everhour Data in Coginiti Pro
Connect to and query live Everhour data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Create a Data Access Object for SQL Analysis Services Data using JDBI
A brief overview of creating a SQL Object API for SQL Analysis Services data in JDBI.
-
Build Dashboards with CouchDB Data in DBxtra
Create dynamic dashboards and perform analytics based on CouchDB data in DBxtra.
-
Connect to QuickBooks Online Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to QuickBooks Online.
-
Connect to Sage 300 Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Sage 300 data using standard SQL.
-
Query Live YouTube Analytics Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live YouTube Analytics data through a conversational interface.
-
DataBind Controls to SAP HANA XS Advanced Data in C++Builder
DataBind to SAP HANA XS Advanced data in C++Builder with standard components and controls.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Tally
Provide connectivity to Tally data through an SAP BusinessObjects universe.
-
Analyze SparkPost Data in Cognos Analytics
Use CData Connect AI to connect to SparkPost Data from Cognos Analytics and analyze live SparkPost data.
-
Create SparkPost Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time SparkPost data access from reports, embedded analytics, and more.
-
Build Data Flows from Google Sheets to SQL Server using SSIS
Easily back up Google Sheets data to SQL Server using the SSIS components for Google Sheets.
-
Use Databricks Agent Bricks to Talk to Your Salesforce Pardot Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Salesforce Pardot data for you.
-
Use Grok to Talk to Your SingleStore 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 SingleStore data for you.
-
Integrate Cline with Live ZohoMarketingHub Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live ZohoMarketingHub data from within your IDE.
-
Integrate Trae with Live AlloyDB Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live AlloyDB data from within the AI-powered IDE.
-
Automated Continuous NetSuite Replication to Oracle
Use CData Sync for automated, continuous, customizable NetSuite replication to Oracle.
-
Automated Continuous ZohoDesk Replication to SingleStore
Use CData Sync for automated, continuous, customizable ZohoDesk replication to SingleStore.
-
Integrating Cursor with Jumpseller 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.
-
Query Live Google Forms 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 Forms data directly from the development environment.
-
How to connect and process Freshteam data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Freshteam data.
-
Integrate Google's Vertex AI Agent with Live Guru Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Guru data within intelligent workflows.
-
Design BIRT Reports on ClickTime Data
Provide current ClickTime data to your embedded analytics.
-
Build MVC Applications with Connectivity to Helpscout Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Helpscout from an ASP.NET MVC application.
-
How to integrate Metabase with Perplexity Data
Use CData Connect AI to connect to live Perplexity data and create an interactive dashboard in Metabase from Perplexity data.
-
Use Grok to Talk to Your Toggl 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 Toggl data for you.
-
Import and Visualize Mode Data in Power View
Create data visualizations based on Mode data in Excel.
-
Connecting Mastra with Avro Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Avro data, no replication required.
-
Connect to EnterpriseDB Data from Crystal Reports
Use CData Connect AI to connect to and report on live EnterpriseDB data from Crystal Reports.
-
Use the CData Software JDBC Driver for ScrapingBee in MicroStrategy Web
Connect to ScrapingBee data in MicroStrategy Web using the CData Software JDBC Driver for ScrapingBee.
-
How to Work with AdRoll Data in AWS Glue Jobs Using JDBC
Connect to AdRoll from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automated Continuous ZohoSubscriptions Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable ZohoSubscriptions replication to Azure SQL Database.
-
Build Contentful-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Contentful data.
-
Automated Continuous Office 365 Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Office 365 replication to PostgreSQL.
-
Getting Started with the CData JDBC Driver for SAP Business Warehouse
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for SAP Business Warehouse.
-
Publish Landbot-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Landbot data.
-
Integrating LangChain with QuickBooks Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on QuickBooks data within automated workflows.
-
Use the CData ODBC Driver for Oracle Eloqua from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Oracle Eloqua to connect to Oracle Eloqua data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Oracle Eloqua data in Excel.
-
Create Spark-Connected Applications in Appsmith
Connect to Spark Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Spark data.
-
Import Pinterest Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Pinterest Data and provide access to live Pinterest data for custom reports in the Power BI Service.
-
Connect to SAP SuccessFactors LMS Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for SAP SuccessFactors LMS and the SQL Gateway to access SAP SuccessFactors LMS data from Google Apps Script.
-
Visualize AfterShip Data in TIBCO Spotfire through ADO.NET
Integrate AfterShip data into dashboards in TIBCO Spotfire.
-
How to Connect to Live Email Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Email data securely in real time.
-
How to Connect the Power BI Service to Jira Assets: Complete Guide
Connect to the CData Software Power BI Connector for Jira Assets from PowerBI.com to provide real-time Jira Assets data across the organization.
-
Model YouTube Analytics Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and YouTube Analytics, enabling the direct import of real-time YouTube Analytics data.
-
Create Google Search-Connected Applications in Appsmith
Connect to Google Search Results via CData Connect AI in Appsmith and create custom business applications with real-time access to Google Search results.
-
How to Connect to & Open Pipedrive Data in Microsoft Excel
This article uses the CData ODBC driver for Pipedrive to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.