CData Software - Knowledge Base
Recent Articles
-
Use the CData Software JDBC Driver for Azure Data Catalog in MicroStrategy Web
Connect to Azure Data Catalog data in MicroStrategy Web using the CData Software JDBC Driver for Azure Data Catalog.
-
Explore Geographical Relationships in Google Directory Data with Power Map
Create data visualizations with Google Directory data in Power Map.
-
Integrating Cursor with Neo4J 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.
-
Automate Box Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Box data from PowerShell? This article demonstrates how to utilize the Box Cmdlets for tasks like connecting to Box data, automating operations, downloading data, and more.
-
Consume Azure DevOps OData Feeds in PowerBuilder
This article demonstrates how to consume Azure DevOps data as OData feeds from PowerBuilder using the API Server.
-
Build Data Flows from Okta to SQL Server using SSIS
Easily back up Okta data to SQL Server using the SSIS components for Okta.
-
Integrating Kiro with ZohoMarketingHub 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.
-
Automated Continuous Instantly Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Instantly replication to PostgreSQL.
-
Getting Started with the CData Connect AI Python SDK for MYOB AccountRight
Install the CData Connect AI Python SDK to read and write live MYOB AccountRight data with standard DB-API 2.0 Python code.
-
Integrate Goose with Live SendGrid Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live SendGrid data from within the local AI agent.
-
DataBind Controls to Deel Data in Delphi
DataBind to Deel data in Delphi with standard data access components and controls.
-
Use Biml to Build SSIS Tasks to Replicate Aircall Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Aircall data to SQL Server.
-
How to Visualize Timely Data in Python with pandas
Use pandas and other modules to analyze and visualize live Timely data in Python.
-
Use Azure AI Foundry to Talk to Your SAP Netweaver Gateway Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your SAP Netweaver Gateway data for you.
-
Connect to ServiceDesk Plus Data from PowerBuilder via JDBC
This article demonstrates how to access ServiceDesk Plus data from PowerBuilder using the ServiceDesk Plus JDBC Driver.
-
DataBind FreshBooks Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide FreshBooks data to a chart.
-
Connect to Google Search Results in RapidMiner
Integrate Google Search results with standard components and data source configuration wizards in RapidMiner Studio.
-
Connecting Agentforce with Hive Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Hive data for you.
-
Connect to Vimeo Data in DBArtisan
Use wizards in DBArtisan to configure Vimeo data as a data source.
-
Visualize FreshBooks Data in Sisense
Create an ElastiCube in Sisense app with access to FreshBooks data.
-
Integrate with live Outreach.io Data in Jitterbit
Use CData Connect AI to connect to and integrate live Outreach.io data in Jitterbit.
-
Connect to Sage 300 Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Sage 300 data in Airbyte.
-
How to Connect to Live QuickBooks Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your QuickBooks data through natural language.
-
How to connect to Highrise Data in DBVisualizer
Integrate Highrise data with visual data analysis tools and data connection wizards in DBVisualizer
-
Analyze Zoho Creator Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Zoho Creator from Power Pivot. You will use the Table Import Wizard to load Zoho Creator data. You can visually build the import query or use any SQL supported by the driver.
-
Provide OData Services of Authorize.Net Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Authorize.Net data by developing a WCF Service Application.
-
Automated Continuous ServiceNow Replication to SQLite
Use CData Sync for automated, continuous, customizable ServiceNow replication to SQLite.
-
Getting Started with the CData Python Connector for Google Search
Learn to install and license the CData Python Connector and configure a connection to live Google Search results.
-
How to connect and process Quaderno data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Quaderno data.
-
Integrate Google's Antigravity Agent with Live QuickBooks Time Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live QuickBooks Time data using the Model Context Protocol.
-
Integrating GitHub Copilot with TigerGraph 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.
-
How to create Twitter Ads federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Twitter Ads data in MySQL .
-
How to Easily Query BenchmarkEmail Data in OpenOffice Base
Connect to BenchmarkEmail data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Build a Simple VCL Application for Google Analytics Data
How to build a simple VCL Application to view Google Analytics data in RAD Studio using the CData ODBC Driver for Google Analytics.
-
Excel Spreadsheet Automation on Simplesat Data with the QUERY Formula
Pull data from Simplesat, automate spreadsheets, and more with the QUERY formula.
-
Use ChatGPT to Talk to Your SuiteCRM 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 SuiteCRM data for you.
-
Connect to Box in SpagoBI
Create reports featuring live Box data in SpagoBI Studio. Host Box reports on SpagoBI Server.
-
Automated Continuous Pipeline CRM Replication to Snowflake
Use CData Sync for automated, continuous, customizable Pipeline CRM replication to Snowflake.
-
Create SAP Concur-Connected Dashboards in Grafana
Connect to SAP Concur Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to SAP Concur data.
-
Build Sybase-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Sybase Data and create custom apps in Mendix.
-
Build an OLAP Cube in SSAS from Excel Online Data
Establish a connection to Excel Online data data from SQL Server Analysis Services, and use the Excel Online Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to Access Live PabblySubscriptions Data in Power Automate Desktop via ODBC
The CData ODBC Driver for PabblySubscriptions enables you to integrate PabblySubscriptions data into workflows built using Microsoft Power Automate Desktop.
-
Connect to Google Ads Data from HeidiSQL
Use CData Connect AI to connect to and query live Google Ads data from HeidiSQL.
-
Trigger EnterpriseDB IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for EnterpriseDB with standard wizards in Logic Apps.
-
Prepare, Blend, and Analyze Sybase IQ Data in Alteryx Designer (Connect AI)
Build workflows to access live Sybase IQ data for self-service data analytics.
-
Query Live Campaigner 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 Campaigner data through a conversational interface.
-
LINQ to Exact Online 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 Exact Online Data Provider.
-
Create Reports with Okta Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Okta data.
-
Integrate Google's Antigravity Agent with Live Dropbox Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Dropbox data using the Model Context Protocol.
-
Analyze Monday.com Data in Cognos Analytics
Use CData Connect AI to connect to Monday.com Data from Cognos Analytics and analyze live Monday.com data.
-
Integrate Tally Data in the Pentaho Report Designer
Publish reports based on Tally data in the Pentaho BI tool.
-
Process & Analyze Stripe Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Stripe Data.
-
Operational Reporting on Teradata Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Teradata data.
-
Automated Continuous Clari Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Clari replication to Apache Kafka.
-
Integrate Live DocuSign Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live DocuSign data to Blue Prism using the CData ODBC Driver for DocuSign to create automated workflows for repetitive business tasks.
-
Build Pipelines with Live Pipedrive Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Pipedrive from Google Cloud Data Fusion, enabling the integration of live Pipedrive data into the building and management of effective data pipelines.
-
Query Adobe Commerce Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Adobe Commerce entities in PHP by modeling them as objects.
-
Integrate Trae with Live Microsoft Ads Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Microsoft Ads data from within the AI-powered IDE.
-
Build MySQL Visualizations in Tableau Desktop
Use CData Connect AI to connect to live MySQL data and build visualizations in Tableau.
-
How to Query Vimeo Data in MySQL Workbench
Execute MySQL queries against live Vimeo data from MySQL Workbench.
-
Access Live Mailgun Data in Coginiti Pro
Connect to and query live Mailgun data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to Live Discord Data in MicroStrategy through CData Connect AI
Create a live connection to Discord Data in CData Connect AI and connect to your Discord data from MicroStrategy.
-
Use the CData Software ODBC Driver for Gong in SAS for Real-Time Reporting and Analytics
Connect to real-time Gong data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Gong.
-
DataBind Controls to WooCommerce Data in C++Builder
DataBind to WooCommerce data in C++Builder with standard components and controls.
-
Getting Started with the CData Tableau Connector for Zoho CRM
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Zoho CRM.
-
Use Biml to Build SSIS Tasks to Replicate Float Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Float data to SQL Server.
-
Visualize REST Data in Tableau
The CData ODBC driver for REST enables you integrate REST data into Tableau dashboards.
-
Automated Continuous PhantomBuster Replication to SQL Server
Use CData Sync for automated, continuous, customizable PhantomBuster replication to SQL Server.
-
Add Instantly Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Instantly with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to SendGrid Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for SendGrid data.
-
Create HubSpot-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to HubSpot Data from Klipfolio and build custom visualizations using live HubSpot data.
-
A PostgreSQL Interface for Google Ad Manager Data (MySQL Remoting via JDBC)
Use the Remoting features of the Google Ad Manager JDBC Driver to create a PostgreSQL entry-point for data access.
-
Link HelloSign with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate HelloSign data in Filemaker Pro for Mac or Windows.
-
Use Manus AI to Talk to Your SendPulse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on SendPulse data.
-
How to connect to Productboard Data from Spring Boot
Connect to Productboard in a Spring Boot Application using the CData API Driver for JDBC
-
Visualize Live Avro Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Avro data.
-
Build QuickBooks Time-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to QuickBooks Time Data from Zoho Analytics and import live QuickBooks Time data.
-
Write a Simple Go Application to work with Exa Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Exa data.
-
Integrate Live Adobe Analytics Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Adobe Analytics from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Adobe Analytics data.
-
Integrate OpenCode with Live Mailjet Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Mailjet data from within your AI coding agent.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for AlloyDB
Provide connectivity to AlloyDB data through an SAP BusinessObjects universe.
-
Query Oracle HCM Cloud Data in DataGrip
Create a Data Source for Oracle HCM Cloud in DataGrip and use SQL to query live Oracle HCM Cloud data.
-
DataBind Controls to SAP Ariba Source Data in C++Builder
DataBind to SAP Ariba Source data in C++Builder with standard components and controls.
-
Integrating GitHub Copilot with Strava 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.
-
Visualize Gmail Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Gmail data into TIBCO Spotfire.
-
Choosing the Best Method to Connect SurveyMonkey to SQL Server: 5 Options Explained
Discover multiple ways to connect and use SurveyMonkey data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect Zoho Inventory Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Zoho Inventory data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connecting Mastra with SharePoint 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 SharePoint data, no replication required.
-
Connect to Excel Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Excel data.
-
How to Connect to Live Perplexity Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Perplexity data for you.
-
How to connect and process Eventbrite data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Eventbrite data.
-
Visualize Live Authorize.Net Data in the Power BI Service
Use CData Connect AI to connect to live Authorize.Net data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Rapidly Develop Deel-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Deel.
-
Analyze Greenplum Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Greenplum from Power Pivot. You will use the Table Import Wizard to load Greenplum data. You can visually build the import query or use any SQL supported by the driver.
-
LINQ to Nethunt 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 Nethunt Data Provider.
-
Migrating data from QuickBooks Online to Google BigQuery using CData SSIS Components.
Easily push QuickBooks Online data to Google BigQuery using the CData SSIS Tasks for QuickBooks Online and Google BigQuery.
-
Extract, Transform, and Load Aircall Data in Informatica PowerCenter
Create a simple Workflow for Aircall data in Informatica PowerCenter.
-
Creating Azure Synapse-Connected Applications in Unqork
You can use CData Connect AI to feed Azure Synapse data to Unqork and build custom business apps.
-
Integrate Amazon Athena with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Amazon Athena with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Amazon Athena data.
-
Integrate Cohere Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Cohere data from Informatica Cloud.