CData Software - Knowledge Base
Recent Articles
-
Using the CData Software ODBC Driver for Klaviyo in PyCharm
Connect to Klaviyo as an ODBC data source in PyCharm using the CData Software ODBC Driver for Klaviyo.
-
Create Microsoft Ads-Connected Dashboards in Grafana
Connect to Microsoft Ads Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Microsoft Ads data.
-
Integrating Claude Code with Tally Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Tally data within assisted coding and automated development workflows.
-
Connect SAP Netweaver Gateway to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live SAP Netweaver Gateway data using the CData Python MCP Server.
-
Connect to Azure Data Catalog Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Azure Data Catalog data.
-
Using the CData Software ODBC Driver for Testmonitor in PyCharm
Connect to Testmonitor as an ODBC data source in PyCharm using the CData Software ODBC Driver for Testmonitor.
-
How to import Todoist Data into Apache Solr
Use the CData Software JDBC Driver for Todoist in Data Import Handler and create an automated import of Todoist data to Apache Solr Enterprise Search platform.
-
Import MailChimp Data Using Azure Data Factory
Use CData Connect AI to connect to MailChimp Data from Azure Data Factory and import live MailChimp data.
-
Connecting Agentforce with Raisers Edge NXT 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 Raisers Edge NXT data for you.
-
Connecting Moonlit Workflow with IBM Cloud Object Storage 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 IBM Cloud Object Storage data in real time.
-
Connect to HCL Domino Data from a Connection Pool in JBoss
Integrate HCL Domino data into Java servlets: Use the Management Console in JBoss to install the HCL Domino JDBC Driver.
-
Automated Continuous SAP Business One Replication to AlloyDB
Use CData Sync for automated, continuous, customizable SAP Business One replication to AlloyDB.
-
Integrating GitHub Copilot with GraphQL 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 Build an ETL App for Azure Analysis Services Data in Python with CData
Create ETL applications and real-time data pipelines for Azure Analysis Services data in Python with petl.
-
Access Live TaxJar Data in Coginiti Pro
Connect to and query live TaxJar data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to Google Contacts Data from HeidiSQL
Use CData Connect AI to connect to and query live Google Contacts data from HeidiSQL.
-
Access Live Dropbox Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Dropbox data from your Excel spreadsheets.
-
Query ZohoExpense Data as a SQL Server Database in Node.js
Execute SQL Server queries against ZohoExpense data from Node.js.
-
Integrate with Amazon DynamoDB Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Amazon DynamoDB data in SnapLogic.
-
How to update Workday from Excel
This article explains how to transfer data from Excel to Workday using the Excel Add-In for Workday.
-
Connect to Live Adobe Target Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Adobe Target in CData Connect AI and connect to your Adobe Target data from PostgreSQL.
-
Automated Continuous Grafana Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Grafana replication to Azure SQL Database.
-
Interact with Live Redshift Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Redshift data.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for FTP
Provide connectivity to FTP data through an SAP BusinessObjects universe.
-
Model JSON Services Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and JSON, enabling the direct import of real-time JSON services.
-
Access Aweber Data from MySQL in Amazon QuickSight
Connect to Aweber and build visualizations of Aweber data using a MySQL Connection in Amazon QuickSight.
-
Integrate Live SAP SuccessFactors Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to SAP SuccessFactors from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live SAP SuccessFactors data.
-
DataBind ServiceDesk Plus Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide ServiceDesk Plus data to a chart.
-
Build MailChimp-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live MailChimp data.
-
Use Grok to Talk to Your OneNote Data 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 OneNote data for you.
-
Visualize Pipedrive Data in TIBCO Spotfire through OData
Integrate Pipedrive data into dashboards in TIBCO Spotfire.
-
Build MVC Applications with Connectivity to Google Search Results
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Google Search from an ASP.NET MVC application.
-
Establish a Live Connection with Float Data using Tableau Bridge
The CData ODBC Driver for Float enables you to integrate live Float data into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to Live Amazon Marketplace Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Amazon Marketplace in CData Connect AI and connect to your Amazon Marketplace data from PostgreSQL.
-
Connect to Dynamics 365 Business Central Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Dynamics 365 Business Central data in Airbyte.
-
Connecting Mastra with Jira 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 Jira data, no replication required.
-
Create Data Visualizations in Cognos BI with SAP Hybris C4C Data
Access SAP Hybris C4C data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Extract, Transform, and Load Tickspot Data in Informatica PowerCenter
Create a simple Workflow for Tickspot data in Informatica PowerCenter.
-
Create Data Visualizations in Cognos BI with LinkedIn Ads Data
Access LinkedIn Ads data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Access YouTube Analytics 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 YouTube Analytics data.
-
How to create EmailOctopus federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for EmailOctopus data in MySQL .
-
Use Databricks Agent Bricks to Talk to Your Zuora Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Zuora data for you.
-
Automate Optimizely Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Optimizely data from PowerShell? This article demonstrates how to utilize the Optimizely Cmdlets for tasks like connecting to Optimizely data, automating operations, downloading data, and more.
-
Operational Reporting on Zendesk Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Zendesk data.
-
Integrating Claude Code with Certinia Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Certinia data within assisted coding and automated development workflows.
-
DataBind Charts to Amazon Marketplace Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Amazon Marketplace data from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Getting Started with the CData ODBC Driver for Pipeline CRM
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Pipeline CRM.
-
Access SAP Hybris C4C Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live SAP Hybris C4C data from HeidiSQL.
-
Integrating OpenCode with OpenWeatherMap 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.
-
Import Real-Time Qualaroo Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Qualaroo data in ColdFusion.
-
DataBind Controls to Tally Data in Delphi
DataBind to Tally data in Delphi with standard data access components and controls.
-
Automated Continuous Amazon Athena Replication to SQLite
Use CData Sync for automated, continuous, customizable Amazon Athena replication to SQLite.
-
Automate MariaDB Data Replication to Azure Data Lake
Use CData Sync to customize and automate MariaDB data replication to Azure Data Lake.
-
Use the CData ODBC Driver for Zoom from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Zoom to connect to Zoom data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Zoom data in Excel.
-
Excel Spreadsheet Automation on Microsoft Planner Data with the QUERY Formula
Pull data from Microsoft Planner, automate spreadsheets, and more with the QUERY formula.
-
Replicate Reply.io Data to Multiple Databases via the CData Sync CLI
Replicate Reply.io data to disparate databases with a single configuration.
-
How to Connect to Live Raisers Edge NXT 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 Raisers Edge NXT data through natural language.
-
Use the CData ODBC Driver for Active Directory from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Active Directory to connect to Active Directory data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Active Directory data in Excel.
-
Use the CData Software ODBC Driver for Qualaroo in MicroStrategy Desktop
Connect to Qualaroo data in MicroStrategy Desktop using the CData Software ODBC Driver for Qualaroo.
-
Use Biml to Build SSIS Tasks to Replicate Optimizely Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Optimizely data to SQL Server.
-
Visualize Live SAP ByDesign Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live SAP ByDesign data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Onfleet from a Connection Pool in WebLogic
Use the CData JDBC Driver for Onfleet to connect to Onfleet data from Web applications running on WebLogic.
-
How to Access Excel Online Data Using Entity Framework
This article shows how to access Excel Online data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Publish Reports with PolarTeamPro Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date PolarTeamPro data.
-
Connect to Gmail Data in ACL Analytics
Connect to Gmail data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Gmail data.
-
How to integrate Snowflake with Apache Airflow
Access and process Snowflake data in Apache Airflow using the CData JDBC Driver.
-
Create SSAS Tabular Models from Guru Data
How to build a SQL Server Analysis Service Tabular Model from Guru data using CData drivers.
-
Build a PostgreSQL Interface for CockroachDB Data using the CData JDBC Driver
Use the Remoting features of the CockroachDB JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate Paymo Data in the Pentaho Report Designer
Publish reports based on Paymo data in the Pentaho BI tool.
-
Migrating data from Pinterest to Databricks using CData SSIS Components.
Easily push Pinterest data to Databricks using the CData SSIS Tasks for Pinterest and Databricks.
-
Create Reports from Cloudflare Data in Looker Studio
Use CData Connect AI to gain access to live Cloudflare data and create custom reports in Looker Studio.
-
Integrate with Dynamics CRM Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Dynamics CRM data in SnapLogic.
-
Access Live Oracle HCM Cloud Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Oracle HCM Cloud data from your Excel spreadsheets.
-
Back Up Figshare data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Figshare data data.
-
Configure the CData JDBC Driver for Acumatica in a Connection Pool in Tomcat
Connect to Acumatica data from a connection pool in Tomcat.
-
Migrating data from Freshdesk to Google BigQuery using CData SSIS Components.
Easily push Freshdesk data to Google BigQuery using the CData SSIS Tasks for Freshdesk and Google BigQuery.
-
Use Agno to Talk to Your Microsoft Entra ID Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Microsoft Entra ID data for you.
-
Connect to Splunk in SpagoBI
Create reports featuring live Splunk data in SpagoBI Studio. Host Splunk reports on SpagoBI Server.
-
Connect to Apify Data from AWS Glue
Use CData Connect AI to gain access to live Apify data from your AWS Glue jobs.
-
Create Informatica Mappings From/To an ODBC Data Source for Parquet
Create an ODBC connection to Parquet in Informatica and browse and transfer Parquet data.
-
How to Connect to Live Azure DevOps Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Azure DevOps data for you.
-
Access ZohoInvoice Data from MySQL in Amazon QuickSight
Connect to ZohoInvoice and build visualizations of ZohoInvoice data using a MySQL Connection in Amazon QuickSight.
-
Access Attio Data from MySQL in PHP
Connect to Attio through the standard MySQL libraries in PHP.
-
How to connect to Coinbase Data from IntelliJ
Integrate connectivity to Coinbase data with wizards in IntelliJ.
-
Build AI Agents with Tally Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Tally data through CData Connect AI.
-
Integrate Smartsheet with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Smartsheet with External Services.
-
Build Strava-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Strava data and build web apps with connectivity to live Strava data.
-
Connect to GitHub Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with GitHub Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Build Twitter Ads-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Twitter Ads Data from Zoho Analytics and import live Twitter Ads data.
-
Query SAP SuccessFactors Data through ODBC in Node.js
Use node-odbc to execute SQL queries against SAP SuccessFactors data from Node.js.
-
Automate Pinterest Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Pinterest data from PowerShell? This article demonstrates how to utilize the Pinterest Cmdlets for tasks like connecting to Pinterest data, automating operations, downloading data, and more.
-
Bidirectional Access to Excel Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Excel data in Filemaker Pro for Mac or Windows.
-
Connect to SQL Analysis Services Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with SQL Analysis Services Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Create Moosend Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Moosend data access from reports, embedded analytics, and more.
-
Connecting Moonlit Workflow with Box 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 Box data in real time.
-
Integrate HCL Domino Data in the Pentaho Report Designer
Publish reports based on HCL Domino data in the Pentaho BI tool.
-
Automated Continuous Avalara AvaTax Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Avalara AvaTax replication to IBM DB2.
-
Integrate LibreChat with Live Adobe Commerce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Adobe Commerce data from within the chat interface.
-
Automated Continuous Procore Replication to SQLite
Use CData Sync for automated, continuous, customizable Procore replication to SQLite.
-
Connect to Oracle Financials Cloud Data in JRuby
Create a simple JRuby app with access to live Oracle Financials Cloud data.