CData Software - Knowledge Base
Recent Articles
-
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.
-
Stream Act-On Data into Apache Kafka Topics
Access and stream Act-On 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 Microsoft Dynamics CRM 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. Leverage the native support for ODBC in PHP.
-
Query Azure Data Catalog Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Azure Data Catalog and perform CRUD operations on Azure Data Catalog from Node.js.
-
Use the CData Software JDBC Driver for Redshift in MicroStrategy
Connect to Amazon Redshift 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 ERP from Web applications running on WebLogic.
-
Visualize Figshare Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Figshare.
-
Create SSAS Tabular Models from Snowflake Data
How to build a SQL Server Analysis Service Tabular Model from Snowflake 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 for you.
-
Use the CData Software ODBC Driver for Sage Intacct in SAS for Real-Time Reporting and Analytics
Connect to real-time Sage Intacct 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 replication to Azure Synapse.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Blackbaud FE NXT to Power BI dashboards. Simply drag and drop Blackbaud FE NXT into data visuals on the Power BI canvas.
-
Query Omnisend Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Omnisend from Node.js.
-
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 Pivotal GreenPlum without replication.
-
Connect to Omnisend in SpagoBI
Create reports featuring live Omnisend 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 in Excel.
-
Connect to Google Spanner Data from PowerBuilder via JDBC
This article demonstrates how to access Google Spanner 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.
-
Access Live Jira Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Atlassian Jira into the statistical analysis tools available in SAS JMP. This article shows how to use Atlassian Jira 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.
-
How to Query Live Couchbase Data in Perplexity MacOS Desktop
Connect to and query live Couchbase Data in Perplexity Desktop using CData MCP Server.
-
Connect to Oracle Eloqua Reporting Data in RapidMiner
Integrate Oracle Eloqua Reporting 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 across the organization.
-
Integrating Antigravity CLI with Microsoft Dataverse (CDS) via CData CLI
Connect Microsoft Dataverse (CDS) 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
-
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 Cloud and visualize Salesforce Marketing Cloud 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 and visualize Lakebase in SAP Analytics Cloud.
-
Edit and Search Sage 200 External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Sage 200 to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Sage 200 objects that you can access from apps and the dashboard.
-
Access Twilio Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Twilio 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 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, 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. 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 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 from Appeon PowerBuilder using the CData ADO.NET Provider for Dynamics 365 Business Central.
-
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 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 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.
-
DataBind Controls to Shopify Data in Delphi
DataBind to Shopify 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 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 for you.
-
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 and execute queries in PowerBuilder.
-
Configure the CData JDBC Driver for ZohoDesk in a Connection Pool in Tomcat
Connect to ZohoDesk 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 ERP into the statistical analysis tools available in SAS JMP. This article shows how to use Tally ERP 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 securely in real time.
-
Connect to Salesforce Marketing Data in JRuby
Create a simple JRuby app with access to live Salesforce Marketing Cloud.
-
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, 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 for you.
-
Build an OLAP Cube in SSAS from CouchDB Data
Establish a connection to Apache CouchDB 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 from HeidiSQL.
-
Access Live PivotalTracker Data in AWS Lambda (with IntelliJ IDEA)
Connect to live PivotalTracker in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Build Automated Dropbox-Connected Workflows in Zapier
Use CData Connect AI to connect to live Dropbox 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 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 Business ByDesign.
-
Integrate Live Workable Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Workable to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
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 into the Databricks platform and create visualization dashboards with real-time SAP Ariba Procurement.
-
Explore Geographical Relationships in SparkPost Data with Power Map
Create data visualizations with SparkPost in Power Map.
-
Publish SparkPost-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live SparkPost.
-
Integrate with Customer.io Data in JReport Designer
Create charts and reports based on Customer.io 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 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 to a chart.
-
Replicate Shopify Data to Multiple Databases
Replicate Shopify 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 in Jitterbit.
-
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 Microsoft Office 365 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.
-
Import Real-Time Dropbox Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Dropbox in ColdFusion.
-
Build ShipStation-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to ShipStation Data from Zoho Analytics and import live ShipStation.
-
Add Reckon Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Reckon with the Informatica Enterprise Data Catalog to classify and organize data.
-
Replicate Oracle Eloqua Data in Heroku for Use in Salesforce Connect
Replicate Oracle Eloqua to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to Workday Data in HULFT Integrate
Connect to Workday as a JDBC data source in HULFT Integrate
-
Connect to Live Spark Data in MicroStrategy through CData Connect AI
Create a live connection to Spark Data in CData Connect AI and connect to your Apache Spark SQL from MicroStrategy.
-
Build Apps with Live Omnisend Data Using the Low-Code Development Platform of Mendix
Connect Omnisend with Mendix to build apps using the CData API Driver for JDBC.
-
Connect to Oracle SCM Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Oracle SCM.
-
Choosing the Best Method to Connect SpaceX to SQL Server: 5 Options Explained
Discover multiple ways to connect and use SpaceX from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Build Dashboards with Planio Data in DBxtra
Create dynamic dashboards and perform analytics based on Planio in DBxtra.
-
How to Work with Box Data in ETL Validator JDBC
Connect to Box from ETL Validator jobs using the CData Software JDBC Driver.
-
How to connect PolyBase to Wave Financial
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Wave Financial.
-
Build NetSuite-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live NetSuite CRM & ERP.
-
Create Power BI Reports on Real-Time Presto Data
Use the CData ODBC Driver for Presto to visualize Presto in Power BI Desktop.
-
WooCommerce Reporting in OBIEE with the WooCommerce JDBC Driver
Deploy the WooCommerce JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Build Paylocity-Connected Apps in Choreo
Use CData Connect AI to connect to Paylocity Data from Choreo and build custom apps using live Paylocity.
-
Connecting Agentforce with Zoho Books 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 Zoho Books for you.
-
Work with Live Google Cloud Storage Data in Power Query
Use CData Connect AI to connect to Google Cloud Storage and work with live Google Cloud Storage in Microsoft Power Query.
-
Connect to Cvent Data in RazorSQL
Connect to Cvent from wizards and query Cvent from the GUI in the RazorSQL database management tool.