CData Software - Knowledge Base
Recent Articles
-
Use the CData Software ODBC Driver for Reply.io in MicroStrategy
Connect to Reply.io in MicroStrategy Developer using the CData Software ODBC Driver for Reply.io.
-
Explore Geographical Relationships in Aweber Data with Power Map
Create data visualizations with Aweber in Power Map.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Mailgun
Provide connectivity to Mailgun through an SAP BusinessObjects universe.
-
Publish Crystal Reports on ZohoExpense Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date ZohoExpense.
-
Integrating Cursor CLI with ActiveCampaign 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.
-
Getting Started with the CData Power BI Connector for Quaderno
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Extend Google Sheets with RabbitMQ Data
Make calls to RabbitMQ from Google Apps Script via the API Server.
-
Analyze Webflow Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Webflow with the CData JDBC Driver for Webflow.
-
Build Dashboards with SAP Data in DBxtra
Create dynamic dashboards and perform analytics based on SAP ERP/NetWeaver in DBxtra.
-
Build Google Cloud Storage-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Google Cloud Storage to explore live Google Cloud Storage Data in Cursor to assist with building Google Cloud Storage-powered applications.
-
Automated Continuous LightSpeedRetail Replication to MongoDB
Use CData Sync for automated, continuous, customizable LightSpeedRetail replication to MongoDB.
-
Create Informatica Mappings From/To a JDBC Data Source for Tavily
Create Tavily data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to SAP Ariba Procurement Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live SAP Ariba Procurement from Filemaker Pro on Mac.
-
Build a PostgreSQL Interface for Azure Analysis Services Data using the CData JDBC Driver
Use the Remoting features of the Azure Analysis Services JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous ShipStation Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable ShipStation replication to OneLake in Microsoft Fabric.
-
Connect to Azure DevOps from Asprova with CData Software ODBC Driver for Azure DevOps
This article shows how to connect faster to Azure DevOps data from Asprova.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Box within intelligent workflows.
-
Connect to Basecamp Data in Google Apps Script via Connect AI
Use CData Connect AI to access Basecamp in Google Apps Script.
-
Access Live BigQuery Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Google BigQuery through MCP integration.
-
Connecting GenSpark with Redis Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Redis without any replication or custom integration required.
-
Connect to SharePoint Data in Claris FileMaker Pro
Use the CData ODBC Driver for SharePoint in FileMaker Pro to connect to SharePoint and work with Microsoft SharePoint in your FileMaker applications.
-
Automate Keap Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Keap and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Create Basecamp Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Basecamp data access from reports, embedded analytics, and more.
-
Automated Continuous PabblySubscriptions Replication to Databricks
Use CData Sync for automated, continuous, customizable PabblySubscriptions replication to Databricks.
-
Connect to HBase Data as an External Source in Dremio
Use the CData JDBC Driver to connect to HBase as an External Source in Dremio.
-
Integrate Open WebUI with Live Asana Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Asana from within the chat interface.
-
A PostgreSQL Interface for Gumroad Data using the CData ODBC Driver
Use the SQL Gateway and Gumroad ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to Access Shopify Data Using Entity Framework
This article shows how to access Shopify using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to Work with Aha! Data in AWS Glue Jobs Using JDBC
Connect to Aha! from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrate Open WebUI with Live Azure Data Lake Storage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Azure Data Lake Storage from within the chat interface.
-
Work with Microsoft Dataverse Data in FoxPro
Load Microsoft Dataverse (CDS) into a FoxPro database. This article includes full code and a walk-through of the process.
-
Replicate Greenhouse Data to Multiple Databases
Replicate Greenhouse to disparate databases with a point-and-click configuration.
-
Replicate Phoenix Data in Heroku for Use in Salesforce Connect
Replicate Apache Phoenix to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Use Dash to Build to Web Apps on Sybase Data
Create Python applications that use pandas and Dash to build Sybase-connected web apps.
-
Manage Google Tasks Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Google Tasks.
-
Automated Continuous Figshare Replication to Databricks
Use CData Sync for automated, continuous, customizable Figshare replication to Databricks.
-
Use the CData Software JDBC Driver for JotForm in MicroStrategy Desktop
Connect to JotForm in MicroStrategy Desktop using the CData Software JDBC Driver for JotForm.
-
Integrating GitHub Copilot CLI with FreeAgent 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.
-
Creating SAP SuccessFactors-Connected Applications in Unqork
You can use CData Connect AI to feed SAP SuccessFactors to Unqork and build custom business apps.
-
Automated Continuous Toggl Replication to MySQL
Use CData Sync for automated, continuous, customizable Toggl replication to MySQL.
-
Stream Amazon Marketplace Data into Apache Kafka Topics
Access and stream Amazon Marketplace in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to Connect the Power BI Service to Brex: Complete Guide
Connect to the CData Software Power BI Connector for Brex from PowerBI.com to provide real-time Brex across the organization.
-
Visualize Testmonitor Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Testmonitor.
-
Build Apps with Live Raisers Edge NXT Data Using the Low-Code Development Platform of Mendix
Connect Raisers Edge NXT with Mendix to build apps using the CData JDBC Driver for Raisers Edge NXT.
-
Model, Search, and Visualize Live Pipedrive Data in ThoughtSpot
Use CData Connect AI to connect to live Pipedrive for modeling, searching, and visualizing.
-
Using the CData Software ODBC Driver for Supabase in PyCharm
Connect to Supabase as an ODBC data source in PyCharm using the CData Software ODBC Driver for Supabase.
-
Connect to BigCommerce Data in Claris FileMaker Pro
Use the CData ODBC Driver for BigCommerce in FileMaker Pro to connect to BigCommerce and work with BigCommerce in your FileMaker applications.
-
Query WordPress Data from Node.js
Use the OData endpoint of the CData API Server to connect to your WordPress and perform CRUD operations on WordPress from Node.js.
-
How to Connect to Live LinkedIn Ads Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live LinkedIn Ads securely in real time.
-
Query SAP Ariba Source Data from Node.js
Use the OData endpoint of the CData API Server to connect to your SAP Ariba Source and perform CRUD operations on SAP Ariba Source from Node.js.
-
Integrating GitHub Copilot CLI with Notion 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.
-
Create Datasets from Anaplan in Domo Workbench and Build Visualizations of Anaplan Data in Domo
Use the CData Software ODBC Driver for Anaplan to create datasets from Anaplan in Domo Workbench and then build visualizations in the Domo service.
-
Migrating data from Jira to Snowflake using CData SSIS Components.
Easily push Atlassian Jira to Snowflake using the CData SSIS Tasks for Jira and Snowflake.
-
Connect to Procore Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Procore using standard SQL.
-
How to Create Power BI Visual Reports with Real-Time ConstantContact Data
Use CData Power BI Connectors to visualize ConstantContact in Power BI.
-
How to Visualize Suadeo Data in Python with pandas
Use pandas and other modules to analyze and visualize live Suadeo in Python.
-
Use Azure AI Foundry to Talk to Your Procore Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Procore for you.
-
How to Connect to Strava Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Strava. Leverage the pyodbc module for ODBC in Python.
-
Publish CapsuleCRM-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live CapsuleCRM.
-
Migrating data from Contentful to Databricks using CData SSIS Components.
Easily push Contentful to Databricks using the CData SSIS Tasks for Contentful and Databricks.
-
Use the CData SSIS Components to Insert New or Update Existing Teradata Records from SQL Server
Easily push SQL Server data to Teradata using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Teradata or update existing records with data from a SQL Server database.
-
How to Connect to Live Avalara AvaTax Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Avalara AvaTax for you.
-
Salesforce CRM Analytics Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Salesforce CRM Analytics through CData Connect AI using different applications and tools.
-
Use Grok to Talk to Your Smartsheet 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 Smartsheet for you.
-
Use the CData Software ODBC Driver for Perigon in MicroStrategy
Connect to Perigon in MicroStrategy Developer using the CData Software ODBC Driver for Perigon.
-
Automated Continuous Outreach.io Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Outreach.io replication to delimited files (CSV/TSV).
-
Integrating Kiro CLI with Reckon 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.
-
Create a Data Access Object for Campaigner Data using JDBI
A brief overview of creating a SQL Object API for Campaigner in JDBI.
-
Build Dashboards with FormSite Data in Dundas BI
Create dynamic dashboards and perform analytics based on FormSite in Dundas BI.
-
Integrate Real-Time Access to Couchbase in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Couchbase in real time.
-
Connect to SAP Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Build Semantic Layer Views for Calendly Data in APOS Live Data Gateway
Use the CData Connector for Calendly in APOS Live Data Gateway to build Semantic Layer Views for Calendly.
-
Create SSAS Tabular Models from Amazon Marketplace Data
How to build a SQL Server Analysis Service Tabular Model from Amazon Marketplace using CData drivers.
-
How to use SQLAlchemy ORM to access Greenhouse Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Greenhouse.
-
Connect to Real-Time Mode Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Mode in Power Apps.
-
Build Dashboards with Freshsales Data in Dundas BI
Create dynamic dashboards and perform analytics based on Freshsales in Dundas BI.
-
Create Dashboards and Visualize Live Paylocity Data in Geckoboard
Use CData Connect AI to connect to live Paylocity and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Publish Sugar CRM-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Sugar CRM.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Sybase using the Model Context Protocol.
-
How to load Gumroad data into Elasticsearch via Logstash
Introducing a simple method to load Gumroad data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Create ShipStation-Connected Dashboards in Grafana
Connect to ShipStation Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to ShipStation.
-
Analyze Bullhorn CRM Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Bullhorn CRM in Microsoft R Open.
-
Automated Continuous Cosmos DB Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Cosmos DB replication to IBM DB2.
-
Manage Quaderno Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Quaderno.
-
How to Build an ETL App for Foursquare Data in Python with CData
Create ETL applications and real-time data pipelines for Foursquare in Python with petl.
-
Use Databricks Agent Bricks to Talk to Your QuickBooks Online Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your QuickBooks Online for you.
-
How to Connect to Live Redshift 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 Amazon Redshift for you.
-
DataBind Controls to Perplexity Data in Delphi
DataBind to Perplexity in Delphi with standard data access components and controls.
-
Replicate Mailgun Data in Heroku for Use in Salesforce Connect
Replicate Mailgun to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Integrate Real-Time Access to Accelo in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Accelo in real time.
-
Work with Live AlloyDB Data in Power Query
Use CData Connect AI to connect to Google AlloyDB and work with live Google AlloyDB in Microsoft Power Query.
-
Publish Crystal Reports on NASA Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date NASA.
-
Access Live Confluence Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Atlassian Confluence from your Excel spreadsheets.
-
Build Charts with Act CRM Data in Clear Analytics
Create dynamic charts and perform analytics based on Act CRM in Clear Analytics.
-
Connect to ChargeOver in SpagoBI
Create reports featuring live ChargeOver in SpagoBI Studio. Host ChargeOver reports on SpagoBI Server.
-
Build Gorgias-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData API Driver for MCP Server to explore live Gorgias Data in GitHub Copilot to assist with building Gorgias-powered applications.
-
Create Power BI Reports on Real-Time PivotalTracker Data
Use the CData ODBC Driver for PivotalTracker to visualize PivotalTracker in Power BI Desktop.
-
Getting Started with the CData Python Connector for Opsgenie
Learn to install and license the CData Python Connector
-
Automated Continuous Certinia Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Certinia replication to Google BigQuery.
-
Connect to and Query MYOB AccountRight Data in QlikView over ODBC
Create data visualizations with MYOB AccountRight in QlikView.