CData Software - Knowledge Base
Recent Articles
-
Build Voice Agents in ElevenLabs with access to Live Kintone
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Kintone.
-
Access Live Redshift in Excel 365 Online (Excel for the web)
Connect to Amazon Redshift from Excel 365 Online (Excel for the web) with CData Connect AI.
-
How to connect to Dynamics CRM from IntelliJ
Integrate connectivity to Microsoft Dynamics CRM with wizards in IntelliJ.
-
Visualize Act CRM from Tableau
Use the Tableau Desktop business intelligence tool to connect to Act CRM.
-
Build Semantic Layer Views for Bullhorn CRM in APOS Live Data Gateway
Use the CData Connector for Bullhorn CRM in APOS Live Data Gateway to build Semantic Layer Views for Bullhorn CRM.
-
Visualize Drip in Tableau
The CData ODBC driver for Drip enables you integrate Drip into Tableau dashboards.
-
How to Create Power BI Visual Reports with Real-Time Redis
Use CData Power BI Connectors to visualize Redis in Power BI.
-
Connecting Mastra with NetSuite 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 300+ enterprise sources no replication required.
-
Analyze DocuSign with Power Pivot
This article walks you through the process of using the CData ODBC Driver for DocuSign from Power Pivot. You will use the Table Import Wizard to load DocuSign. You can visually build the import query or use any SQL supported by the driver.
-
Working with AlloyDB in LINQPad
Execute LINQ queries to Google AlloyDB in LINQPad.
-
Bidirectional Access to Typeform from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Typeform in Filemaker Pro for Mac or Windows.
-
View Reports on Real-Time Workday in Power BI Report Server
Use the CData ODBC Driver for Workday to visualize Workday in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to SingleStore in ACL Analytics
Connect to SingleStore via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to SingleStore.
-
Integrate with live Microsoft Exchange in Jitterbit
Use CData Connect AI to connect to and integrate live Microsoft Exchange in Jitterbit.
-
Access HubSpot from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live HubSpot from HeidiSQL.
-
Working with Clio in LINQPad
Execute LINQ queries to Clio in LINQPad.
-
Rapidly Develop Xero-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.
-
Use the CData ODBC Driver for ClickUp from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for ClickUp to connect to ClickUp from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring ClickUp in Excel.
-
How to Build an ETL App for Pipedrive in Python with CData
Create ETL applications and real-time data pipelines for Pipedrive in Python with petl.
-
Choosing the Best Method to Connect Bullhorn CRM to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Bullhorn CRM from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
DataBind Controls to Clio in C++Builder
DataBind to Clio in C++Builder with standard components and controls.
-
Publish Crystal Reports on Raisers Edge NXT
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Raisers Edge NXT.
-
Access Google Ad Manager from MySQL in Amazon QuickSight
Connect to Google Ad Manager and build visualizations of Google Ad Manager using a MySQL Connection in Amazon QuickSight.
-
Feed ServiceNow into FineReport
How to set ServiceNow as a JDBC data source in FineReport.
-
Extract, Transform, and Load Azure Synapse in Informatica PowerCenter
Create a simple Workflow for Azure Synapse in Informatica PowerCenter.
-
Build SAP HANA Visualizations in Tableau Cloud
Use CData Connect AI to connect to live SAP HANA and build visualizations in Tableau Cloud.
-
Create Datasets from Phoenix in Domo Workbench and Build Visualizations of Phoenix in Domo
Use the CData Software ODBC Driver for Phoenix to create datasets from Apache Phoenix in Domo Workbench and then build visualizations in the Domo service.
-
Stream Jira Assets into Apache Kafka Topics
Access and stream Jira Assets in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Import and Visualize Jira in Power View
Create data visualizations based on Atlassian Jira in Excel.
-
How to Connect to Live Google Drive 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 Google Drive for you.
-
Access CouchDB from MySQL in PHP
Connect to CouchDB through the standard MySQL libraries in PHP.
-
DataBind Google Sheets to the DevExpress Data Grid
Use the CData Software ADO.NET Provider for Google Sheets with the DevExpress Windows Forms and Web controls to provide Google Sheets to a chart.
-
Connect to FTP from a Connection Pool in JBoss
Integrate FTP Servers into Java servlets: Use the Management Console in JBoss to install the FTP JDBC Driver.
-
Build YouTube Analytics Visualizations in Tableau Cloud
Use CData Connect AI to connect to live YouTube Analytics and build visualizations in Tableau Cloud.
-
Build Agents in Relevance AI with Access to Live Google Spanner via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Google Spanner within intelligent agent workflows.
-
Integrate FTP in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live FTP Servers from Informatica Cloud.
-
Connect to ShipStation from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from ShipStation, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Build Automated Workflows with Live Dynamics 365 Business Central in Workato
Use CData Connect AI to connect to live Dynamics 365 Business Central and build automated workflows in Workato.
-
Build Odoo-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Odoo from Zoho Analytics and import live Odoo ERP.
-
Automated Continuous Vertica Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Vertica replication to Azure SQL Database.
-
Access Reckon Accounts Hosted in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Reckon Accounts Hosted.
-
Integrate Power BI XMLA in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Power BI XMLA from Informatica Cloud.
-
Build Visualizations of Sage 300 in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Sage 300 in Birst.
-
How to integrate HarperDB with Apache Airflow
Access and process HarperDB in Apache Airflow using the CData JDBC Driver.
-
Getting Started with the CData PowerShell Cmdlets for OData Services
-