CData Software - Knowledge Base
Recent Articles
-
Getting Started with the CData Python Connector for Unbounce
Learn to install and license the CData Python Connector and configure a connection to live Unbounce data.
-
Connect to Azure Synapse Data from Crystal Reports
Use CData Connect AI to connect to and report on live Azure Synapse data from Crystal Reports.
-
Connect to Teamwork Data in Ruby
Connect to Teamwork data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Use the CData Software JDBC Driver for LinkedIn Ads in MicroStrategy Desktop
Connect to LinkedIn Ads data in MicroStrategy Desktop using the CData Software JDBC Driver for LinkedIn Ads.
-
Operational Reporting on Coinbase Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Coinbase data.
-
Build GitLab-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to GitLab data and build web apps with connectivity to live GitLab data.
-
Integrate OpenCode with Live Active Directory Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Active Directory data from within your AI coding agent.
-
Integrating OpenCode with REST 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.
-
Connecting Moonlit Workflow with MailerLite Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your MailerLite data in real time.
-
Automate Timely Data Replication to Azure Data Lake
Use CData Sync to customize and automate Timely data replication to Azure Data Lake.
-
Import Real-Time Rootly Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Rootly data in ColdFusion.
-
Create Power BI Reports on Real-Time Teamwork Data
Use the CData ODBC Driver for Teamwork to visualize Teamwork data in Power BI Desktop.
-
Migrating data from Dotmailer to Databricks using CData SSIS Components.
Easily push Dotmailer data to Databricks using the CData SSIS Tasks for Dotmailer and Databricks.
-
How to Work with Planio Data in ETL Validator JDBC
Connect to Planio from ETL Validator jobs using the CData Software JDBC Driver.
-
Getting Started with the CData SSIS Components for JotForm
Complete guide to installing, licensing, and connecting with the CData SSIS Components for JotForm.
-
Connect to MailerSend Data as an External Source in Dremio
Use the CData JDBC Driver to connect to MailerSend as an External Source in Dremio.
-
Work with Stack Exchange Data in FoxPro
Load Stack Exchange data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Replicate Beeminder Data from PowerShell
Write a quick PowerShell script to query Beeminder data. Use connectivity to the live data to replicate Beeminder data to SQL Server.
-
Query Oracle Sales Data as a MySQL Database in Node.js
Execute MySQL queries against Oracle Sales data from Node.js.
-
Integrate Shippo Data into Power Automate Desktop using CData Connect
CData Connect for Shippo Data enables you to integrate Shippo data into workflows built using Microsoft Power Automate Desktop.
-
Access ZendeskSell Data 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 ZendeskSell data.
-
Connect to Everhour Data from a Connection Pool in Jetty
The Everhour JDBC Driver supports connection pooling: This article shows how to connect faster to Everhour data from Web apps in Jetty.
-
Create Informatica Mappings From/To a JDBC Data Source for Klipfolio
Create Klipfolio data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to Jumpseller Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Jumpseller Data and connect to Jumpseller data in Akorbi Digital RunMyProcess.
-
Integrate Typeform with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Typeform with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Typeform data.
-
Automated Continuous REST Replication to AlloyDB
Use CData Sync for automated, continuous, customizable REST replication to AlloyDB.
-
Query Live GitHub 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 GitHub data through a conversational interface.
-
Connect to Egnyte Data from HeidiSQL
Use CData Connect AI to connect to and query live Egnyte data from HeidiSQL.
-
Using the CData Software ODBC Driver for ShipEngine in PyCharm
Connect to ShipEngine as an ODBC data source in PyCharm using the CData Software ODBC Driver for ShipEngine.
-
Connect to QuickBooks Data in NetBeans
Connect to QuickBooks data in NetBeans with the data source configuration wizard.
-
Integrate Google's Antigravity Agent with Live ZohoDesk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live ZohoDesk data using the Model Context Protocol.
-
Automated Scrapfly Data Replication to Teradata
Use CData Sync to Customize and automate Scrapfly data replication to Teradata.
-
Analyze Reckon Accounts Hosted Data in Cognos Analytics
Use CData Connect AI to connect to Reckon Accounts Hosted Data from Cognos Analytics and analyze live Reckon Accounts Hosted data.
-
Connect to Mailjet Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Mailjet data from Filemaker Pro on Mac.
-
Access Live SAP Ariba Procurement Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to SAP Ariba Procurement data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Connect to ActiveCampaign Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for ActiveCampaign Data and connect to ActiveCampaign data in Akorbi Digital RunMyProcess.
-
Bind Live Google Calendar Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Google Calendar data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Provide OData Services of Jumpseller Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Jumpseller data by developing a WCF Service Application.
-
Connect to Guru from Asprova with CData Software ODBC Driver for Guru
This article shows how to connect faster to Guru data from Asprova.
-
How to Query Placid Data in MySQL Workbench
Execute MySQL queries against live Placid data from MySQL Workbench.
-
Connect to Google Spanner Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Google Spanner and the SQL Gateway to access Google Spanner data from Google Apps Script.
-
Building Dynamic Web Pages with Cosmos DB Data Using AngularJS
Create single-page applications with live connectivity to Cosmos DB using the CData API Server.
-
Migrating data from Avaza to Google BigQuery using CData SSIS Components.
Easily push Avaza data to Google BigQuery using the CData SSIS Tasks for Avaza and Google BigQuery.
-
Integrate Cursor with Live Cvent Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Cvent data from within the editor.
-
Query Email Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Email entities in PHP by modeling them as objects.
-
DataBind Controls to Splunk Data in Delphi
DataBind to Splunk data in Delphi with standard data access components and controls.
-
Provide OData Services of Sage Cloud Accounting Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Sage Cloud Accounting data by developing a WCF Service Application.
-
How to Connect DBeaver to OpenWeatherMap via a JDBC Driver
Manage OpenWeatherMap data with visual tools in DBeaver like the query browser.
-
Automated Continuous Acumatica Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Acumatica replication to Amazon S3.
-
Kintone Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Kintone data through CData Connect AI using different applications and tools.
-
Access SharePoint Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SharePoint data from your Oracle system.
-
XML Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on XML facts in real time.
-
Migrating data from eBay to Databricks using CData SSIS Components.
Easily push eBay data to Databricks using the CData SSIS Tasks for eBay and Databricks.
-
Prepare, Blend, and Analyze CampaignMonitor Data in Alteryx Designer (ODBC)
Build workflows to access live CampaignMonitor data for self-service data analytics.
-
Analyze Google Ad Manager Data in Cognos Analytics
Use CData Connect AI to connect to Google Ad Manager Data from Cognos Analytics and analyze live Google Ad Manager data.
-
Integrate with SAP ByDesign Data in JReport Designer
Create charts and reports based on SAP ByDesign data in JReport Designer.
-
Integrate Goose with Live LinkedIn Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live LinkedIn Ads data from within the local AI agent.
-
Automate MailChimp Data Replication to Azure Data Lake
Use CData Sync to customize and automate MailChimp data replication to Azure Data Lake.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for AgileCRM
Provide connectivity to AgileCRM data through an SAP BusinessObjects universe.
-
Integrate Google's Vertex AI Agent with Live Authorize.Net Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Authorize.Net data within intelligent workflows.
-
Create Data Visualizations in Cognos BI with IBM Informix Data
Access IBM Informix data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Build Moosend-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Moosend data.
-
Access Microsoft OneDrive Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Microsoft OneDrive data from HeidiSQL.
-
Connect to Azure DevOps Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Azure DevOps data in Airbyte.
-
Connecting GenSpark with Typeform Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Typeform data without any replication or custom integration required.
-
Automated Continuous LDAP Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable LDAP replication to PostgreSQL.
-
Automated Continuous Workday Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Workday replication to PostgreSQL.
-
Build Dashboards with PabblySubscriptions Data in DBxtra
Create dynamic dashboards and perform analytics based on PabblySubscriptions data in DBxtra.
-
Interact with Live Google Ads Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Google Ads data.
-
Build Azure Data Catalog-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Azure Data Catalog Data and create custom apps in Mendix.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Google Cloud Storage
Provide connectivity to Google Cloud Storage data through an SAP BusinessObjects universe.
-
Integrate with live PayPal Data in Jitterbit
Use CData Connect AI to connect to and integrate live PayPal data in Jitterbit.
-
Migrating data from Adobe Experience Manager to Databricks using CData SSIS Components.
Easily push Adobe Experience Manager data to Databricks using the CData SSIS Tasks for Adobe Experience Manager and Databricks.
-
Integrate Trae with Live Spark Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Spark data from within the AI-powered IDE.
-
How to Query Missive Data in MySQL Workbench
Execute MySQL queries against live Missive data from MySQL Workbench.
-
Analyze Acumatica Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Acumatica data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
How to connect to IBM Cloud Object Storage Data in DBVisualizer
Integrate IBM Cloud Object Storage data with visual data analysis tools and data connection wizards in DBVisualizer
-
Build Dashboards with Perigon Data in DBxtra
Create dynamic dashboards and perform analytics based on Perigon data in DBxtra.
-
Use Manus AI to Talk to Your Gmail 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 Gmail data.
-
Build Data Flows from Zendesk to SQL Server using SSIS
Easily back up Zendesk data to SQL Server using the SSIS components for Zendesk.
-
Connect to Redshift Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Redshift data using standard SQL.
-
Migrating data from Teamgate to Google BigQuery using CData SSIS Components.
Easily push Teamgate data to Google BigQuery using the CData SSIS Tasks for Teamgate and Google BigQuery.
-
Access Live SAP Concur Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SAP Concur data from your Google Sheets.
-
Visualize Live Email Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Email data into custom reports in Power BI.
-
Integrate Microsoft Entra ID with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Microsoft Entra ID with External Services.
-
Creating SageHR-Connected Applications in Unqork
You can use CData Connect AI to feed SageHR data to Unqork and build custom business apps.
-
Use the CData ODBC Driver for PayPal in Microsoft Power Query
You can use the CData PayPal ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import PayPal data into Microsoft Power Query.
-
Create SSAS Tabular Models from Sage 300 Data
How to build a SQL Server Analysis Service Tabular Model from Sage 300 data using CData drivers.
-
Build Charts with ZendeskSell Data in Clear Analytics
Create dynamic charts and perform analytics based on ZendeskSell data in Clear Analytics.
-
Replicate Snapchat Ads Data to Multiple Databases via the CData Sync CLI
Replicate Snapchat Ads data to disparate databases with a single configuration.
-
Integrating Kiro with BigQuery 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.
-
Access Live Cvent Data in Excel 365 Online (Excel for the web)
Connect to Cvent data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Connect to Cohere Data in CloverDX (formerly CloverETL)
Transfer Cohere data using the visual workflow in the CloverDX data integration tool.
-
Replicate Sentry Data from PowerShell
Write a quick PowerShell script to query Sentry data. Use connectivity to the live data to replicate Sentry data to SQL Server.
-
How to connect to Amazon DynamoDB Data from IntelliJ
Integrate connectivity to Amazon DynamoDB data with wizards in IntelliJ.
-
Replicate Google Sheets Data in Heroku for Use in Salesforce Connect
Replicate Google Sheets data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Replicate Notion Data in Heroku for Use in Salesforce Connect
Replicate Notion data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Access Spark Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Spark data from HeidiSQL.
-
Visualize eBay Analytics Data in Sisense
Create an ElastiCube in Sisense app with access to eBay Analytics data.
-
How to import ADP Data into Apache Solr
Use the CData Software JDBC Driver for ADP in Data Import Handler and create an automated import of ADP data to Apache Solr Enterprise Search platform.