CData Software - Knowledge Base
Recent Articles
-
Build Adobe Commerce-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Adobe Commerce Data and create custom apps in Mendix.
-
Automated Continuous PolarTeamPro Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable PolarTeamPro data replication to OneLake in Microsoft Fabric.
-
Natively Connect to Coda Data in PHP
The CData ODBC driver for Coda enables you to create PHP applications with connectivity to Coda data. Leverage the native support for ODBC in PHP.
-
Automated Continuous DocuSign Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable DocuSign replication to PostgreSQL.
-
Connect to TaxJar Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for TaxJar data in Airbyte.
-
Connect Onfleet to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Onfleet data using the CData Python MCP Server.
-
Create Dynamic SharePoint Excel Services Grids Using the Infragistics XamDataGrid
Learn how you can connect SharePoint Excel Services to Infragistics XamDataGrid to build dynamic grids.
-
Use Dash to Build Web Apps on Azure Synapse Data via CData Connect AI
Build interactive Dash web apps on live Azure Synapse data using pandas and the CData Connect AI Python SDK.
-
Use the CData Software ODBC Driver for Neo4J in MicroStrategy Web
Connect to Neo4J data in MicroStrategy Web using the CData Software ODBC Driver for Neo4J.
-
Automated Continuous Dynamics 365 Replication to SingleStore
Use CData Sync for automated, continuous, customizable Dynamics 365 replication to SingleStore.
-
Create Data Visualizations in Cognos BI with ConvertAPI Data
Access ConvertAPI data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Bridge Microsoft Entra ID Connectivity with Apache NiFi
Access and process Microsoft Entra ID data in Apache NiFi using the CData JDBC Driver.
-
Sybase Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Sybase facts in real time.
-
Publish Todoist-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Todoist data.
-
Connect to Reply.io Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Reply.io data using standard SQL.
-
Create Informatica Mappings From/To a JDBC Data Source for Access
Create Access data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Integrating Cursor with Google Analytics 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 Facebook Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Facebook data from your Google Sheets.
-
Connect to Chargebee Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Chargebee.
-
Create Telegram Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Telegram from PowerBI.com to create Power BI Dataflows with real-time data.
-
Analyze Dynamics NAV Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Dynamics NAV data and visualize live Dynamics NAV data in Infragistics Reveal.
-
Integrating Codex with Oracle SCM 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 to Splunk Data in Ruby
Connect to Splunk data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Analyze AgileCRM Data in Looker
Use CData Connect AI to connect to AgileCRM Data from Looker and build custom apps using live AgileCRM data.
-
How to use SQLAlchemy ORM to access MarkLogic Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of MarkLogic data.
-
Work with Optimizely Data in FoxPro
Load Optimizely data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Add Zoho CRM Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Zoho CRM with the Informatica Enterprise Data Catalog to classify and organize data.
-
Using the CData Software ODBC Driver for Bitly in PyCharm
Connect to Bitly as an ODBC data source in PyCharm using the CData Software ODBC Driver for Bitly.
-
Use Biml to Build SSIS Tasks to Replicate Miro Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Miro data to SQL Server.
-
Connect AgileCRM to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect AgileCRM with IBM WebSphere for seamless data integration and connectivity.
-
Query Todoist Data in ColdFusion
Write standard ColdFusion data access code to connect to Todoist data.
-
Query Salesforce Marketing Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Salesforce Marketing data from Node.js.
-
Connect to Quickbase Data in ACL Analytics
Connect to Quickbase data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Quickbase data.
-
Back Up Sendwithus 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 Sendwithus data data.
-
Connect to Microsoft Dataverse Data from AWS Glue
Use CData Connect AI to gain access to live Microsoft Dataverse data from your AWS Glue jobs.
-
Automated Continuous Outreach.io Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Outreach.io replication to Google Cloud SQL.
-
Connect to Salesloft Data in NetBeans
Connect to Salesloft data in NetBeans with the data source configuration wizard.
-
Choosing the Best Method to Connect Vault CRM to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Vault CRM data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Use Manus AI to Talk to Your Attio 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 Attio data.
-
Visualize Mocean Data in TIBCO Spotfire through ADO.NET
Integrate Mocean data into dashboards in TIBCO Spotfire.
-
Replicate Mailgun Data from PowerShell
Write a quick PowerShell script to query Mailgun data. Use connectivity to the live data to replicate Mailgun data to SQL Server.
-
Build Charts with SendPulse Data in Clear Analytics
Create dynamic charts and perform analytics based on SendPulse data in Clear Analytics.
-
Connect to Zoho Projects Data in Google Apps Script via Connect AI
Use CData Connect AI to access Zoho Projects data in Google Apps Script.
-
Integrating Antigravity CLI with Wistia data via CData CLI
Connect Wistia data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to create Outlook federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Outlook data in MySQL .
-
How to Work with Sentry Data in ETL Validator JDBC
Connect to Sentry from ETL Validator jobs using the CData Software JDBC Driver.
-
Enable the Dynamics 365 Business Central JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Dynamics 365 Business Central data.
-
Getting Started with the CData SSIS Components for eBay Analytics
Complete guide to installing, licensing, and connecting with the CData SSIS Components for eBay Analytics.
-
Getting Started with the CData ODBC Driver for Amazon Athena
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Amazon Athena.
-
Automated Continuous Klipfolio Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Klipfolio replication to Google BigQuery.
-
Access Live Mouseflow Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Mouseflow data into the statistical analysis tools available in SAS JMP. This article shows how to use Mouseflow data in the Graph Builder and Query Builder.
-
How to Connect to Live Redis Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Redis data securely in real time.
-
Visualize Live Power BI XMLA Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Power BI XMLA data into custom reports in Power BI.
-
Analyze Redshift Data in Looker
Use CData Connect AI to connect to Redshift Data from Looker and build custom apps using live Redshift data.
-
Integrating GitHub Copilot with Azure Analysis Services 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 an RPA flow for ZohoExpense Data in UiPath Studio
Use the ZohoExpense ODBC Driver to create workflows that access real-time ZohoExpense data without any coding.
-
Create Data Visualizations Based On Dynamics CRM Data in Mode
Use CData Connect AI to connect to Dynamics CRM Data from Mode and build visualizations using live Dynamics CRM data.
-
Connect to Bannerbear Data from PowerBuilder via ADO.NET
This article demonstrates how to access Bannerbear data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Process & Analyze Zoho CRM Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Zoho CRM Data.
-
Automate Act-On Data Replication to Azure Synapse
Use CData Sync to customize and automate Act-On data replication to Azure Synapse.
-
How to create an RPA flow for Twitter Ads Data in UiPath Studio
Use the Twitter Ads ODBC Driver to create workflows that access real-time Twitter Ads data without any coding.
-
Connect to Phoenix Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Phoenix Data and connect to Phoenix data in Akorbi Digital RunMyProcess.
-
LINQ to Okta 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 Okta Data Provider.
-
Connect to Pipeline CRM Data in HULFT Integrate
Connect to Pipeline CRM as a JDBC data source in HULFT Integrate
-
Build a PostgreSQL Interface for Qualaroo Data using the CData JDBC Driver
Use the Remoting features of the Qualaroo JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build MailChimp-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to MailChimp Data from Zoho Analytics and import live MailChimp data.
-
How to Connect to Elasticsearch Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Elasticsearch data. Leverage the pyodbc module for ODBC in Python.
-
Create Blackbaud FE NXT-Connected Business Apps in AppSheet
Connect to Blackbaud FE NXT Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Blackbaud FE NXT data.
-
Integrate Live Figshare Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Figshare data and integrate live Figshare data into apps built in Microsoft Power Apps.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for PagerDuty
Provide connectivity to PagerDuty data through an SAP BusinessObjects universe.
-
Create Reports from WooCommerce Data in Looker Studio
Use CData Connect AI to gain access to live WooCommerce data and create custom reports in Looker Studio.
-
Query Grafana Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Grafana data from Node.js.
-
Build Freshdesk-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Freshdesk Data from Zoho Analytics and import live Freshdesk data.
-
Connect ADP Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your ADP data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Rapidly Develop OneNote-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 OneNote.
-
How to create an RPA flow for Coinbase Data in UiPath Studio
Use the Coinbase ODBC Driver to create workflows that access real-time Coinbase data without any coding.
-
Automate Exact Online Data Replication to SAP HANA
Use CData Sync to customize and automate Exact Online data replication to SAP HANA.
-
Query Omnisend Data in ColdFusion
Write standard ColdFusion data access code to connect to Omnisend data.
-
Create Reports with Google Tasks Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Google Tasks data.
-
Connect to Coda Data in Ruby
Connect to Coda data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Analyze Procore Data in Looker
Use CData Connect AI to connect to Procore Data from Looker and build custom apps using live Procore data.
-
Visualize ZohoExpense Data in TIBCO Spotfire through ADO.NET
Integrate ZohoExpense data into dashboards in TIBCO Spotfire.
-
Model, Search, and Visualize Live Toggl Data in ThoughtSpot
Use CData Connect AI to connect to live Toggl data for modeling, searching, and visualizing.
-
Integrate ConvertKit Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live ConvertKit data from Informatica Cloud.
-
How to connect to ZohoInvoice Data from IntelliJ
Integrate connectivity to ZohoInvoice data with wizards in IntelliJ.
-
Integrating Cursor with FreeAgent 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.
-
Use the CData SSIS Components to Insert New or Update Existing JSON Records from SQL Server
Easily push SQL Server data to JSON using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into JSON or update existing records with data from a SQL Server database.
-
Manage CouchDB Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for CouchDB.
-
Integrating Claude Code CLI with Coinbase 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 Clari Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Clari data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrate Goose with Live Sage 200 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Sage 200 data from within the local AI agent.
-
How to Query HelloSign Data in MySQL Workbench
Execute MySQL queries against live HelloSign data from MySQL Workbench.
-
Automated Continuous Google Translate Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Google Translate replication to PostgreSQL.
-
Automate Google Ads Data Replication to SAP HANA
Use CData Sync to customize and automate Google Ads data replication to SAP HANA.
-
Build Visualizations of Freshdesk Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Freshdesk data in Birst.
-
Integrate Sugar CRM Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Sugar CRM data from Informatica Cloud.
-
Access ZohoPeople Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live ZohoPeople data from HeidiSQL.
-
Trigger Google Calendar IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Google Calendar with standard wizards in Logic Apps.
-
Query Live SAP Fieldglass 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 SAP Fieldglass data through a conversational interface.
-
Automate SendPulse Integration Tasks from PowerShell
Are you in search of a quick and easy way to access SendPulse data from PowerShell? This article demonstrates how to utilize the SendPulse Cmdlets for tasks like connecting to SendPulse data, automating operations, downloading data, and more.