CData Software - Knowledge Base
Recent Articles
-
How to Query Live QuickBooks Time Data in Claude Desktop
Connect to and query live QuickBooks Time Data in Claude Desktop using CData MCP Server.
-
Import Real-Time Unbounce Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Unbounce in ColdFusion.
-
View Reports on Real-Time Salesforce Data 360 Data in Power BI Report Server
Use the CData ODBC Driver for Salesforce Data 360 to visualize Salesforce Data 360 in Power BI Desktop and then publish them to Power BI Report Server.
-
Import Real-Time Wave Financial Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Wave Financial in ColdFusion.
-
Access Live SendPulse Data in AWS Lambda
Connect to live SendPulse in AWS Lambda using the CData JDBC Driver.
-
Build Delighted-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Delighted and build web apps with connectivity to live Delighted.
-
Create Datasets from Parquet in Domo Workbench and Build Visualizations of Parquet Data in Domo
Use the CData Software ODBC Driver for Parquet to create datasets from Apache Parquet in Domo Workbench and then build visualizations in the Domo service.
-
Connect to Oracle SCM Data in RazorSQL
Connect to Oracle SCM from wizards and query Oracle SCM from the GUI in the RazorSQL database management tool.
-
Build Dashboards with PhantomBuster Data in DBxtra
Create dynamic dashboards and perform analytics based on PhantomBuster in DBxtra.
-
Access REST Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access REST from your Oracle system.
-
Connect to Pipedrive 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 Pipedrive.
-
How to Create Power BI Visual Reports with Real-Time Jira Assets Data
Use CData Power BI Connectors to visualize Jira Assets in Power BI.
-
Create SSAS Tabular Models from SAP Data
How to build a SQL Server Analysis Service Tabular Model from SAP ERP/NetWeaver using CData drivers.
-
Getting Started with the CData ADO.NET Provider for Flowlu
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Connect to GraphQL Data in Claris FileMaker Pro
Use the CData ODBC Driver for GraphQL in FileMaker Pro to connect to GraphQL and work with GraphQL in your FileMaker applications.
-
Use the CData Software JDBC Driver for OData in MicroStrategy Desktop
Connect to OData in MicroStrategy Desktop using the CData Software JDBC Driver for OData.
-
Natively Connect to OData Services in PHP
The CData ODBC driver for OData enables you to create PHP applications with connectivity to OData. Leverage the native support for ODBC in PHP.
-
Databricks Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Databricks facts in real time.
-
Design BIRT Reports on Anaplan Data
Provide current Anaplan to your embedded analytics.
-
Connect to Everhour Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Everhour to connect to Everhour and execute queries in PowerBuilder.
-
How to connect PolyBase to Zoho CRM
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Zoho CRM.
-
Integrate Live Act CRM Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Act CRM to Blue Prism using the CData ODBC Driver for Act CRM to create automated workflows for repetitive business tasks.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Bannerbear
Provide connectivity to Bannerbear through an SAP BusinessObjects universe.
-
Connect to Google Sheets Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Google Sheets using standard SQL.
-
Access Live Reply.io Data in AWS Lambda
Connect to live Reply.io in AWS Lambda using the CData JDBC Driver.
-
Getting Started with the CData SSIS Components for Acumatica
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Acumatica.
-
How to Use a Microsoft Access Database to Update MariaDB Data in Real Time
Update MariaDB data by creating a linked table in Microsoft Access with the CData MariaDB ODBC Driver.
-
Automate Google Search Results Replication to SAP HANA
Use CData Sync to customize and automate Google Search replication to SAP HANA.
-
How to work with DocuSign Data in Apache Spark using SQL
Access and process DocuSign Data in Apache Spark using the CData Software JDBC Driver.
-
Analyze SQL Analysis Services Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of SQL Analysis Services and visualize live SQL Analysis Services in Infragistics Reveal.
-
Import SurveyMonkey Data Using Azure Data Factory
Use CData Connect AI to connect to SurveyMonkey Data from Azure Data Factory and import live SurveyMonkey.
-
Build Automated Lakebase-Connected Workflows in Zapier
Use CData Connect AI to connect to live Lakebase and build automated workflows in Zapier.
-
A PostgreSQL Interface for VWO Data (MySQL Remoting via JDBC)
Use the Remoting features of the VWO JDBC Driver to create a PostgreSQL entry-point for data access.
-
Getting Started with the CData Python Connector for REST
Learn to install and license the CData Python Connector
-
Create Facebook Ads-Connected Applications in Appsmith
Connect to Facebook Ads Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Facebook Ads.
-
How to Access Live Onfleet Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Onfleet enables you to integrate Onfleet into workflows built using Microsoft Power Automate Desktop.
-
Connect to Microsoft OneDrive from Asprova with CData Software ODBC Driver for Microsoft OneDrive
This article shows how to connect faster to Microsoft OneDrive data from Asprova.
-
Add Cvent Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Cvent with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to CouchDB Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Apache CouchDB using standard SQL.
-
Automated Continuous Microsoft Entra ID Replication to Snowflake
Use CData Sync for automated, continuous, customizable Microsoft Entra ID replication to Snowflake.
-
Automated Continuous ChargeOver Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable ChargeOver replication to PostgreSQL.
-
DataBind Controls to WooCommerce Data in Delphi
DataBind to WooCommerce in Delphi with standard data access components and controls.
-
Automated Continuous SAP Business One Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable SAP Business One replication to OneLake in Microsoft Fabric.
-
Build AI/ML Models with Live CockroachDB Data using Dataiku
Connect CockroachDB Data with Dataiku using the CData JDBC Driver for CockroachDB.
-
Getting Started with the CData Power BI Connector for SAP
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for SAP.
-
Automate BigQuery Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Google BigQuery from PowerShell? This article demonstrates how to utilize the BigQuery Cmdlets for tasks like connecting to Google BigQuery, automating operations, downloading data, and more.
-
Use Grok to Talk to Your FTP 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 FTP Servers for you.
-
Use Biml to Build SSIS Tasks to Replicate Notion Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Notion to SQL Server.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Sage Intacct
Provide connectivity to Sage Intacct through an SAP BusinessObjects universe.
-
Use the CData ODBC Driver for XML from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for XML to connect to XML Files from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring XML Files in Excel.
-
Integrate with Sendwithus Data in JReport Designer
Create charts and reports based on Sendwithus in JReport Designer.
-
Connect to CouchDB Data from a Connection Pool in Jetty
The CouchDB JDBC Driver supports connection pooling: This article shows how to connect faster to Apache CouchDB from Web apps in Jetty.
-
Replicate Figshare Data from PowerShell
Write a quick PowerShell script to query Figshare. Use connectivity to the live data to replicate Figshare to SQL Server.
-
How to Connect to Live Klaviyo 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 Klaviyo for you.
-
Getting Started with the CData Tableau Connector for Google Analytics
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Google Analytics.
-
How to connect to PagerDuty Data with Squirrel SQL client
Connect to PagerDuty and execute queries in the Squirrel SQL Client.
-
How to Connect to Live Salesforce Marketing Data 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 Salesforce Marketing Cloud for you.
-
Integrate Live ConvertKit Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live ConvertKit to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Integrate Live FTP Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Create Data Visualizations in Cognos BI with Vimeo Data
Access Vimeo as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Create Datasets from Oracle in Domo Workbench and Build Visualizations of Oracle Data in Domo
Use the CData Software ODBC Driver for Oracle to create datasets from Oracle Database in Domo Workbench and then build visualizations in the Domo service.
-
Getting Started with the CData JDBC Driver for Cvent
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Cvent.
-
Create Reports with Todoist Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Todoist.
-
Getting Started with the CData Python Connector for Marketo
Learn to install and license the CData Python Connector
-
Establish a Live Connection with AdRoll Data using Tableau Bridge
The CData ODBC Driver for AdRoll enables you to integrate live AdRoll into Tableau Cloud dashboards using the Tableau Bridge.
-
Publish Placid-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Placid.
-
Easily Integrate ZohoPeople Data in Lazarus Pascal IDE
Learn how to easily integrate live ZohoPeople in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Build Voice Agents in ElevenLabs with access to Live OData Services
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live OData.
-
Create Apps from Office 365 Data in Qlik Sense Cloud
Use CData Connect AI to connect to Office 365 Data and build apps from live Microsoft Office 365 in Qlik Sense Cloud.
-
Build Agents in Relevance AI with Access to Live Adobe Commerce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Adobe Commerce within intelligent agent workflows.
-
Operational Reporting on Microsoft Exchange Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Microsoft Exchange.
-
Create Informatica Mappings From/To an ODBC Data Source for Landbot
Create an ODBC connection to Landbot in Informatica and browse and transfer Landbot.
-
Use the CData ODBC Driver for Bannerbear in Microsoft Power Query
You can use the CData Bannerbear ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Bannerbear into Microsoft Power Query.
-
Getting Started with the CData Python Connector for SAP HANA
Learn to install and license the CData Python Connector
-
Deploy the ADO.NET Provider for Square on an SSRS Report Server
Connect to Square 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.
-
Automate Databricks Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Databricks and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Connect to SQL Server Data in Jaspersoft Studio
Execute SQL to remote Microsoft SQL Server in Jaspersoft Studio.
-
Connect to MailChimp Data from PowerBuilder via JDBC
This article demonstrates how to access MailChimp from PowerBuilder using the MailChimp JDBC Driver.
-
Bidirectional Access to SharePoint Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Microsoft SharePoint in Filemaker Pro for Mac or Windows.
-
How to Connect to Live Quickbase 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 Quickbase for you.
-
Use Biml to Build SSIS Tasks to Replicate Demio Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Demio to SQL Server.
-
Automated Continuous ADP Replication to Vertica
Use CData Sync for automated, continuous, customizable ADP replication to Vertica.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Amazon Athena actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Analyze Snowflake Data in Cognos Analytics
Use CData Connect AI to connect to Snowflake Data from Cognos Analytics and analyze live Snowflake.
-
Build MVC Applications with Connectivity to Azure Data Catalog Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Azure Data Catalog from an ASP.NET MVC application.
-
Integrating OpenCode Terminal with Sugar CRM 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.
-
Analyze Salesforce Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Salesforce & Force.com and visualize live Salesforce & Force.com in Infragistics Reveal.
-
Automated Continuous Sybase Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Sybase replication to Apache Kafka.
-
Create a Data Access Object for Dynamics CRM Data using JDBI
A brief overview of creating a SQL Object API for Microsoft Dynamics CRM in JDBI.
-
Integrate with live Impala Data in Jitterbit
Use CData Connect AI to connect to and integrate live Apache Impala in Jitterbit.
-
Automated Continuous ZohoPeople Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable ZohoPeople replication to Amazon Redshift.
-
Use ChatGPT to Talk to Your Shopify Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Shopify for you.
-
Migrating data from Cvent to Databricks using CData SSIS Components.
Easily push Cvent to Databricks using the CData SSIS Tasks for Cvent and Databricks.
-
Choosing the Best Method to Connect Cassandra to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Apache Cassandra from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to integrate BambooHR with Apache Airflow
Access and process BambooHR in Apache Airflow using the CData JDBC Driver.
-
Integrate LibreChat with Live Google Campaign Manager 360 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Google Campaign Manager 360 from within the chat interface.
-
Query FTP Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume FTP entities in PHP by modeling them as objects.
-
Getting Started with the CData Tableau Connector for Active Directory
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Active Directory.
-
How to Connect Certinia Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Certinia data in real time using natural language.
-
Integrate Dropbox Data in Pentaho Data Integration
Build ETL pipelines based on Dropbox in the Pentaho Data Integration tool.