CData Software - Knowledge Base
Recent Articles
-
Build Cosmos DB-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Cosmos DB Data and create custom apps in Mendix.
-
How to connect to ConstantContact Data in DBVisualizer
Integrate ConstantContact with visual data analysis tools and data connection wizards in DBVisualizer
-
Query Cvent Data in ColdFusion
Write standard ColdFusion data access code to connect to Cvent.
-
Connect to IBM Informix Data in Google Apps Script via Connect AI
Use CData Connect AI to access IBM Informix in Google Apps Script.
-
Automated Continuous Oracle Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Oracle replication to AlloyDB.
-
Integrating Claude Code with BigCommerce Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on BigCommerce within assisted coding and automated development workflows.
-
Choosing the Best Method to Connect Suadeo to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Suadeo from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Query Cosmos DB Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Cosmos DB entities in PHP by modeling them as objects.
-
Use the CData Software JDBC Driver for Freshservice in MicroStrategy Desktop
Connect to Freshservice in MicroStrategy Desktop using the CData Software JDBC Driver for Freshservice.
-
How to Work with Wrike Data in AWS Glue Jobs Using JDBC
Connect to Wrike from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Visualize Salesforce Pardot Data in TIBCO Spotfire through ADO.NET
Integrate Salesforce Pardot into dashboards in TIBCO Spotfire.
-
Bidirectional Access to Databricks Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Databricks in Filemaker Pro for Mac or Windows.
-
Import Real-Time Zoom Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Zoom in ColdFusion.
-
Visualize Cvent Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Cvent into TIBCO Spotfire.
-
Connect Gumroad Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Gumroad using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Analyze DocuSign Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of DocuSign and visualize DocuSign in SAP Analytics Cloud.
-
Automated Continuous Square Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Square replication to AlloyDB.
-
Analyze ZarMoney Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze ZarMoney in Microsoft R Open.
-
How to Connect DBeaver to Short.io via a JDBC Driver
Manage Short.io with visual tools in DBeaver like the query browser.
-
Create Power BI Reports on Real-Time LionDesk Data
Use the CData ODBC Driver for LionDesk to visualize LionDesk in Power BI Desktop.
-
Connecting Moonlit Workflow with Active Directory 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 Active Directory in real time.
-
Write a Simple Go Application to work with Hive Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Apache Hive.
-
Build Dashboards with Sentry Data in DBxtra
Create dynamic dashboards and perform analytics based on Sentry in DBxtra.
-
Import Real-Time Gmail Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Gmail in ColdFusion.
-
Build Data Flows from Jira Assets to SQL Server using SSIS
Easily back up Jira Assets to SQL Server using the SSIS components for Jira Assets.
-
Replicate Pingdom Data to Multiple Databases via the CData Sync CLI
Replicate Pingdom to disparate databases with a single configuration.
-
How to Connect to Live Dropbox 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 Dropbox through natural language.
-
Connect to Codat Data in DBeaver
Use the CData ODBC Driver to connect to Codat in DBeaver.
-
How to use SQLAlchemy ORM to access Facebook Ads Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Facebook Ads.
-
Build Semantic Layer Views for Avalara AvaTax Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Avalara AvaTax.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for OData
Provide connectivity to OData through an SAP BusinessObjects universe.
-
Build Agents in Relevance AI with Access to Live Pipedrive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Pipedrive within intelligent agent workflows.
-
Connect to Toggl Data in RapidMiner
Integrate Toggl with standard components and data source configuration wizards in RapidMiner Studio.
-
Automated Continuous CampaignMonitor Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable CampaignMonitor replication to Amazon Redshift.
-
Connect to Azure Analysis Services Data in NetBeans
Connect to Azure Analysis Services in NetBeans with the data source configuration wizard.
-
How to Connect API Data Sources to Power BI Using CData API Driver
This article explains how to use the CData API Driver for Power BI to connect to any REST API data source and analyze data in Power BI Desktop.
-
ETL Google Sheets in Oracle Data Integrator
This article shows how to transfer Google Sheets into a data warehouse using Oracle Data Integrator.
-
Work with Sendwithus Data in FoxPro
Load Sendwithus into a FoxPro database. This article includes full code and a walk-through of the process.
-
Working with Eventbrite Data in LINQPad
Execute LINQ queries to Eventbrite in LINQPad.
-
Automated Continuous Excel Online Replication to Oracle
Use CData Sync for automated, continuous, customizable Excel Online replication to Oracle.
-
Use Manus AI to Talk to Your Oracle Service Cloud 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 Oracle Service Cloud.
-
A PostgreSQL Interface for SAP Fieldglass Data using the CData ODBC Driver
Use the SQL Gateway and SAP Fieldglass ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect to Live Trello 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 Trello for you.
-
Access SAP Business One Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SAP Business One from your Oracle system.
-
Working with Zoho Recruit Data in LINQPad
Execute LINQ queries to Zoho Recruit in LINQPad.
-
How to connect to Avro Data from IntelliJ
Integrate connectivity to Apache Avro with wizards in IntelliJ.
-
Visualize Live Pipedrive Data in the Power BI Service
Use CData Connect AI to connect to live Pipedrive and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to publish and share Mode Data dashboards with Tableau Server
The CData ODBC driver for Mode enables you integrate Mode into Tableau dashboards.
-
Automated Continuous Blackbaud FE NXT Replication to SQL Server
Use CData Sync for automated, continuous, customizable Blackbaud FE NXT replication to SQL Server.
-
Configure the CData JDBC Driver for Mixpanel in a Connection Pool in Tomcat
Connect to Mixpanel from a connection pool in Tomcat.
-
Integrating Claude Code CLI with Reckon Accounts Hosted 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 SSAS Tabular Models from Confluence Data
How to build a SQL Server Analysis Service Tabular Model from Atlassian Confluence using CData drivers.
-
Connect to Helpscout Data in Jaspersoft Studio
Execute SQL to remote Helpscout in Jaspersoft Studio.
-
Visualize Live Webflow Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Webflow.
-
Import CouchDB Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to CouchDB Data and provide access to live Apache CouchDB for custom reports in the Power BI Service.
-
How to connect PolyBase to Tanda
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Tanda.
-
Build a Simple VCL Application for Klaviyo Data
How to build a simple VCL Application to view Klaviyo in RAD Studio using the CData ODBC Driver for Klaviyo.
-
Use the CData Software JDBC Driver for TaxJar in MicroStrategy
Connect to TaxJar in MicroStrategy Developer using the CData Software JDBC Driver for TaxJar.
-
Analyze CSV Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of CSV/TSV Files and visualize CSV/TSV Files in SAP Analytics Cloud.
-
Build AI Agents with SAP BusinessObjects BI 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 SAP BusinessObjects BI through CData Connect AI.
-
Configure the CData JDBC Driver for GraphQL in a Connection Pool in Tomcat
Connect to GraphQL from a connection pool in Tomcat.
-
How to Connect DBeaver to FHIR via a JDBC Driver
Manage FHIR with visual tools in DBeaver like the query browser.
-
Connect to Real-Time Basecamp Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Basecamp and Dataflow to import and use Basecamp in Power Apps.
-
Access Live ClickTime Data in AWS Lambda (with IntelliJ IDEA)
Connect to live ClickTime in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrate Shopify with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Shopify with External Services.
-
Use the CData Software ODBC Driver for Outreach.io in MicroStrategy Desktop
Connect to Outreach.io in MicroStrategy Desktop using the CData Software ODBC Driver for Outreach.io.
-
How to Visualize Eventbrite Data in Python with pandas
Use pandas and other modules to analyze and visualize live Eventbrite in Python.
-
Create Informatica Mappings From/To a JDBC Data Source for Smartsheet
Create Smartsheet data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Migrating data from SAP Netweaver Gateway to Snowflake using CData SSIS Components.
Easily push SAP Netweaver Gateway to Snowflake using the CData SSIS Tasks for SAP Netweaver Gateway and Snowflake.
-
Connect Flowlu to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Flowlu with IBM WebSphere for seamless data integration and connectivity.
-
Create Datasets from ConvertKit in Domo Workbench and Build Visualizations of ConvertKit Data in Domo
Use the CData Software ODBC Driver for ConvertKit to create datasets from ConvertKit in Domo Workbench and then build visualizations in the Domo service.
-
Connect to and Visualize Live Salesforce Pardot Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Salesforce Pardot.
-
Connect to Access Data in HULFT Integrate
Connect to Access as a JDBC data source in HULFT Integrate
-
Easily Integrate OneNote Data in Lazarus Pascal IDE
Learn how to easily integrate live Microsoft OneNote in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Integrating Antigravity CLI with Calendly via CData CLI
Connect Calendly to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Visualize Live Oracle HCM Cloud Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Oracle HCM Cloud.
-
Build a Simple VCL Application for Paymo Data
How to build a simple VCL Application to view Paymo in RAD Studio using the CData ODBC Driver for Paymo.
-
Integrating LangChain with Zoho Books Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Zoho Books within automated workflows.
-
Migrating data from Salesforce to Databricks using CData SSIS Components.
Easily push Salesforce & Force.com to Databricks using the CData SSIS Tasks for Salesforce and Databricks.
-
DataBind Accelo Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Accelo to a chart.
-
Rapidly Develop Mouseflow-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 Mouseflow.
-
Connecting Mastra with Xero 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 Xero Accounting, no replication required.
-
Query Printful Data as a MySQL Database in Node.js
Execute MySQL queries against Printful from Node.js.
-
Import and Visualize Dynamics 365 Business Central Data in Power View
Create data visualizations based on Dynamics 365 Business Central in Excel.
-
Getting Started with the CData Connect AI Python SDK for Gong
Install the CData Connect AI Python SDK to read and write live Gong with standard DB-API 2.0 Python code.
-
Connect to MailChimp Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time MailChimp using standard SQL.
-
Work with Adobe Analytics Data in FoxPro
Load Adobe Analytics into a FoxPro database. This article includes full code and a walk-through of the process.
-
Access Live Quickbase Data in Excel 365 Online (Excel for the web)
Connect to Quickbase from Excel 365 Online (Excel for the web) with CData Connect AI.
-
How to import PagerDuty Data into Apache Solr
Use the CData Software JDBC Driver for PagerDuty in Data Import Handler and create an automated import of PagerDuty to Apache Solr Enterprise Search platform.
-
Use Dash to Build to Web Apps on Twilio Data
Create Python applications that use pandas and Dash to build Twilio-connected web apps.
-
Work with SAP Hybris C4C Data in FoxPro
Load SAP Hybris C4C into a FoxPro database. This article includes full code and a walk-through of the process.
-
Automated Continuous Planio Replication to Vertica
Use CData Sync for automated, continuous, customizable Planio replication to Vertica.
-
Use the CData Software JDBC Driver for Teamwork in MicroStrategy Web
Connect to Teamwork in MicroStrategy Web using the CData Software JDBC Driver for Teamwork.
-
Integrating Kiro CLI with ClickTime 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.
-
Integrate Real-Time Access to Oracle SCM in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Oracle SCM in real time.
-
Integrate LDAP Objects in the Pentaho Report Designer
Publish reports based on LDAP in the Pentaho BI tool.
-
Use the CData ODBC Driver for Quickbase from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Quickbase to connect to Quickbase from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Quickbase in Excel.
-
How to work with Webflow Data in Apache Spark using SQL
Access and process Webflow Data in Apache Spark using the CData Software JDBC Driver.
-
How to Query Live Vault CRM Data in Perplexity MacOS Desktop
Connect to and query live Vault CRM Data in Perplexity Desktop using CData MCP Server.
-
Automated Continuous ConvertKit Replication to Oracle
Use CData Sync for automated, continuous, customizable ConvertKit replication to Oracle.