CData Software - Knowledge Base
Recent Articles
-
Access Live Reckon in Coginiti Pro
Connect to and query live Reckon from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Analyze ActiveCampaign in Looker
Use CData Connect AI to connect to ActiveCampaign from Looker and build custom apps using live ActiveCampaign.
-
How to connect PolyBase to Teradata
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Teradata.
-
Analyze Dynamics 365 Business Central in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Dynamics 365 Business Central in Microsoft R Open.
-
How to Create Power BI Visual Reports with Real-Time HubSpot
Use CData Power BI Connectors to visualize HubSpot in Power BI.
-
Import Adobe Commerce Using Azure Data Factory
Use CData Connect AI to connect to Adobe Commerce from Azure Data Factory and import live Adobe Commerce.
-
Integrate Live SAP ByDesign into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to SAP ByDesign from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live SAP Business ByDesign.
-
Query Confluence using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Confluence entities in PHP by modeling them as objects.
-
Use ChatGPT to Talk to Your Redshift via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Amazon Redshift for you.
-
Build Apps with Live Smartsheet in Adalo using CData Connect AI
Use CData Connect AI to integrate live Smartsheet into the Adalo platform and build custom mobile and web applications with real-time Smartsheet.
-
Use the CData Software ODBC Driver for Adobe Analytics in SAS for Real-Time Reporting and Analytics
Connect to real-time Adobe Analytics in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Adobe Analytics.
-
Connecting Mastra with Confluence 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 data across hundreds of enterprise sources no replication required.
-
Query Salesforce in DataGrip
Create a Data Source for Salesforce in DataGrip and use SQL to query live Salesforce & Force.com.
-
Add HarperDB to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for HarperDB with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to connect to Acumatica from IntelliJ
Integrate connectivity to Acumatica ERP with wizards in IntelliJ.
-
Easily Integrate Tableau CRM Analytics in Lazarus Pascal IDE
Learn how to easily integrate live Tableau CRM Analytics in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to Query Live Dynamics NAV in Claude Desktop
Connect to and query live Dynamics NAV in Claude Desktop using CData Code Assist MCP.
-
Analyze SharePoint in Infragistics Reveal
Use the CData API Server to create an OData API on top of Microsoft SharePoint and visualize live Microsoft SharePoint in Infragistics Reveal.
-
Create API-Connected Applications in Appsmith
Connect to API via CData Connect AI in Appsmith and create custom business applications with real-time access to API.
-
How to connect Amazon QuickSight to Google Contacts
Create a connection to Google Contacts in CData Connect AI and insert Google Contacts into Amazon QuickSight SPICE to build interactive dashboards.
-
Build an OLAP Cube in SSAS from MYOB AccountRight
Establish a connection to MYOB AccountRight data from SQL Server Analysis Services, and use the MYOB AccountRight Data Provider to build OLAP cubes for use in analytics and reporting.
-
Build a PostgreSQL Interface for PostgreSQL using the CData JDBC Driver
Use the Remoting features of the PostgreSQL JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to QuickBooks Online in the Denodo Platform
Use CData driver technologies to create a virtual data source for QuickBooks Online in the Denodo Virtual DataPort Administrator.
-
Connect to Live MYOB AccountRight in MicroStrategy through CData Connect AI
Create a live connection to MYOB AccountRight in CData Connect AI and connect to your MYOB AccountRight from MicroStrategy.
-
Connect to Act CRM from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Act CRM, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Access Live Epicor Kinetic in AWS Lambda
Connect to live Epicor Kinetic in AWS Lambda using the CData JDBC Driver.
-
Replicate SAP Concur to Multiple Databases via the CData Sync CLI
Replicate SAP Concur to disparate databases with a single configuration.
-
How to create an RPA flow for Zoho Creator in UiPath Studio
Use the Zoho Creator ODBC Driver to create workflows that access real-time Zoho Creator without any coding.
-
Access Live API in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live API from your Excel spreadsheets.
-
Build Charts with WooCommerce in Clear Analytics
Create dynamic charts and perform analytics based on WooCommerce in Clear Analytics.
-
Using the CData Software ODBC Driver for Google Analytics in PyCharm
Connect to Google Analytics as an ODBC data source in PyCharm using the CData Software ODBC Driver for Google Analytics.
-
Build MVC Applications with Connectivity to Epicor Kinetic
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Epicor Kinetic from an ASP.NET MVC application.
-
Replicate Multiple Drip Accounts via the CData Sync CLI
Replicate multiple Drip accounts to one or many databases.
-
Visualize Epicor Kinetic in TIBCO Spotfire through OData
Integrate Epicor Kinetic into dashboards in TIBCO Spotfire.
-
Visualize Salesforce in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Salesforce & Force.com into TIBCO Spotfire.
-
Build xBase-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live xBase.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Google Ad Manager
Provide connectivity to Google Ad Manager through an SAP BusinessObjects universe.
-
Automated Continuous Klipfolio Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Klipfolio replication to PostgreSQL.
-
Use the CData Software JDBC Driver for Oracle HCM Cloud in MicroStrategy Desktop
Connect to Oracle HCM Cloud in MicroStrategy Desktop using the CData Software JDBC Driver for Oracle HCM Cloud.
-
Build a PostgreSQL Interface for MariaDB using the CData JDBC Driver
Use the Remoting features of the MariaDB JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Salesforce Marketing Replication to Vertica
Use CData Sync for automated, continuous, customizable Salesforce Marketing replication to Vertica.
-
Use Grok to Talk to Your Lakebase 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 Lakebase for you.
-
Use the CData Software ODBC Driver for SAS xpt in MicroStrategy
Connect to SAS XPORT in MicroStrategy Developer using the CData Software ODBC Driver for SAS xpt.
-
Create Adobe Analytics-Connected Applications in Appsmith
Connect to Adobe Analytics via CData Connect AI in Appsmith and create custom business applications with real-time access to Adobe Analytics.
-
Getting Started with the CData Excel Add-In for FHIR
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for FHIR.
-
Add Microsoft Exchange to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Microsoft Exchange with the Informatica Enterprise Data Catalog to classify and organize data.
-
DataBind Controls to Zuora in C++Builder
DataBind to Zuora in C++Builder with standard components and controls.
-
Build Automated LinkedIn Ads-Connected Workflows in Zapier
Use CData Connect AI to connect to live LinkedIn Ads and build automated workflows in Zapier.
-
Integrate Facebook Ads into Power Automate Desktop using CData Connect
CData Connect for Facebook Ads enables you to integrate Facebook Ads into workflows built using Microsoft Power Automate Desktop.
-
Connect to Square from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Square from Filemaker Pro on Mac.
-
Analyze Paylocity in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Paylocity and visualize the live in Slingshot (formerly Reveal BI) for seamless insights.
-
Connect to Bing Ads in Jaspersoft Studio
Execute SQL to remote Bing Ads in Jaspersoft Studio.
-
How to Connect to Live Azure Synapse 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 Azure Synapse without replication.
-
Natively Connect to Azure Analysis Services in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Azure Analysis Services. Leverage the native support for ODBC in PHP.
-
Automate SAP Business One Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live SAP Business One and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Connect to MYOB AccountRight in ACL Analytics
Connect to MYOB AccountRight via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to MYOB AccountRight.
-
Integrating Claude Code with Trello via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Trello within assisted coding and automated development workflows.
-
Connect to Oracle Service Cloud in SpagoBI
Create reports featuring live Oracle Service Cloud in SpagoBI Studio. Host Oracle Service Cloud reports on SpagoBI Server.
-
Operational Reporting on Redshift from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Amazon Redshift.
-
How to Connect the Power BI Service to Twilio: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
How to connect PolyBase to Invoiced
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Invoiced.
-
Provide OData Services of SAP HANA from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for SAP HANA by developing a WCF Service Application.
-
Create Adobe Analytics Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
Add Procore to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Procore with the Informatica Enterprise Data Catalog to classify and organize data.
-
Use CData Connect AI to Access Amazon Marketplace in Microsoft Power Pivot
Use CData Connect AI to connect to live Amazon Marketplace in the Power Pivot business intelligence tool.
-
Automated Continuous OData Replication to Databricks
Use CData Sync for automated, continuous, customizable OData replication to Databricks.
-
Design BIRT Reports on Act-On
Provide current Act-On to your embedded analytics.
-
How to Visualize Cloudant Data in Python with pandas
Use pandas and other modules to analyze and visualize live IBM Cloudant in Python.
-
How to Query Microsoft Planner in MySQL Workbench
Execute MySQL queries against live Microsoft Planner from MySQL Workbench.
-
Automated Continuous Calendly Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Calendly replication to Amazon S3.
-
Connect to Asana as an External Source in Dremio
Use the CData JDBC Driver to connect to Asana as an External Source in Dremio.
-
Configure the CData JDBC Driver for HBase in a Connection Pool in Tomcat
Connect to Apache HBase from a connection pool in Tomcat.
-
Connect to OData Services in Claris FileMaker Pro
-