CData Software - Knowledge Base
Recent Articles
-
Creating Splunk-Connected Applications in Unqork
You can use CData Connect AI to feed Splunk to Unqork and build custom business apps.
-
Use Azure AI Foundry to Talk to Your Couchbase 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 Couchbase for you.
-
Connect to Google Spanner from Asprova with CData Software ODBC Driver for Google Spanner
This article shows how to connect faster to Google Spanner data from Asprova.
-
Query, Visualize, and Share live Zoho Creator Data in Redash
Use CData Connect AI to connect to live Zoho Creator in Redash for querying, visualizing, and sharing.
-
Getting Started with the CData Excel Add-In for Discord
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Discord.
-
Visualize Tavily Data in Sisense
Create an ElastiCube in Sisense app with access to Tavily.
-
Use the CData ODBC Driver for Pinecone from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Pinecone to connect to Pinecone from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Pinecone in Excel.
-
Build Google Search-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Google Search to explore live Google Search Results in GitHub Copilot to assist with building Google Search-powered applications.
-
Connect to Salesforce Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Salesforce to connect to Salesforce & Force.com and execute queries in PowerBuilder.
-
Build Dashboards with YouTube Analytics Data in DBxtra
Create dynamic dashboards and perform analytics based on YouTube Analytics in DBxtra.
-
Build Data Flows from Sendwithus to SQL Server using SSIS
Easily back up Sendwithus to SQL Server using the SSIS components for Sendwithus.
-
Access Live Vertica Data in Excel 365 Online (Excel for the web)
Connect to Vertica from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Create Data Visualizations in Cognos BI with JobNimbus Data
Access JobNimbus as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to Teamgate Data in HULFT Integrate
Connect to Teamgate as a JDBC data source in HULFT Integrate
-
Connect to Sage Cloud Accounting Data in CloverDX (formerly CloverETL)
Transfer Sage Business Cloud Accounting using the visual workflow in the CloverDX data integration tool.
-
Integrate with Google Directory Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Google Directory to a JSON file on disk.
-
Connect to Sage Intacct Data in NetBeans
Connect to Sage Intacct in NetBeans with the data source configuration wizard.
-
Automated Continuous Zoho Books Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Zoho Books replication to OneLake in Microsoft Fabric.
-
Analyze Oracle Eloqua Reporting Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Oracle Eloqua Reporting from Power Pivot. You will use the Table Import Wizard to load Oracle Eloqua Reporting. You can visually build the import query or use any SQL supported by the driver.
-
Create Data Visualizations Based On Monday.com Data in Mode
Use CData Connect AI to connect to Monday.com Data from Mode and build visualizations using live
-
Build MVC Applications with Connectivity to LionDesk Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access LionDesk from an ASP.NET MVC application.
-
Getting Started with the CData Connect AI Python SDK for Paylocity
Install the CData Connect AI Python SDK to read and write live Paylocity with standard DB-API 2.0 Python code.
-
Automate Blackbaud FE NXT Data Replication to Azure Data Lake
Use CData Sync to customize and automate Blackbaud FE NXT replication to Azure Data Lake.
-
Create Dashboards and Visualize Live Tally Data in Geckoboard
Use CData Connect AI to connect to live Tally ERP and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Connect to and Visualize Live Act-On Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Act-On.
-
Import Real-Time Zoho CRM Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Zoho CRM in ColdFusion.
-
How to Connect to Live Shopify Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Shopify for you.
-
Build Data Flows from SQL Server to Dynamics 365 Business Central through SSIS
Easily push SQL Server data to Dynamics 365 Business Central using the CData SSIS Tasks for Dynamics 365 Business Central.
-
Build CSV-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to CSV Data from Zoho Analytics and import live CSV/TSV Files.
-
Automate Salesforce Marketing Data Replication to Azure Data Lake
Use CData Sync to customize and automate Salesforce Marketing Cloud replication to Azure Data Lake.
-
Seamlessly Bring Jira Assets Data into Retool Using CData Connect AI
Integrate Jira Assets data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Automated Continuous SAP ByDesign Replication to SingleStore
Use CData Sync for automated, continuous, customizable SAP ByDesign replication to SingleStore.
-
A PostgreSQL Interface for Dynamics 365 Data (MySQL Remoting via JDBC)
Use the Remoting features of the Dynamics 365 JDBC Driver to create a PostgreSQL entry-point for data access.
-
Query, Visualize, and Share live Facebook Data in Redash
Use CData Connect AI to connect to live Facebook in Redash for querying, visualizing, and sharing.
-
Automated Continuous Datadog Replication to Oracle
Use CData Sync for automated, continuous, customizable Datadog replication to Oracle.
-
Analyze Sybase IQ Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Sybase IQ and visualize live Sybase IQ in Infragistics Reveal.
-
How to connect PolyBase to eBay Analytics
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live eBay Analytics.
-
Integrate Live ZohoDesk Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live ZohoDesk to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Work with Live Quickbase Data in Power Query
Use CData Connect AI to connect to Quickbase and work with live Quickbase in Microsoft Power Query.
-
Integrating Claude Code CLI with Zoho Recruit 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.
-
Connect Sage 200 Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Sage 200 using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Placid Reporting in OBIEE with the Placid JDBC Driver
Deploy the Placid JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Integrating Gumloop with Azure DevOps Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Azure DevOps within automated workflows.
-
Create Datasets from Front in Domo Workbench and Build Visualizations of Front Data in Domo
Use the CData Software ODBC Driver for Front to create datasets from Front in Domo Workbench and then build visualizations in the Domo service.
-
Migrating data from SharePoint Excel Services to Databricks using CData SSIS Components.
Easily push SharePoint Excel Services to Databricks using the CData SSIS Tasks for SharePoint Excel Services and Databricks.
-
Integrating LangGraph with Blackbaud FE NXT Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Blackbaud FE NXT within automated workflows.
-
Build Apollo Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Apollo and build visualizations in Tableau Cloud.
-
Connecting Agentforce with Quickbase 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 Quickbase for you.
-
Use the CData Software JDBC Driver for LDAP in MicroStrategy Desktop
Connect to LDAP in MicroStrategy Desktop using the CData Software JDBC Driver for LDAP.
-
Edit and Search External Stripe Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Stripe to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Stripe Data objects that you can access from apps and the dashboard.
-
Access Live Perigon Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Perigon into the statistical analysis tools available in SAS JMP. This article shows how to use Perigon in the Graph Builder and Query Builder.
-
Deploy the ADO.NET Provider for Microsoft Dataverse on an SSRS Report Server
Connect to Microsoft Dataverse (CDS) 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.
-
Query Ontraport Data as a MySQL Database in Node.js
Execute MySQL queries against Ontraport from Node.js.
-
Build Dashboards with Wistia Data in DBxtra
Create dynamic dashboards and perform analytics based on Wistia in DBxtra.
-
Automated Continuous Quaderno Replication to SQL Server
Use CData Sync for automated, continuous, customizable Quaderno replication to SQL Server.
-
Rapidly Develop Redis-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 Redis.
-
Build Adobe Analytics-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Adobe Analytics to explore live Adobe Analytics Data in Gemini Code Assist to assist with building Adobe Analytics-powered applications.
-
Connect to Google Tasks Data in RazorSQL
Connect to Google Tasks from wizards and query Google Tasks from the GUI in the RazorSQL database management tool.
-
Getting Started with the CData Tableau Connector for ClickTime
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Edit and Search Excel Online External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Microsoft Excel Online to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Excel Online objects that you can access from apps and the dashboard.
-
How to Seamlessly Import Short.io Data into IBM SPSS Modeler
Integrate Short.io data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to connect to EmailOctopus Data in DBVisualizer
Integrate EmailOctopus with visual data analysis tools and data connection wizards in DBVisualizer
-
Easily Integrate ServiceDesk Plus Data in Lazarus Pascal IDE
Learn how to easily integrate live ServiceDesk Plus in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to Mocean Data in DBArtisan
Use wizards in DBArtisan to configure Mocean as a data source.
-
Access Highrise Data from MySQL in PHP
Connect to Highrise through the standard MySQL libraries in PHP.
-
Connect to Miro Data in DBArtisan
Use wizards in DBArtisan to configure Miro as a data source.
-
Integrate PayPal with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate PayPal with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to PayPal.
-
ETL Optimizely in Oracle Data Integrator
This article shows how to transfer Optimizely into a data warehouse using Oracle Data Integrator.
-
Connect to Google Translate Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Google Translate to connect to Google Translate and execute queries in PowerBuilder.
-
Build Data Flows from MessageBird to SQL Server using SSIS
Easily back up MessageBird to SQL Server using the SSIS components for MessageBird.
-
How to Visualize Amazon Marketplace Data in Python with pandas
Use pandas and other modules to analyze and visualize live Amazon Marketplace in Python.
-
Publish Microsoft Dataverse-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Microsoft Dataverse (CDS).
-
Automated Continuous Zoho Books Replication to MySQL
Use CData Sync for automated, continuous, customizable Zoho Books replication to MySQL.
-
Automated Continuous Facebook Ads Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Facebook Ads replication to Google BigQuery.
-
Connect to Supabase Data in Aqua Data Studio
Access Supabase from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Scrapfly Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Scrapfly and the SQL Gateway to access Scrapfly from Google Apps Script.
-
Work with Excel Data in FoxPro
Load Microsoft Excel into a FoxPro database. This article includes full code and a walk-through of the process.
-
Automated Continuous eBay Analytics Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable eBay Analytics replication to Apache Kafka.
-
How to load SFTP data into Elasticsearch via Logstash
Introducing a simple method to load SFTP data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Build Data Flows from Greenhouse to SQL Server using SSIS
Easily back up Greenhouse to SQL Server using the SSIS components for Greenhouse.
-
Connect Instantly to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Instantly using the CData Python MCP Server.
-
Build Apps with Live Atlassian Jira in Adalo using CData Connect AI
Use CData Connect AI to integrate live Atlassian Jira into the Adalo platform and build custom mobile and web applications with real-time Atlassian Jira.
-
Visualize MailerSend 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 MailerSend into TIBCO Spotfire.
-
Replicate GetResponse Data to Multiple Databases via the CData Sync CLI
Replicate GetResponse to disparate databases with a single configuration.
-
DataBind Controls to Acumatica Data in C++Builder
DataBind to Acumatica ERP in C++Builder with standard components and controls.
-
Use the CData ODBC Driver for LightSpeedRetail from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for LightSpeedRetail to connect to LightSpeedRetail from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring LightSpeedRetail in Excel.
-
Connect to Microsoft Dataverse Data in Ruby
Connect to Microsoft Dataverse (CDS) in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automate HubSpot Data Replication to Azure Synapse
Use CData Sync to customize and automate HubSpot replication to Azure Synapse.
-
Build AI/ML Models with Live Zuora Data using Dataiku
Connect Zuora Data with Dataiku using the CData JDBC Driver for Zuora.
-
How to Seamlessly Import RSS Data into IBM SPSS Modeler
Integrate RSS data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Access Live Cvent Data in AWS Lambda
Connect to live Cvent in AWS Lambda using the CData JDBC Driver.
-
Replicate Adobe Experience Manager Data from PowerShell
Write a quick PowerShell script to query Adobe Experience Manager. Use connectivity to the live data to replicate Adobe Experience Manager to SQL Server.
-
Automate Mistral AI Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Mistral AI from PowerShell? This article demonstrates how to utilize the Mistral AI Cmdlets for tasks like connecting to Mistral AI, automating operations, downloading data, and more.
-
Use Dash to Build to Web Apps on Float Data
Create Python applications that use pandas and Dash to build Float-connected web apps.
-
Connect to Microsoft Planner Data in Aqua Data Studio
Access Microsoft Planner from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Replicate Box Data in Heroku for Use in Salesforce Connect
Replicate Box to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Explore Geographical Relationships in EmailOctopus Data with Power Map
Create data visualizations with EmailOctopus in Power Map.
-
Connect to Live Reckon Accounts Hosted Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Reckon Accounts Hosted in CData Connect AI and connect to your Reckon Accounts Hosted from PostgreSQL.
-
View Reports on Real-Time Gorgias Data in Power BI Report Server
Use the CData ODBC Driver for Gorgias to visualize Gorgias in Power BI Desktop and then publish them to Power BI Report Server.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Jumpseller
Provide connectivity to Jumpseller through an SAP BusinessObjects universe.