CData Software - Knowledge Base
Recent Articles
-
Integrate Superchat Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Superchat data from Informatica Cloud.
-
Access Live Sage 300 Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Sage 300 data from your Excel spreadsheets.
-
Automated Continuous Authorize.Net Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Authorize.Net replication to delimited files (CSV/TSV).
-
Build SAP Netweaver Gateway-Connected Apps in Choreo
Use CData Connect AI to connect to SAP Netweaver Gateway Data from Choreo and build custom apps using live SAP Netweaver Gateway data.
-
Connect to Dynamics CRM Data in DBArtisan
Use wizards in DBArtisan to configure Dynamics CRM data as a data source.
-
How to create Visio diagrams from MarkLogic Data
Automatically update MarkLogic data with the changes you make to Visio master shapes.
-
Connect to Google Ad Manager Data in NetBeans
Connect to Google Ad Manager data in NetBeans with the data source configuration wizard.
-
Visualize Live Zoho Creator Data in the Power BI Service
Use CData Connect AI to connect to live Zoho Creator data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build MVC Applications with Connectivity to MailerLite Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access MailerLite from an ASP.NET MVC application.
-
Import GitHub Data Using Azure Data Factory
Use CData Connect AI to connect to GitHub Data from Azure Data Factory and import live GitHub data.
-
Automated Continuous OData Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable OData replication to Apache Kafka.
-
How to use SQLAlchemy ORM to access Freshdesk Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Freshdesk data.
-
Automated Continuous Postmark Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Postmark replication to Apache Kafka.
-
Stream Act-On Data into Apache Kafka Topics
Access and stream Act-On data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Automated Continuous GitLab Replication to SQLite
Use CData Sync for automated, continuous, customizable GitLab replication to SQLite.
-
Automated Continuous Bitbucket Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Bitbucket replication to Google Cloud SQL.
-
How to Connect to Live Dynamics CRM Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Dynamics CRM data for you.
-
Use Dash to Build to Web Apps on Testmonitor Data
Create Python applications that use pandas and Dash to build Testmonitor-connected web apps.
-
Natively Connect to GitHub Data in PHP
The CData ODBC driver for GitHub enables you to create PHP applications with connectivity to GitHub data. Leverage the native support for ODBC in PHP.
-
Use the CData Software JDBC Driver for Redshift in MicroStrategy
Connect to Redshift data in MicroStrategy Developer using the CData Software JDBC Driver for Redshift.
-
Connect to Odoo from a Connection Pool in WebLogic
Use the CData JDBC Driver for Odoo to connect to Odoo data from Web applications running on WebLogic.
-
Visualize Figshare Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Figshare data.
-
Create SSAS Tabular Models from Snowflake Data
How to build a SQL Server Analysis Service Tabular Model from Snowflake data using CData drivers.
-
Use Grok to Talk to Your Certinia 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 Certinia data for you.
-
Build Anaplan-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Anaplan Data from Zoho Analytics and import live Anaplan data.
-
Use the CData Software ODBC Driver for Sage Intacct in SAS for Real-Time Reporting and Analytics
Connect to real-time Sage Intacct data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Sage Intacct.
-
Automate Databricks Data Replication to Azure Synapse
Use CData Sync to customize and automate Databricks data replication to Azure Synapse.
-
Build Pipelines with Live Mode Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Mode from Google Cloud Data Fusion, enabling the integration of live Mode data into the building and management of effective data pipelines.
-
Model SparkPost Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and SparkPost, enabling the direct import of real-time SparkPost data.
-
Integrating LangGraph with ZohoMarketingHub Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on ZohoMarketingHub data within automated workflows.
-
Query Omnisend Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Omnisend data from Node.js.
-
Analyze VWO Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of VWO data and visualize VWO data in SAP Analytics Cloud.
-
How to Connect Flowise AI Agents to Live Greenplum Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Greenplum data without replication.
-
Connect to Omnisend in SpagoBI
Create reports featuring live Omnisend data in SpagoBI Studio. Host Omnisend reports on SpagoBI Server.
-
LINQ to Printful 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 Printful Data Provider.
-
Import and Visualize Google Campaign Manager 360 Data in Power View
Create data visualizations based on Google Campaign Manager 360 data in Excel.
-
Connect to Google Spanner Data from PowerBuilder via JDBC
This article demonstrates how to access Google Spanner data from PowerBuilder using the Google Spanner JDBC Driver.
-
Integrating Dataiku with MySQL Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live MySQL data.
-
Access Live Jira Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Jira data into the statistical analysis tools available in SAS JMP. This article shows how to use Jira data in the Graph Builder and Query Builder.
-
Connect to Adobe Experience Manager Data in JRuby
Create a simple JRuby app with access to live Adobe Experience Manager data.
-
Connect to Oracle Eloqua Reporting Data in RapidMiner
Integrate Oracle Eloqua Reporting data with standard components and data source configuration wizards in RapidMiner Studio.
-
How to Connect the Power BI Service to SAP Business Warehouse: Complete Guide
Connect to the CData Software Power BI Connector for SAP Business Warehouse from PowerBI.com to provide real-time SAP Business Warehouse data across the organization.
-
Integrating Antigravity CLI with Microsoft Dataverse data via CData CLI
Connect Microsoft Dataverse data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect MySQL to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect MySQL with IBM WebSphere for seamless data integration and connectivity.
-
Getting Started with the CData Python Connector for Salesforce Marketing
Learn to install and license the CData Python Connector and configure a connection to live Salesforce Marketing data.
-
Build AI/ML Models with Live Pinecone Data using Dataiku
Connect Pinecone Data with Dataiku using the CData API Driver for JDBC.
-
Analyze Salesforce Marketing Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Salesforce Marketing data and visualize Salesforce Marketing data in SAP Analytics Cloud.
-
Rapidly Develop Zoho Creator-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 Zoho Creator.
-
Analyze Lakebase Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Lakebase data and visualize Lakebase data in SAP Analytics Cloud.
-
Access Twilio Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Twilio data from HeidiSQL.
-
Connect to Live WooCommerce Data in MicroStrategy through CData Connect AI
Create a live connection to WooCommerce Data in CData Connect AI and connect to your WooCommerce data from MicroStrategy.
-
Integrating Boomi Agentstudio with Amazon S3 Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Amazon S3 data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Natively Connect to OnePageCrm Data in PHP
The CData ODBC driver for OnePageCrm enables you to create PHP applications with connectivity to OnePageCrm data. Leverage the native support for ODBC in PHP.
-
Consume Access OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Access feeds that reflect any changes in SAP Lumira.
-
How to Query Live SharePoint Excel Services Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live SharePoint Excel Services data data in natural language using Python.
-
Connect to Dynamics 365 Business Central Data from PowerBuilder via ADO.NET
This article demonstrates how to access Dynamics 365 Business Central data from Appeon PowerBuilder using the CData ADO.NET Provider for Dynamics 365 Business Central.
-
How to Connect to Live AfterShip 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 AfterShip data for you.
-
Integrating Gumloop with Sage 200 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Sage 200 data within automated workflows.
-
Object-Relational Mapping (ORM) with Hubstaff Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Hubstaff data into a Java-based ORM framework, Hibernate.
-
Query Tanda Data in DataGrip
Create a Data Source for Tanda in DataGrip and use SQL to query live Tanda data.
-
DataBind Controls to Shopify Data in Delphi
DataBind to Shopify data in Delphi with standard data access components and controls.
-
Connecting GenSpark with Oracle Sales Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Oracle Sales data without any replication or custom integration required.
-
Connecting Agentforce with Twilio 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 Twilio data for you.
-
Integrate OpenCode with Live Smartsheet Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Smartsheet data from within your AI coding agent.
-
Automated Continuous Square Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Square replication to delimited files (CSV/TSV).
-
Connect to Zoho Creator Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Zoho Creator to connect to Zoho Creator data and execute queries in PowerBuilder.
-
Configure the CData JDBC Driver for ZohoDesk in a Connection Pool in Tomcat
Connect to ZohoDesk data from a connection pool in Tomcat.
-
Access Live Tally Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Tally data into the statistical analysis tools available in SAS JMP. This article shows how to use Tally data in the Graph Builder and Query Builder.
-
How to Connect to Live SAP Fieldglass Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live SAP Fieldglass data securely in real time.
-
Connect to Mailjet Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Mailjet Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Connect to Salesforce Marketing Data in JRuby
Create a simple JRuby app with access to live Salesforce Marketing data.
-
Analyze Discord Data in Cognos Analytics
Use CData Connect AI to connect to Discord Data from Cognos Analytics and analyze live Discord data.
-
How to Connect to Live Anaplan 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 Anaplan data for you.
-
Connecting Mastra with eBay 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 eBay data, no replication required.
-
Use Databricks Agent Bricks to Talk to Your Airtable Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Airtable data for you.
-
Build an OLAP Cube in SSAS from CouchDB Data
Establish a connection to CouchDB data data from SQL Server Analysis Services, and use the CouchDB Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to Work with Salesforce CRM Analytics Data in ETL Validator JDBC
Connect to Salesforce CRM Analytics from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Oracle Sales Data from HeidiSQL
Use CData Connect AI to connect to and query live Oracle Sales data from HeidiSQL.
-
Build Automated Dropbox-Connected Workflows in Zapier
Use CData Connect AI to connect to live Dropbox data and build automated workflows in Zapier.
-
Build MVC Applications with Connectivity to Bullhorn CRM Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Bullhorn CRM from an ASP.NET MVC application.
-
How to connect to SFTP Data from IntelliJ
Integrate connectivity to SFTP data with wizards in IntelliJ.
-
Create Informatica Mappings From/To an ODBC Data Source for SAP ByDesign
Create an ODBC connection to SAP ByDesign in Informatica and browse and transfer SAP ByDesign data.
-
Integrate Live Workable Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Workable data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Integrate Dify with Live xBase Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live xBase data.
-
Connect and Visualize Live SAP Ariba Procurement Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live SAP Ariba Procurement data into the Databricks platform and create visualization dashboards with real-time SAP Ariba Procurement data.
-
Explore Geographical Relationships in SparkPost Data with Power Map
Create data visualizations with SparkPost data in Power Map.
-
Publish SparkPost-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live SparkPost data.
-
Integrate with Customer.io Data in JReport Designer
Create charts and reports based on Customer.io data in JReport Designer.
-
Integrating Omnisend Data in Talend Cloud Data Management Platform
Connect Omnisend Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Create Apps from Blackbaud FE NXT Data in Qlik Sense Cloud
Use CData Connect AI to connect to Blackbaud FE NXT Data and build apps from live Blackbaud FE NXT data in Qlik Sense Cloud.
-
DataBind Mailjet Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Mailjet data to a chart.
-
Integrate Devin with Live Optimizely Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Optimizely data.
-
Replicate Shopify Data to Multiple Databases
Replicate Shopify data to disparate databases with a point-and-click configuration.
-
Connecting Pipedream with Exact Online Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Exact Online data in real time.
-
Using the CData Software ODBC Driver for CockroachDB in PyCharm
Connect to CockroachDB as an ODBC data source in PyCharm using the CData Software ODBC Driver for CockroachDB.
-
Integrate with live Okta Data in Jitterbit
Use CData Connect AI to connect to and integrate live Okta data in Jitterbit.
-
Automated Continuous JobNimbus Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable JobNimbus replication to PostgreSQL.
-
Automated Continuous Calendly Replication to SingleStore
Use CData Sync for automated, continuous, customizable Calendly replication to SingleStore.
-
How to Connect to Live Office 365 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 Office 365 data through natural language.
-
Write a Simple Go Application to work with ADP Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to ADP data.